Viewing 15 posts - 5,101 through 5,115 (of 5,841 total)
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....
June 26, 2008 at 7:28 am
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...
June 26, 2008 at 7:25 am
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...
June 24, 2008 at 7:24 am
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...
June 23, 2008 at 3:40 pm
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...
June 23, 2008 at 12:49 pm
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...
June 23, 2008 at 11:17 am
noeld (6/23/2008)
TheSQLGuru (6/20/2008)
noeld (6/20/2008)
you must definitely "limit" the Time column with a "range" once you do that you should be fine.
This is being done. The combination of top 100...
June 23, 2008 at 10:17 am
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...
June 23, 2008 at 9:19 am
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...
June 23, 2008 at 9:15 am
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...
June 23, 2008 at 8:53 am
rbarryyoung (6/20/2008)
TheSQLGuru (6/20/2008)
Maybe take a look at ApexSQL's Script product, or search the web for some SMO code that will script out objects for you.
Not necessary. As I demonstrated...
June 20, 2008 at 5:32 pm
Maybe take a look at ApexSQL's Script product, or search the web for some SMO code that will script out objects for you.
June 20, 2008 at 1:25 pm
noeld (6/20/2008)
you must definitely "limit" the Time column with a "range" once you do that you should be fine.
This is being done. The combination of top 100 and order...
June 20, 2008 at 1:23 pm
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...
June 20, 2008 at 8:39 am
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...
June 20, 2008 at 8:24 am
Viewing 15 posts - 5,101 through 5,115 (of 5,841 total)