I tend to agree with Gail that I'd just index the fields. If there are specific values that you need to pull out, you could add a computed column that...

As Bru mentioned, you haven't joined TableA, so you might end up deleting everything in that table. Only one table is affected, but how it is affected depends on your...

Nice names, and "No RBAR" might be the best one for a boat. Thanks, Jeff.

Thanks, and I appreciate the kind words. I'm enjoying this now, and while I do think about leaving at times, I still enjoy this and the personal answer I keep...

You can use the RESTORE commands from SQL to get this information, like FILELISTONLY (http://msdn.microsoft.com/en-us/library/ms173778%28SQL.90%29.aspx)

exec xp_sqllitespeed_version should give you the version, which you likely will need.

to send the files...

the dateadd is not commented out, just the note.

SQL is only precise to .0, .3, and .7ms, therefore you can't have .1 as the answer. It could only be one...

Good article, Seth, and a nice explanation of the issue. It's not always easy to do things up front, especially when you have business reasons for not putting resources into...

What is your trigger doing? A trigger that inserts data into another table would not affect the application.

You can run traces and collect that data when a particular table is...

Doh! You are correct. Didn't check the forum. Those are 2005 and later solutions.

In 2000, if you didn't start the restore with the STATS parameter, you won't get this

http://msdn.microsoft.com/en-us/library/aa238405%28SQL.80%29.aspx

Apparently not doing much networking with this one.

Dan,

That sounds like something that I'd be looking hard at. If you could repro, that would be interesting.

CirquedeSQLeil (11/25/2009)

Jack Corbett (11/25/2009)

Okay, Steve will be gone, now we can...

Stuffing myself with pizza after skiing. Likely gone until Monday, so everyone enjoy (and behave) themselves.

Dan,

The likely candidate is someone inserting a value using SET IDENTITY_INSERT ON that is too high.

A rollback should not have affected things, as you've noted. If you inserted 1,000...

http://msdn.microsoft.com/en-us/library/ms177648%28SQL.90%29.aspx