Viewing 15 posts - 106 through 120 (of 152 total)
by the way, for those who really want to understand how "transaction processing" and "isolation level" works, one should read Thomas Kyte's book - only the chapter about transaction processing.
February 16, 2010 at 1:55 pm
PG, Thank you for your clarification of your own statement. >" I enabled the read committed snapshot isolation level for ".
READ UNCOMMITTED
Specifies that statements can read rows that have been...
February 16, 2010 at 1:52 pm
"read committed snapshot"
You can only set one isolation level, that statement is incorrect, where do you do that?
February 16, 2010 at 7:14 am
The original choices do not contain correct answers. Please verify the Q/A before it is published.
Imagine you take a GRE special topic test that involes world wide thousands of thousands...
January 20, 2010 at 7:39 am
That is exactly the message we need in the U. S. of A. Not just to technical people, also to the entire company from CEO to clerk, who work with...
January 20, 2010 at 7:30 am
That is correct. This simple tutorial script solves the problem I had and is a sample for you to refactor and write whatever you want.
CirquedeSQLeil is going to write the...
January 19, 2010 at 7:38 am
Nice write up. I agree with nlarge. The application code should be in the application using C#/ASP .Net. It would be easier for future debug, maintenance, integration from architecture point...
January 13, 2010 at 2:06 pm
Mine actually created jobs in English version. You have to be careful with that hostname and sharefolder. I can it is useful if you start out many db servers you...
January 8, 2010 at 2:20 pm
Excellent book. I actually used it for over a year to solve many performance problems on our prodution databases. I have actually gone beyond the book's level to solve...
December 28, 2009 at 9:36 am
Interesting idea to copy objects. However, according to SOX, those who have full access to production and development are distinct two groups of people. You cannot push DEV object into...
December 11, 2009 at 2:57 pm
Too many times in history, the best technology solution won't sell. It is market economy. (I don't need to list historical examples).
In this particular case, I don't know if anybody...
December 8, 2009 at 3:11 pm
You should add row-count in the whereclause because defrag on small table will not help much.
December 8, 2009 at 3:03 pm
1) Because SQL Server Express is more lightweight than Developer Edition.
2) Because some products, like Outlook with the business extensions automatically instally SQL Server Express. This includes Visual Studio, though...
December 8, 2009 at 2:53 pm
Awesome. Two thumbs up for you, Ola. Finally someone post it. I have been using three scripts on agentjob I wrote to do these three things. Better late than never...
November 13, 2009 at 1:23 pm
Viewing 15 posts - 106 through 120 (of 152 total)