For one to 12? Rounds trip to the server? Wouldn't it be easier to hard code these in? AFAIK, months don't change often.

Don't worry too much about the discussion. Plenty of people think everyone sees what they see, and they don't...

James Stephens (6/18/2010)

---

While I agree that in general cursors can adversely affect performance, I disagree with the conclusion that there is "always" a way to use a set operation rather...

Do you only care about changes in the platform? You need to use a subquery to find the previous value. Here's a basic query. Not sure it's what you want,...

Why service accounts? You could just change things to sa

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