jcrawf02 (8/19/2010)

---

You know, I'd be interested to know the order they interviewed in, sometimes there's an unconscious bias when you rank people like that, because you tend to start in...

Are you perhaps selecting columns you don't need? Or pulling back BLOB type data?

5mm rows doesn't seem like a crazy number. Are you sure the server is properly sized?

I think I might agree on hiring. I continue to be amazed at some of the poor decision making I see about how you choose who to hire. Or how...

Right click the "databases" folder in SSMS. Restore database, then select your file. If there are other files in the dialog, remove them.

Give it a new db name for now.

Does...

I-Am-Not-T-Pain, though I wouldn't mind an app. Randomly spew out things like "I hate planes"

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...