Sure...

stefan.gustafsson 60897 (3/18/2010)

---

Sure, why not ? The only possible ill effect is that it might slow down insertions to the table slightly. This will only be a problem if he...

What are min and max server memory set to?

How are you monitoring how much memory SQL is using?

What's the value of Total Server Memory and Target Server Memory? (Perfmon counters)

Is...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic885461-146-1.aspx

It would fix it, but GUIDs are...

Adding or altering indexes invalidates cached plans based on the base table that the index is defined on. Next time the query runs, the plan will be recompiled.

It's easy enough...

From memory, that's...

I don't think I ever memorised the 1 Ring in Black Speech. English, sure.

There's a large number of his verse that I can still remember almost perfectly. don't know what...

There's at least 2 of tolkien's languages that are published and are usable (though maybe a little short of technical vocab) Quenya and Sindarin. I dug through the details of...

That's 2 out of the 4 tables.

Please just post the script in the forum directly rather than in attached word docs.

You have to drop them. A disabled foreign key is still a foreign key and a table referenced by a fk cannot be truncated.

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic885305-148-1.aspx

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

The compatibility level affects how the query processor handles some query constructs and whether or not some features are allowed or not. Mostly is disallows features that changes the meaning...

You cannot lose data in a detach/attach. SQL Server supports the ACID requirements for relational databases. D stands for durability, meaning once a transaction has committed, the changes that transaction...