I tend to agree with Jeffrey. Nothing wrong with maintenance plans in and of themselves, but some of the tasks are not very efficient.

I'd still put in requests for most...

Thanks for the catch. I thought that was a restriction, but apparently my memory is fading.

LOL, it's a typo. Sorry, 350-400MB a month. Used to be about 200MB or so, but...

All these discussions just got me to look at my usage and lower my cell plan.

I had an unlimited voice/unlimited data plan for the iPhone, but I've moved to a...

stephen99999 (8/2/2011)

---

I am trying for my 2nd time at NC State, and hope to have the chance to step into Analytics and maybe change the world a little (personal goal;...

No idea. You should contact the tool provider for an answer there.

I'm not sure how platespin works, but you might need to backup the service master keys and restore those on the copy.

The default isn't an expression run against the row. It's a value. Same for computed columns, these don't allow logical expressions.

A trigger is the best way to handle this.

The tools in SQL Server only regenerate the code that you've put in there. Codesmith, IIRC, allows you to generate new sprocs more easily.

You have to send that reorg operation to the log shipping secondary or you break log shipping.

You also will need this space next Sun, so I'm not sure if shrinking...

update table

set datecolfield = null

where datecolfield = '1900-01-01 00:00:00.000'

I played some Halo series with my son, but not much lately. We tried to get the kids into RockBand, which has a tiny game piece, but no luck.

Words with...

cfradenburg (8/1/2011)

---

However, since the backup system provide a lower level of care I don't know that it's a wise idea to kill services and force the backup system into place....

My apologies, the links have been fixed.

If you have 30 indexes on a table, you have potentially 31 writes when a change is made to the table. If one of the 30 is a clustered index,...