During the Comprehensive Database Performance Health Check, I had also helped the client build a query to list active and inactive VLF.
SQL SERVER – Reducing TempDB Recompilation with Fixed Plan
Let us talk about how we were able to reduce tempdb recompilation with Fixed Plan while working on Comprehensive Database Performance Health Check.
SQL SERVER Tools I Use and Recommend (Updated: March 2020)
Here is the updated list for March 2020 of all the tools which I recommend. Do let me know if you use any of the above tools.
SQL SERVER – Msg 17177 – This Instance of SQL Server Has Been Using a Process ID of %s since %s (local) %s (UTC)
In this blog today, I would share my understanding of the message “This instance of SQL Server has been using a process ID of”
How to Do Case Insensitive Search? – Interview Question of the Week #267
Question: How to Do Case Insensitive Search?
Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data.
SQL SERVER – Remove All Query Cached Plans Not Used In Certain Period
Recently I got a very unique situation where I had to Remove All Query Cached Plans Not Used In Certain Period. Let us learn about that today.
SQL SERVER Management Studio – Rebuild All Indexes on Table
We are going to see a very simple trick about SQL SERVER Management Studio (SSMS), where we will learn how to rebuild all indexes.
SQL SERVER – Count NULL Values From Column
I have received a very simple but interesting question by one of my earlier clients about how to count NULL values from the column.
SQL SERVER – Install Error – The Account Running SQL Server Setup Does Not Have Administrator Rights On the Computer. To Continue, Use an Account With Administrator Rights
In this blog, I would share the steps to identify and fix error – The account running SQL Server Setup does not have administrator rights on the computer.
SQL SERVER – Truncating Data and ANSI_WARNINGS
Today’s blog subject of Truncating Data and ANSI_WARNINGS was accidentally discovered while working on the Comprehensive Health Check.