Have you run the upgrade advisor? Has it found any potential problems? Have you tested your app and database completely on SQL 2005?

A general network error means that the connection has been suddenly and forcefully closed, and not by the application. Basically, the app tries to communicate over a channel that no...

In 2005, the options are a comma-delinited list or an xml document or similar. Messy, I know. In 2008 you can use a table-valued parameter.

I didn't write it. I found it somewhere online. Can't...

And he's writing another one. A full, published dead-tree book...

Lynn Pettis (11/22/2008)

---

Yeh, it has been a killer week telling everyone to read Jeff's article on how to post better questions over and over. I feel like a broken...

I'll check with the PASS people. If...

llokshin (11/22/2008)

---

For now I just did index defrag for some of the tables in db and see that used space isn't changed but free space grew for about...

We're busier than we would like due to multiple threads that could easily be answered by a quick read through of Books Online.

1)How to do...

full backup has never truncated the tran log. not in 2005, not in SQL 2000.

samalex (11/21/2008)

---

If we do a trans log backup 4 times a day I assume this will...

Don't. Hints should be a last resort when...

Databases are going to need managing whether they're in the 'cloud' or in your server room. Maybe you can pay extra for backup services, but that's not all a DBA...

Grant late for a party? That'll be...

It wasn't completely packed out. There were empty seats. I'd say the room was 50-60% full. Bob Ward's session in the...

Phil Factor (11/22/2008)

---

One slightly scarey thought bothers me though: If the structure and processes of the transaction log were fully documented, then would it then be maliciously hacked? We'd then...