http://msdn.microsoft.com/en-us/library/ms186406.aspx

Be careful about gaps in the identity column,

In 18 months there are probably 100,000 new people that have received the newsletter and not seen this article. We republish highly rated and highly read articles over time so...

I saw a survey last year that listed SQL Server databases, and like an idiot I didn't save it. It might have been 5GB, but it was single digit GBs.

I...

I think this is one place where the lack of code reviews happening is hurting code. When multiple people have to work with code, standards and comments get enforced fairly...

Same media should mean it's not corrupted. I'm not sure if that's the log file, but I've seen SQL setup put a log file somewhere in the Windows folder. Usually...

Grant Fritchey (6/18/2010)

---

GilaMonster (6/18/2010)

---

Lynn Pettis (6/17/2010)

---

Don't you love it when some one PM's you for help? Just deciding if I should help, post it for others as well, or...

I would follow Suresh' advice. Delete in small batches. A large delete is logged as one operation, and you need the space to record all those changes in the log...

Did you check for a sqlsp.log or something like that in the Windows folder? I think setup logs stuff in there. Or is this from there?

Are you using same media...

Will this help? http://www.sqlis.com/post/file-watcher-task.aspx

You can hear some of the audience. Some presenters are good about repeating questions, some aren't.

Overall I thought they were pretty good.

This is another one of those areas where you have to walk a fine line. I've done a restore, you've done a restore. However practicing it, building skills to perform...

What's the right results?

Sounds like log shipping got out of sync somewhere. My guess is you need to remove it from the secondary and reset it up between them.

The party runs itself for the most part, and I press a few RG people into service for volunteers. Come enjoy, gamble, say hi to a few people. It will...

We are getting a lot of new people writing questions, so there isn't this history of "trying to make it hard" with them. Kind of good.

Nice question, I saw it...