Viewing 15 posts - 3,631 through 3,645 (of 5,843 total)
Oh look, another entity out there who threw a workload (or multiple workloads) at the Database Tuning Advisor and accepted everything!! Outside of using Scalar UDFs that is just...
February 7, 2011 at 8:32 am
Better yet, stop using UDFs so you don't get hurt by the MANY ways they can harm you!! 😀
February 4, 2011 at 3:07 pm
Ahh, the old "add an index to avoid a table-scan update" solution! Good job! 😎
February 4, 2011 at 3:06 pm
Boy, if I had a nickel for every one of these types of posts - or every time I have seen a CLIENT do this . . . :w00t:
February 4, 2011 at 3:05 pm
get the complete and FREE maintenance suite at ola.hallengren.com!!! Can't say enough good things about this - and it does much more than just index mx.
February 3, 2011 at 9:14 am
NOTE: SQL 2011 (aka Denali) will require ENTERPRISE EDITION WINDOWS SERVER AND ENTERPRISE EDITION SQL SERVER to do clustering/mirroring!!! Pretty much sucks in my book and I and others...
February 3, 2011 at 9:13 am
variety of things could be at play here. I HIGHLY recommmend you engage a performance tuning consultant for a day or two to dig into what is really going...
February 3, 2011 at 9:10 am
1) yep - don't shrink
2) make the database big enough to contain 12-18 MONTHS of expected data growth (including indexing sizes)
3) you MUST update ALL statistics with a FULL SCAN...
February 3, 2011 at 9:07 am
evenly divisible is fine - although if you are on a SAN you need to take raid group striping sizes into account. Win2008+ now aligns on 1024K (at least...
February 3, 2011 at 9:05 am
CAST and CONVERT in books online. There are many examples there.
February 3, 2011 at 9:03 am
I STRONGLY STRONGLY encourage you to stop using the MDW and purchase a third party product for your server monitoring. MDW is NOT ready for prime time and will...
February 3, 2011 at 9:03 am
I recommend to my clients to ONLY use temporary tables unless they have one of the following situations: a) VERY high volume OLTP hits where they need to avoid recompilations...
February 2, 2011 at 7:39 am
siluctc (2/1/2011)
@lalit sir.. the plan is now to use linq or clr store procedure. Can u suggest which one is better and why.
DO NOT USE LINQ TO SQL, and avoid...
February 2, 2011 at 6:41 am
MAX DATE method has one downside though - you can get duplicate output if more than one record has the same MAX DATE. This should not happen with ROW_NUMBER()...
February 2, 2011 at 6:32 am
1) check the DMV for index usage to see if the nonclustered index is actually being used
2) you may also want to run a DETAILED index physical stats DMV check...
February 2, 2011 at 6:30 am
Viewing 15 posts - 3,631 through 3,645 (of 5,843 total)