It has been over a decade since the comment DBCC DBREINDEX has been deprecated, however, once in a while I still encounter them while working with clients.
SQL SERVER – Performance Impact of Unique Index
In the latest Comprehensive Database Performance Health Check engagement, we had a very interesting situation of Performance Impact of Unique Index.
Free Video – SQL Server Performance Tuning Made Easy – Conference Session Recording
In today’s blog post we are going to watch a free video about how you can easily spot poor SQL Server performance in your system.
Coffee Mug – Indexes and SELECT Queries
Sometimes I feel like I have become a kid again. This morning I received a coffee mug with printed quotes of Indexes and SELECT Queries.
SQL SERVER – 3 Questions: An Index Reduces Performance of SELECT Queries
Lots of people had no idea that even index can also reduce the performance of SELECT queries. In this blog, we discuss 3 follow up questions.
SQL SERVER – An Index Reduces Performance of SELECT Queries
Can an Index reduce the performance of SELECT Queries? Let me make this question a bit more complete and meaningful to you.
When was Table Accessed Last By User? – Interview Question of the Week #226
When was a table accessed last by a user? When clients say a table is rarely used, I run this report to check before we create or drop indexes.