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...

Where? When setting up the distributor? When setting up the publication? When setting up the subscription? There are a number of places where security gets set doing replication.

Generally the SQL...

Jonathan was the one who commented about Linq.

What settings where do you not understand? When setting up the distributor? The publication? The subscription?

Phil, you say

You...

If you don't already have some form of auditing in place, there's no way you're going to identify historical events. If you're setting up auditing, then you can use the...