Pick the indexes and right click, select delete or drop.

Best you can, though most people have smaller environments and have to make guesses on performance. I would think the data size is the most important, get all data, then...

Which event is this? If you are grabbing stored procs, you'll get it. You can filter by database or user as well.

What does the proc do?

Paul's got it. tempdb is recreated, might not have enough space for that on your system or even logging.

Lots of VBScripting.

Transfers are always easier to one file name. You could use the Dynamic Properties task to alter the connection to the file to a different name based on...

For multiple operators, I usually send to a general box somewhere and then let the email system either forward to multiple people or one.

If you don't have SMS or MOM, then this is a pain. I might psexec it, logging the results to each server.

That or get a bunch of terminal server sessions...

Definitely use SHRINKFILE, but be sure that you don't need that space. HAving the log shrink and grow is a waste of resources.

I wrote about this some time ago for SQL 2000. Basically the file extended properties and the version in master could conceivably be different. I'd check both and that might...

You should use ALTER INDEX with 2005 and above as DBCC REINDEX is deprecated.

I'm not sure what you can grab here, though checking @@ERROR and related variables after the command...

I'd also recommend 37 Signals to check out. They have an interesting blog.

I heard Jason Fried speak recently and he talked a bit about how they build software and their...

We definitely don't condone posting of braindumps or links to dumps. They are a form of cheating and not accepted for passing. Microsoft has sued companies providing them.

Similar questions from...

The training kit should give you an idea of the types of questions and perhaps someone will chime in.

Exact questions and potential answers, should not be posted as that violates...

Sure is: http://support.microsoft.com/kb/193888

Ewan,

The way ESX works is that it's like a cluster of VMWare hosts. The "floating" means that your VM could migrate to another physical machine, WHILE it's running, and without...