I would like to add that it has been my experience that SAN vendor consultants know VERY little about how to optimally configure a SAN for SQL Server storage needs....

Up to a point, having lots of spids sleeping won't affect performance. This is normal with thread pooling.

You stated that you had no blocking and no long-running queries (which I...

DTA is like any other tool: if you KNOW how it works and how to use it it can be an effective device. But I have had two...

Well, I am at a loss here. I really REALLY thought I had given sufficient proof that if you use TOP/ORDER BY on a clustered column the distribution and...

noeld (6/23/2008)

The cost shows as 14.7% higher (a clear win), but the page reads and amount of data put through the CPUs is identical. The only difference in the...

All I am saying is that SELECT TOP 100 * ... ORDER BY without a WHERE CLAUSE is not a good thing especially when you cluster by TIME. Limiting the...

noeld (6/23/2008)

TheSQLGuru (6/20/2008)

This is being done. The combination of top 100...

1) a covering index is an inappropriate suggestion for a query that returns all columns

2) reducing the number of columns could well be appropriate and that could allow for covering...

1) It is only a rare situation where you should turn off auto stats features

2) I would have a job that runs at an appropriate interval (which depends on your...

1) are you sure there wasn't blocking going on when the sproc was executing?

2) Like others asked, we need to see the code, query plans and IO information (set statistics...

rbarryyoung (6/20/2008)

Not necessary. As I demonstrated...

Maybe take a look at ApexSQL's Script product, or search the web for some SMO code that will script out objects for you.

This is being done. The combination of top 100 and order...

several other things come to mind:

1) use the KEEPFIXED PLAN option that is available in 2000 (btw, you did say 2000 was your version, right? this is the 2005...

My guess is that you need a lower fill factor on the NC indexes coupled with routine maintenance to get back to that fill factor. This will minimize the...