Viewing 7 posts - 16 through 22 (of 22 total)
Excellent explanation! Thanks for the pointer!
One question only: Can I set the default isolation level somewhere such that a begin tran is automatically understood as set transaction isolation level read...
June 11, 2008 at 2:55 pm
Hello All,
Thanks again for your responses. I did the testing today which generated some conclusions (please confirm if they are correct) and further questions.
Here is the scenario:[font="Courier New"]
Table...
June 11, 2008 at 2:33 pm
Thanks guys for the responses! I haven't had time to test this yet, but I will tomorrow.
In the mean time, could you please direct me to some reading material (for...
June 10, 2008 at 8:01 pm
Kyle Neier (6/10/2008)
You can read the good article here on this site:http://www.sqlservercentral.com/articles/Administration/2960/
or you could read the Microsoft article
http://support.microsoft.com/kb/321185
Kyle
Thanks!
This helped me find the short answer that seems to work:
SELECT SERVERPROPERTY('productlevel')
Gabor
June 10, 2008 at 12:41 pm
Thanks! Very interesting read! Learnt a lot from it!
Gabor
GSquared (6/9/2008)
June 9, 2008 at 2:29 pm
Hello,
Yes, that works a LOT faster!
Thanks!!!
Gabor
June 9, 2008 at 2:10 pm
If you start a load testing batch process in 10 parallel threads and let it run for an hour and a half, you exhaust your number range...
Even worse: You start...
June 9, 2008 at 11:47 am
Viewing 7 posts - 16 through 22 (of 22 total)