In this article we shall examine the two modes of data search and retrieval using indexes- index seek and index scan, and the differences between the two.
SQL SERVER – Get Query Plan Along with Query Text and Execution Count
Quite often, we need to know how many any particular objects have been executed on our server and what their execution plan is. I use the following handy script, which I use when I need to know the details regarding how many times any query has ran on my server along with its execution plan. You can add an additional WHERE condition if you want to learn about any specific object.
SQL SERVER – Measure CPU Pressure – Detect CPU Pressure
The CPU is responsible for not only SQL Server operations but also all the OS tasks related to the CPU. Let us learn about measuring CPU Pressure.Â
SQL Server – Understanding Table Hints with Examples
Today we have a very interesting subject to look at. I tried to look for help online but have not found any other documentation besides what we have from the Book Online. Let us try to understand what are the different kinds of hints available in SQL Server and how…
Read More
SQL SERVER – Clustered Index on Separate Drive From Table Location
How to improve performance of SQL Server Queries is a common topic of discussion among many of us. Much has been said, much has been discussed. Few days back, I had an interesting discussion with one of the Junior developers regarding performance improvement of SQL Server Queries. We discussed on how by using a separate hard drive for several database objects can right away improve performance. I suggested him that non clustered index and tempdb can be created on a separate disk to improve performance.
SQL SERVER – Query Optimizer Hint ROBUST PLAN – Question to You
While cleaning up my bookmarks this week, I stumbled upon a very small interesting thing. I can proudly call myself a pro at finding stuffs, but after continuously hunting online I could not gather comprehensive information about this topic. I was actually looking for a practical example for Query Optimizer…
Read MoreSQL SERVER – Performance Counters from System Views – By Kevin Mckenna
I just love social media and all the new concepts of Web 2.0. There are bloggers who are overwhelmed by the new concepts of technology and are not able to keep pace with it. But I like taking such challenges. Twitter has acquired tremendous popularity nowadays and just like everybody…
Read More