what about fn_dblog?

I updated a table with the same value and after doing this there were two more rows returned by fn_dblog. each time I ran the (duplicate)...

You can actually setup an alert for blocking and then you can have that alert call a stored procedure to get some amplifying information, record that information...

Heh... it's not my story.  It's in the link you provided.  Paul proved it with code.  Can you prove it to be otherwise with code?

You can actually setup an alert for blocking and then you can have that...

Personally, I'd check the SQL Server Error Logs for deadlock events.

@JohnyRotten,

Wow.  I've never actually heard of any third party (nor anyone else, for that matter) using auto-close on a database before.  Thanks for taking the time to post what you...

I've been pretty happy... as some say... "Loving the lockdown".  But, I have to agree with you Grant.  Being around people does promote spontaneous discussion, which supports and enables the...

If no one is allowed to read it, it might as well be compressed so it doesn't take as much room so I agree with Grant's suggestion of converting it...

1. Could you please me how checksum work in the SQL statement ? below is an example.

SELECT * FROM Tablename1 WHERE CHECKSUM(*)

NOT IN (SELECT CHECKSUM(*) FROM TableName2)

2. and there is...

I might be misinterpreting what you're saying above but, at face...

I believe that what's missing can be described by a single word...

SERENDIPITY : The occurrence and development of events by chance in a happy or beneficial way.

I might be misinterpreting what you're saying above but, at face value, I...

Great info.  Thanks, Brandie.

Silly question for you. Why do you need a Kindle device when you could install the Kindle or Nook app on any tablet of...

I've had a few Kindle devices and I read almost exclusively with the Kindle app on my phone/iPad. I bought one of the first Kindle devices, and have...