Viewing 9 posts - 106 through 114 (of 114 total)
I learned from a top SQL consultant that I worked with for several months, studied by myself, tried stuff, broke stuff, read everything I could find answered as much...
January 31, 2013 at 4:26 am
Nolock is not a performance tuning technique.
No...it's just a dirty technique to avoid deadlocks.
Well, snapshot isolation doesn't use locks...
Locking hints are not for casual use. There are very few...
January 31, 2013 at 3:47 am
anthony.green (1/31/2013)
Start with the stairways section of the site and read up on all the topics covered.
Gail also...
January 31, 2013 at 3:23 am
I'm trying it at the moment. Index change will take up some time. I'll report the results.
How did you come to this result?
What's the difference beetween an index key column...
January 31, 2013 at 2:37 am
Ok...I've already run over the High CPU-Chapter, but haven't studied it in detail. Because a lot of it i had already hurt and there was again no practical help or...
January 31, 2013 at 2:27 am
Ok. So i can state, that if all my queries are running well, my server is also running well?
Why does a query or better stored procedure claim so much cpu?...
January 31, 2013 at 2:12 am
Thank you both for your quick nswer. To be honest, I've seen this great article before and I've been playing around with things like this several weeks before I chose...
January 31, 2013 at 1:52 am
Which OS (be specific please)?
Windows Server 2008 Enterprise SP 2 (64 Bit)
What kind of HW (# of cpu's, ram, etc)?
Intel XEON Quadcore @ 3.00GHz
40 GB RAM
HP MSA connected via...
January 30, 2013 at 2:05 am
Steve Jones - Editor (10/3/2007)
I pinged Dr. Andras. FYI, he worked on the Log Rescue tool.
And did he bring some light into it?
Greetz KSC
February 22, 2010 at 6:06 am
Viewing 9 posts - 106 through 114 (of 114 total)