SQL SERVER – APPROX_COUNT_DISTINCT – Not Always Efficient
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
The post Analyze and Improve SQL Server Backup Schedule appeared first on SQLServerCentral.
SQL SERVER – List Number Queries Waiting for Memory Grant Pending
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
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
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
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
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
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
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
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
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
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
The post Understanding Azure Storage Options appeared first on SQLServerCentral.
From Source Control to Database using SQL Compare Command Line
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
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 …