It rarely happens, and it has been a big problem. In 2008, you can save off a "good" plan and force it to be re-used. I might do that in...

Variables in algebra can be. That's what I thought, but if I have X and Y in two equations, it's not unknown. It's unsolved, perhaps, but not unknown. It's more...

You don't know my voice? I thought everyone did 😛 (http://sqlservercentral.mevio.com/)

I need to install it and play with it. Haven't done it so far since I was waiting on a...

FWIW, what's shown above is what some tools do.

Red Gate has SQLCompare, and it can easily script these changes and you could search/replace to all schemas.

Personally I'd build a script...

Thanks, all demo mistakes...

paul.knibbs (8/19/2010)

---

Having thought about it, I'm not so sure that automation always needs a human in the loop. The (simplistic) example I'd give is that I recently drove a car...

The optimizer examines a bunch of plans, tries to pick the best one. You might get different results at different times depending on data changes, statistics, etc.

I think the point...

The Red Gate Source Control webinar starts in a few, if any of you are interested

http://www.sqlservercentral.com/articles/webinar/70854/

Howard Dean did pretty well as a grassroots guy. Didn't get elected, but did well.

http://www.democracyforamerica.com/

If my manager asks for the password, IMHO, I am responsible for giving it to him. I might be about to be fired, and the manager has the authority to...

Doh! I'm an ID-Ten-Tee

Corrected and here: http://www.zdnet.com/blog/service-oriented/when-processes-are-beyond-the-reach-of-automation/5332?tag=mantle_skin;content

Yikes!

Remind me not to ride the sky ride when I go down there again. Do not like heights.

I would agree with scripting things. I'd script out all jobs and then search/replace.

I would vote for the WROX book as a good place to start.

There is no easy way to do this. A database isn't like the file system where you search everything. A search across different tables requires different queries with separate FROM...