Not sure, I'd have to see the scripts that were run and what modifications you made and how you made them. Are you sure you were connected to the correct...

Nothing you ever do on a server is free. Yes, it impacts performance, but not very much at all. It should only take out some shared read locks on system...

There have been tests, and you can search for them online, that show that a well defined clustered index speeds up inserts over and above having a heap table. I...

With all your points I figured you'd just buy the store and move it down to SA to force...

You need to look in the project properties for the database. It's set to recreate the entire database. You can have it do incremental builds. This article[/url] is a bit...

You can always take them down the company store and exchange them for valuable merchandise.

Where was the company store located again?

Removing indexes is generally not going to help SELECT performance. You need to understand what your queries are doing in order to correctly configure your indexes, not simply dump them....

Without a lot more information, I wouldn't suggest any denormalization until you have a very thorough understanding of where the performance...

After you read through Gail's excellent articles, if you still need more info, please check out my book "SQL Server 2008 Query Performance Tuning Distilled."

You can create a composite project that combines the server project and that database project.

Just saying you have a 300gb database with many users is not nearly enough to begin to make suggestions for what to do with that database. It's not even remotely...

Well done. That's a serious milestone, especially considering...

For that one query, yeah, it sounds like it needs more up to date statistics.

Take a look at "SQL Server Team-based Dvelopment." [/url]It's not going to tell you how to move large amounts of data. That's a different issue entirely.

I used to work for a medical software company. it was a nightmare...