I'm not sure that's fair. They are trying to pick people that are recognized experts. "Best" is an opinion, and we'll never agree on it. I don't think that means...

You can't compare dates. Those are when SQL wrote to the file, which I think it does when it opens it, so you're looking at whichever one started later as...

There isn't a good way here. You need to move that much data, and it will block things.

I still question this is really needed. No one can use 5mm rows...

You need the space for data, and you need some pad space. This is for data growth and maintenance operations.

My apologies, Heather, for the implication. I was not aware that the Idera product had write capabilities. I have updated the editorial with a note as well.

Geoff is a good guy, headstrong, professional, and smart. I think he is an excellent choice, as is Andy, for the board.

5mm rows for a report is a little silly. There is no way anyone goes through this much data, even for an audit. And I can't see it being run...

*grunt*

I...

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