http://msdn.microsoft.com/en-us/library/ms181671.aspx

This doesn't make it fast, it rebuilds indexes.

If you don't have it properly indexed, it won't help.

Most security products I know are looking for tens of thousands of dollars. A little outrageous from my perspective because the risk isn't high to most people.

Prometric and Vue are the testing places.

I'm not sure of the status of the 2008 exams. They are really new, so they might not be distributed everywhere, or on the...

Is your tempdb one data file? Just tempdb.mdf?

What was the result of the shrinkfile on this file?

For statistics, http://msdn.microsoft.com/en-us/library/ms187348.aspx

You can do a specific table or index.

For the MDOP, what do you mean 8 servers?

You also don't necessarily need to worry about locking. SQL Server handles most of that.

It would help if you specifically noted what you are trying to achieve. You may be...

Licensing is a pain, and it's hard. Good to see that Bob is building a better license, working with customers. I'd like to see more of that with vendors, and...

I don't think you can even install with the same named instance if one is down and the other running. I think you need a unique name at all times.

Not sure how long we've been able to export to PDF from ER/Studio, but I don't think it worked well in the 99/'00 timeframe. The other issue is that you...

A regression test is a retest of your code. So you set up tests to determine if it is functioning properly.

As you make changes, add new modules, etc., you...

What do you mean by streamling? Is this performance or process based?

Thanks for the update. Based on that it sounds like some physical issue that you fixed by rebuilding the objects.

Did you ever run a DBCC CHECKDB?

Log Rescue form Red Gate is free. If you have the logs, or log backups, you might try it.

New avatar (someone in this thread got me thinking it was time to change)

Sounds like connectivity issues.

If you remote to the server with this account, does a local SSMS install run better? Have you tried another workstation with your account to eliminate machine...