I hope there's a committee, but my guess is that whichever developer works on it gets to decide. He/she may ask for advice or have guidance, but I would bet...

Ah, but I don't think that works. you still choose a default when you present the choice, meaning either clustered or nonclustered is selected. I guess you could select nothing...

You have to compare every table and every column. There's no easy way to do this.

There are a number of compare tools, Red Gate, Apex SQL, and more, that will...

Not to be trite, but this is such a general question and it's easily answered by looking at the marketing materials. If you are researching some paper or report for...

It also depends on the updates. Updates don't force page splits. Updates that increase the amount of data, beyond what fits on the page, force page splits.

If I have integers,...

I tend to agree with Michael. On the surface it sounds like a bad idea, but I woulnd't condemn it without knowing more.

If this database is the central source for...

Backup/restore is my choice.

There's a copy database wizard, but it's been flaky for me.

An insert/update would cause a last modified time to change, but I think the file has to close for this to be triggered. So the last time your SQL Server...

The process should remain while the connection is there. If it drops, I would have thought that the process would drop on the server.

Each one uses a small amount of...

Shark,

Don't feel bad. I'm sure most of us have done something similar. Just be happy that it wasn't really a 180GB database you're looking for space for now!

Major,

I tend to agree with you on defaults. I think that most of the time they're just set to something without a lot of thought about what makes the most...

You might also check out this blog:http://blogs.msdn.com/craigfr/

Great information in there.

Sorry, that was for another article. The link has been fixed to that procedure.

Steve

Does this happen on any workstation that connects with EM?

Objects in tempdb disappear when the connections are dropped. Unless you are using global temp tables (start with ##). In that case, write a script to delete those objects and...