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.

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...

"read committed snapshot"

You can only set one isolation level, that statement is incorrect, where do you do that?

Pieter, the URL is incorrect.

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...

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...

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...

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...

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...

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...

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...

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...

You should add row-count in the whereclause because defrag on small table will not help much.

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...

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...