Posted by: Denny Cherry
Clustered Index, Index
So, as you may have heard the SQL PASS 2009 Call for Speakers has gone out. I've submitted a couple of sessions already, but I was hoping to get some feedback from the community at large about what you think I should submit topics on. I've submitted a couple of SQL Service Broker sessions, as...
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.