Just saw something about this the other day. Here's a link, http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1251587,00.html

Yeah I think that there were fewer posts this past week. Of course there's just anecdotal evidence. I usually check in in the morning with Active Threads and...

Congratulations Jonathan.

Barry, I didn't know you had gone to PASS too, next year I've gotta get out to it.

In case you all didn't know Grant Fritchey said that...

If you are directly on the server or RDP'd to the server can you use SSMS to connect and view the SQL Server error logs? You should also check...

Better late than never. Oh, and based on your tweets it didn't seem like you were late to...

Thanks, but don't forget the the second half of the...

Excellent points as usual, Phil. I agree that you should not use undocumented "features" in production code, but using them in ad-hoc queries and maintenance is acceptable in my...

These...

At least someone understood it. I wouldn;t have understood until about 6 months ago, when I had to deal with it. I think I even posted a similar...

Exactly.

Are you sure that the business can afford to lose 6 hours worth of data if something goes wrong? If you are just backing up the TX Log to...

Now there's a Hall of Fame answer! :D:P

You shouldn't be shrinking your database unless you had an unusually large transaction go through. If you shrink the logs they will grow right back to the same size....

Yes, this is correct. But is also why I always have separate files for Full, Differential, and Log Backups. You could also have different files for the log...

Are you sure the point you restored to was BEFORE the update?

The_SQL_DBA (11/21/2008)

---

how would an update be on the PK column? Will my life be easier if I use DTS and copy the table, the data in it is static so...