Fair point, Bill, and I do try to disclaim that Red Gate pays my salary when posting about things. I neglected it here, and I'll add that as well.

Ha, where's the argument in that 🙂

I don't know if Andy's the best, but he's pretty good. Course, being a fellow Southerner, I like listening to the accent.

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"