Posted by: Denny Cherry
Brent Ozar, In Person Events, Quest Software, Service Broker, SQLServerPedia.com
All to often when helping people look at query performance problems I'll ask them to look at the execution plan, and see what it says. Most query performance problems can be resolved simply by looking at the execution plan and seeing where you need to add an index. All to often I (and others)...
A while back I was looking at a clients database and we were looking at why the ASPState database was having blocking issues. So I through this script together to show not only the blocked processes, but also the blocking processes, but also include the name of the stored procedure as well as the...
People ask all the time why they can't connect to their SQL Server. Here are some thoubleshooting steps that they should take in order to find out what the problem is.
Please keep in mind that without knowledge of your specific problem I can only point you towards the right direction.
NULL values are something that a lot of people just don't understand the use off. Continued »
Why on earth to people want to go changing the rights on the system objects. Continued »
SQL Server has two basics kinds of indexes. They are clustered and nonclustered indexes. There are some fundamental differences to the two which are key to understanding before you can master index tuning.
A while back someone posted on the ITKE forum asking what Indexes where, and what they were used for. I put up a quick answer, but I felt that it deserved a more in depth blog post; so here it is.
So you've saved a plan guide into your SQL server, and you want to look at the plan. You can Query the sys.plan_guides catalog view and see the data exactly as you entered it, which works fine if you just have a hint in there. But if you have a full XML query plan that isn't going to do you a...