You can use an XML configuration file to be read at runtime.

So all you would have to do is change the configuration file to point to a different database.

The initial...

Is the GUID your clustered index key as well?

If so you are probably seeing lots of page splits when you are doing inserts.

Best way of speeding that up would be...

Bulk Insert will almost always be the fastest way to tranfer large amounts of data.

Best way is to create a SSIS package to transfer the data and schedule a job...

As others have mentioned adding more memory can mask inefficient queries that you won't notice until the server starts using more memory.

When you look at an inefficient query, it may...

Or just take time to learn the features of native SQL backup first before going into any third party route. SQL 2008 improved upon the older version with compression...

Or just wait until Denali releases which should be sometimes next year.

It's reserved to follow ANSI SQL-99 standard as a keyword.

Number two should be the simplest way to a clean install.

I don't see any issue with restoring 2005 sql backup on sql 2008 r2.

We are expecting to do the same...

You can create a CLR function to compress and decompress the data and call the function to store and retrieve data.

Two really useful tool for detecting blocking is sp_whoisactive and server side trace with blocked process report. Latter will allow you to actively monitor and log blocking info and...

Did you look in the data and log directory to see if the data and log files are there?

That query would run the fastest if there was a nonclustered index on MyColumn.

Otherwise it would have to scan through the entire clustered index to get the count and it...

why don't you do the insert within a stored procedure and you can do all the logic within the proc?

I don't believe there is any way of doing what you...

I second this.

It will...

You want SQL Server to index the contents of your file?

What type of file are you going to store?