Oh cool, tossed under another bus. Thanks Alvin.

Yeah, I absolutely want to know if you find it helpful, please.

I'm not planning on a release for the R2 version of 2008, but I'll absolutely update it for the...

I don't want to say it'll be better, but it'll be less complicated. That usually makes things better. I'd handle the scheduling through SQL Agent. That's what it's there for....

There is nothing wrong with maintenance plans, but frequently more precise control can be excercised when writing your own scripts.

Only looking at pictures like this of the sp_who2 output, it's hard to know enough to make good suggestions. From what I can see, you don't have any blocked processes,...

Just to reinforce what the others have said, it's a balancing act. You want to add enough indexes, in the right places, to make any query that uses a WHERE...

We have some similar needs. Instead of a single catch-all procedure, we have three different scripts, one for full backups, one for differentials and one for logs. Then we set...

RBarryYoung (3/14/2010)

---

Well, my back surgery is tomorrow (it got moved up). They've been putting me through medication withdrawal the last two weeks in preparation, so apologies if I've been...

There is a third party tool available for migrating DTS packages to SSIS. Go check out DTS Exchange[/url]. We've been using it and it's a great tool.

Just to pile on a bit, I'm with Jeff. It sounds like your architecture, your structures, and your code are to blame. You need to get someone in who can...

I'd report it to Microsoft. I've never seen that behavior and I've been using SSMS 2008 since the beta to manage 2000 and 2005 databases without any issues (except the...

I haven't logged back into Twitter yet. You're saying I got away with...

CirquedeSQLeil (3/12/2010)

---

Grant Fritchey (3/12/2010)

---

And then the next day you get a call from your manager who explains exactly why you'll be doing whatever heinously stupid operation it is that the...

And then the next day you get a call from your manager who explains exactly why you'll be doing whatever heinously stupid operation it is that the developer decided they...

Alvin Ramard (3/12/2010)

---

george sibbald (3/12/2010)

---

Alvin Ramard (3/12/2010)

---

A DBA tells developers:...