Other than what Gail outlines, which is a good way to get a new plan every time, why are you trying to "ignore the cache"?

Can you tell what is slowing down the inserts? I mean other than the obvious, this index sucks. What does the execution plan look like? What are the wait stats...

I'm curious what you mean by administration commands? Except for the direct manipulation of data within the tables (and even that) almost every single command is going to be an...

If it's integer data, use the integer data type. Done.

Numbers in general are stored basically the same way within SQL Server. The only differences really are in the size and...

Rebuilding the log file requires that no open transactions exist in the database. Try deleting the log file and attaching the database without the log. It might not work, but...

Take a look at the estimated execution plan. It will tell you the choices SQL Server is making based on the code you provided and the statistics available on the...

Yeah, it also checks the file locations.

You need to do this:

RESTORE DATABASE MyNewDatabase

FROM DISK = 'x:\mybackupfile.bak'

WITH MOVE 'MyLogicalFileName' = 'd:\data\MyNewDatabase.mdf',

MOVE 'MyLogicalLogFileName' = 'e:\logs\MyNewDatabase.ldf';

You need to put in your appropriate paths...

It has to be either duplicate data or NULL values. With a unique index you can have a single NULL value. As was stated, with a primary key, you can't...

Rebuilding the index defragments the index, yes.

There's a bunch of stuff that's been on the deprecation list that's still not quite gone. Profiler and Trace Events are the big ones I'm curious about.

MysteryJimbo (3/20/2014)

This will only work if its new storage AND...

paul.knibbs (3/20/2014)

I don't think you can do that, can you? 'sa' is a special login which isn't allowed...

I'm also inclined towards backup and restore. It's just inherently safer than detach/attach. Further, you could set up mirroring temporarily to get the database syncronized with as little down time...

Without seeing the queries and the execution plans, there's no way to suggest any indexes just based on table structure. I have no idea which column or columns are used...

Virtual memory is both, the page file and your physical memory. For more on it here's the books online.