Viewing 15 posts - 4,501 through 4,515 (of 5,843 total)
How much RAM is on your computer and how much of it is SQL Server using?
October 21, 2009 at 11:01 am
There are MANY things that can cause slow IO, although it is often a combination of them that lead to the 15 sec warning (that is REALLY bad, btw, as...
October 21, 2009 at 10:51 am
sonal_anjaria (10/21/2009)
October 21, 2009 at 10:30 am
ed_elfrink (10/20/2009)
October 20, 2009 at 8:22 am
pmcpherson (10/14/2009)
Fantastic! This forum is making my week! Really! I just have one question now; how do you un-concatenate a string into rows efficiently?
Search this forum (and...
October 14, 2009 at 10:56 am
TheSQLGuru (10/14/2009)
sauraviit, did you actually read the posts before you before making your post?? :w00t:
There are several examples of the 'tsql variable trick' already posted. 🙂
October 14, 2009 at 8:57 am
sauraviit, did you actually read the posts before you before making your post?? :w00t:
October 14, 2009 at 8:05 am
Job histories and backup/restore histories are the things that take the most room over time in msdb. They can both be pruned using system stored procedures or maintenance plans.
October 14, 2009 at 7:53 am
Buy a server with 256GB of RAM and 16+cores of CPUs and your table scans should run quite quickly since you won't have to touch the disk at all! ...
October 13, 2009 at 8:23 am
You cannot explicitly configure the procedure cache. If you are on SP2+ then you have lower ratios of procedure cache than prior to that version, which actually could be...
October 9, 2009 at 8:35 am
There are probably a dozen or more things you need to investigate and rule out before doing something like hinting maxdop. You should consider getting a professional tuner to...
October 9, 2009 at 7:40 am
For me it was Hunt the Wumpus, hand-coded on my TRS-80 Model III circa 1979. I think there was another one I did, something that started with a 'Z'...
October 5, 2009 at 8:16 am
The key thing to be learned here is that optimal varies GREATLY depending on the situation! Having many tricks up your sleeve for solving tsql problems (especially the common...
October 2, 2009 at 2:48 pm
Jeff, try your sample code without your beloved clustered PK. That eager index spool eats you alive. 74.5 cost and 2.6M IOs. The real world rarely has...
October 2, 2009 at 2:31 pm
Boy, the video game chatter has me realizing how long in the tooth I am getting as well! sigh...:cool:
October 2, 2009 at 2:25 pm
Viewing 15 posts - 4,501 through 4,515 (of 5,843 total)