Agree with rjv:

A twist on previous question agreed, but I do not agree with the choice of answers. It is a bit too vague to select that as an answer....

:discuss:Unfortunately I believe that none of the answers are correct for this question....

This is not a bug. Rowlock and pagelock are mutually exclusive, and both state to use either row locks or page locks as long as escalation to page locks is...

Hugo,

Mine has been more in the rowlock, nolock and tablock hints. I have had cases where the optimizer determined that the tablock was more effective than a rowlock and escalated...

That is the one. Yes there is a down side to it, as with most hints.

Unfortunately, many think that a...

Thanks for the explanation Hugo. The questio happened to fall while I was on vacation and traveling. In addition to your explanation, each database should have a good maintenance plan....

I have to say that this is a poor question.

The insert statement is specific to SS2008, and not earlier versions. Thus the insert will fail unless on SS2008. The question...

Hugo, Great question. Made me think and analyze since in the "old days" the only way to regenerate the identity key was to drop the table and recreate it then...

Oleg,

insert into #n

select

top 3 row_number() over (order by [object_id])

from sys.objects;

is not the same...

As stated before - There are many articles written on this subject. Some that may help (these are not specific to SQL Server, thought the theory is the exact same):

Like Irish, I to predate Microsoft, working in this field since early 70's. I am amazed at the responses, as I remember many years ago having it drilled into me...

My only complaint is that it is true.

Had to do a conversion back in 6.5 days, and maintain dates going back to 1600's. Had to be a bit creative on...

Personally, I got it correct - WAG.

My feelings are:

When I submit a question, it is my responsibility to ensure that the question is phrased in such a manner that the...

Oleg,

I wasn't arguing the point. I think it is a great question, causing a of of thought and good conversation. I just got it wrong, I admit it. My thinking...

Hugo, after getting the questin wrong;-) and re-reading a few times in disbelief I found on <http://msdn.microsoft.com/en-us/library/ms175477.aspx&gt; - Each data backup includes part of the transaction log so...