This might be some help: http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx

Chad

Hi Manu - here's MS's page saying basically the same thing. http://support.microsoft.com/default.aspx/kb/906344

Nice summary.

Chad

I don't think you have blocking in the "normal" sense. It's more of a "wait" than blocking. Do you have multiple CPUs? When you look at the...

I've seen this happen on 2K5 with parallelism. If you look at the Activity Monitor you see one spid repeated a whole bunch of times and if I remember...

Can you do something like this:

select formid, acceptCreditCard, city, Table2.anothercolumn

from (select formid, action, value

from table1) tblA PIVOT (Max(value) FOR action in ('AcceptCreditCard', 'City')) AS tblB

INNER JOIN Table2 ON tblB.FormID =...

Give this a try:

SET ROWCOUNT 1

DELETE from #tmp where (add all the columns you need to identify the record you want to delete)

SET ROWCOUNT 0

The rowcount will limit the...

You could query for the ID later based on the SomeData value.

Take an example where you are inserting bunch of professors and bunch of classes and need to link them...

You are correct, the maintenance report setting is different from the job notification setting. The report setting is internal to the maintenance package and has to be changed there,...

Any chance you could incorporate our suggestions, verify that the output is still correct, and repost an updated query?

I'm going to go with a guess that there are...

I pasted your code in and got your desired results... 🙁

I'm going to guess that the results you posted are not exactly from the code you posted -...

My sister took a forensics class in college. For one of her assignments, she had to come up with 50 mistakes in a single CSI episode (something that was...

Very pretty!

Without digging in too deep, I'll throw out a couple things...

Is the DB case sensitive? If not, there's no point in doing all the LOWERs, and that will...

I'll admit up front that I didn't read through your post carefully, but I think I know what you need. You want to "collapse" multiple rows into one -...

Nicely written! Excellent job coming up with some answers that sound good if you haven't used a timestamp before, yet leaving the correct answer clearly on it's own.

You also need to watch foreign keys for other related tables. In this case it sounds like there were no interrelationships. But if data were deleted from a...