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
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
Question: When was Table Accessed Last By User?
SQL SERVER – When You Should Not Attend SQL Server Performance Tuning Practical Workshop for EVERYONE?
So far many of you know that my SQL Server Performance Tuning Practical Workshop for EVERYONE is extremely popular and it is almost full when I am writing this email. I can now accommodate a maximum of 5 individuals in the class as we are reaching capacity. However, yesterday I received a very interesting email which asked me a specific question about the word EVERYONE. Let us read the exact text of the email so you get a clear idea: