Sites anglophones


SQL SERVER – APPROX_COUNT_DISTINCT – Not Always Efficient

Publié le 11 décembre 2019 sur journey to sqlauthority
 

One thing I keep on telling my clients that it is not that always recommended to use the latest feature without proper testing. I was recently hired by clients to help them with tuning a query for SQL Server 2019 Comprehensive Database Performance Heal …

Analyze and Improve SQL Server Backup Schedule

Publié le 11 décembre 2019 sur sqlservercentral.com
 

The post Analyze and Improve SQL Server Backup Schedule appeared first on SQLServerCentral.

SQL SERVER – List Number Queries Waiting for Memory Grant Pending

Publié le 10 décembre 2019 sur journey to sqlauthority
 

I have been recently writing about Memory Grant Feedback a lot and I have received a lot of questions about it. I have been answering each of them personally but some questions are so good that I feel like answering them on the blog will help more peop …

Deploying Data and Schema Together with SQL Compare or SQL Change Automation

Publié le 10 décembre 2019 sur sqlservercentral.com
 

The post Deploying Data and Schema Together with SQL Compare or SQL Change Automation appeared first on SQLServerCentral.

SQL Server Name Convention and T-SQL Programming Style

Publié le 10 décembre 2019 sur sqlservercentral.com
 

There are only two hard things in Computer Science: cache invalidation and naming things — Phil Karlton The recommendations in this article are not the ultimate truth. Please consider this article as a rule template that you can adapt to your nee …

Upsizing the SQL ConstantCare® Database Servers

Publié le 9 décembre 2019 sur brentozar.com
 

If you’re looking for SQL Server news, just skip this post. I’m going to talk about general business & capacity planning type stuff here today. Our SQL ConstantCare® customers install an app that polls diagnostic data from their SQL …

SQL SERVER – Row Mode and Memory Grant Feedback

Publié le 9 décembre 2019 sur journey to sqlauthority
 

Earlier this year, I had a great time writing on the Memory Grant Feedback. I have received a lot of questions about this feature and I have tried my best to answer each of them. One of the questions, which really caught my attention did this feature w …

Increase Query Speed with Covering Indexes

Publié le 9 décembre 2019 sur sqlservercentral.com
 

Improving the response times of queries in SQL Server is a common task for DBAs and developers. In this article, we will talk about how you can effectively use covered indexes to improve your performance, and when you should use them. What is a coverin …

What is the Priority of Database Scoped Configurations? – Interview Question of the Week #254

Publié le 8 décembre 2019 sur journey to sqlauthority
 

Question: What is the Priority of Database Scoped Configurations over Global Configuration at Server Level?Answer: This is a follow-up question of what I have earlier discussed in the previous blog post SQL SERVER – Database Scoped Configurations …

SQL SERVER – Database Scoped Configurations

Publié le 7 décembre 2019 sur journey to sqlauthority
 

What I enjoy the most while working on difficult and different challenges every single day with Comprehensive Database Performance Health Check. Recently I was asked a very interesting question by one of my clients on the topic of Database Scoped Confi …

Encrypted Stored Procedures and Query Store

Publié le 6 décembre 2019 sur SQLSkills.com - Erin Stellato
 

Very often I get interesting questions from the community, and most recently someone asked about encrypted stored procedures and Query Store.  Here’s the question (paraphrased):I have some encrypted stored procedures in one of my vendor data …

SQL SERVER – Mismatch Between sys.database_files and sys.master_files For TempDB Database

Publié le 6 décembre 2019 sur journey to sqlauthority
 

SQL Server is a great product and sometimes some “By Design” behaviors cause interesting unexpected issues which is hard to understand unless you are an expert! In this blog, I would share my knowledge and findings of a situation where ther …

Understanding Azure Storage Options

Publié le 6 décembre 2019 sur sqlservercentral.com
 

The post Understanding Azure Storage Options appeared first on SQLServerCentral.

From Source Control to Database using SQL Compare Command Line

Publié le 6 décembre 2019 sur sqlservercentral.com
 

The post From Source Control to Database using SQL Compare Command Line appeared first on SQLServerCentral.

SQL PASS 2019 – Session Feedback – Elementary! The Curious Case of Deceptive Query Optimizer

Publié le 5 décembre 2019 sur journey to sqlauthority
 

Earlier this year, I presented a technical session on SQL Server Performance Tuning at SQL PASS 2019 at Seattle. Let us see the session feedback of Elementary! The Curious Case of Deceptive Query Optimizer. I have built this entire session from my expe …


Pages :