Sites anglophones


Handling Aggregations on a Poorly Designed Database

Publié le 17 février 2020 sur sqlservercentral.com
 

Problem A few weeks back, I got a chance to work on a legacy application for one of my old clients. They had this desktop application setup that used SQL views to display the data and aggregations while Stored Procedures were used to directly interact …

Using SQL Server RAND Function Deep Dive

Publié le 17 février 2020 sur sqlservercentral.com
 

The post Using SQL Server RAND Function Deep Dive appeared first on SQLServerCentral.

How to Measure Resource Status on Azure? – Interview Question of the Week #264

Publié le 16 février 2020 sur journey to sqlauthority
 

Question: How to Measure Resource Status on Azure?Answer: While I work on Comprehensive Database Performance Health Check, I get to work on on-premises SQL Server deployments as well as Microsoft Azure. Every single time when I start working with Azure …

MySQL – Download Sample Database – Sakila, World, Employee

Publié le 15 février 2020 sur journey to sqlauthority
 

Just like SQL Server, I do consult with MySQL, PostgreSQL, and MariaDB. One of the most popular questions, I often receive during my consulting engagement is that where can one download the sample database for various databases. While we should always …

Beginner Guide to In-Memory Optimized Tables in SQL Server

Publié le 14 février 2020 sur simple-talk.com
 

Sometimes when I try to learn about a concept my brain blocks out everything about it. Talking about anything that uses the In-Memory concept tends to do this to me on occasion. It’s important to note that In-Memory is a marketing term for a seri …

Creating Time-Intelligence Functions in DAX

Publié le 14 février 2020 sur simple-talk.com
 

The series so far: Creating Calculated Columns Using DAX Creating Measures Using DAX Using the DAX Calculate and Values Functions Using the FILTER Function in DAX Cracking DAX – the EARLIER and RANKX Functions Using Calendars and Dates in Po …

SQL SERVER – SSMS Install Error 0x80070652 – Setup is Blocked Due to Another Install Currently running. Please Let the Other Install Complete and then Restart the Computer if Necessary

Publié le 14 février 2020 sur journey to sqlauthority
 

While preparing for a demo for my client Comprehensive Database Performance Health Check, I was installing necessary applications on my laptop. In this blog, I would share my experience with SQL Server Management Studio SSMS install error – Setup …

Simple DBCC CHECKDB process to report on database corruption for all SQL Server databases

Publié le 14 février 2020 sur sqlservercentral.com
 

The post Simple DBCC CHECKDB process to report on database corruption for all SQL Server databases appeared first on SQLServerCentral.

Checking for Database Events Using Extended Events and SQL Monitor

Publié le 14 février 2020 sur sqlservercentral.com
 

The post Checking for Database Events Using Extended Events and SQL Monitor appeared first on SQLServerCentral.

A quick search without an index

Publié le 14 février 2020 sur sqlservercentral.com
 

The Issue at hand We all have days at work when someone comes to us with that truly impossible request which will require a miracle to accomplish. Mine happened when a coworker from Marketing approached me with a seemingly simple one: if I could fetch …

Transactional Replication Use Cases

Publié le 13 février 2020 sur sqlskills - jonathan kehayas
 

This blog post is a part of a series on SQL Server Transactional Replication.  If you want to find the other posts in the series, check out the main page for the series here.Why Transactional Replication?Why in the world would you want to use Tran …

How to Pass a List of Values Into a Stored Procedure

Publié le 13 février 2020 sur brentozar.com
 

Say we have a stored procedure that queries the Stack Overflow Users table to find people in a given location. Here’s what the table looks like: And here’s what my starting stored procedure looks like:CREATE OR ALTER PROC dbo.usp_SearchUser …

SQL SERVER – Poor Indexing Strategies – 10 Don’ts for Indexes

Publié le 13 février 2020 sur journey to sqlauthority
 

Earlier this week, I wrote a blog post about SQL SERVER – Top Reasons for Slow Performance. The blog post got extremely popular as it contained many real-world problems and suggestions. After the blog post was released, I received quite many emai …

What Should I Submit to the PASS Summit?

Publié le 12 février 2020 sur brentozar.com
 

Our industry’s biggest conference, the PASS Summit 2020, just opened their pre-conference workshop call for speakers. I’m going to submit a couple of sessions, but I want to hear from you first: if you were going to try to convince your bos …

SQL SERVER – Disable Parameter Sniffing with DISABLE_PARAMETER_SNIFFING Query Hint

Publié le 12 février 2020 sur journey to sqlauthority
 

The journey of consulting is always a fun one with lots of learning. Recently during the Comprehensive Database Performance Health Check, I had a great conversation about how to disable Parameter Sniffing and DISABLE_PARAMETER_SNIFFING Query Hint. The …


Pages :