Which one runs faster?

Use STATISTICS IO and STATISTICS TIME or SQL Profiler to get cpu, IO and duration.

You're going to have to rewrite it from scratch. SQL doesn't have For loops for starters, while it does have while loops, loops are not a good way to work...

Not enough information. What you've left out, and what is critical, is the allowable data loss in the case of a disaster. Need that to tell how far apart the...

On the Vista box, run management studio as Administrator (Right click -> Run as Administrator). It's due to the UAC.

Just an additional comment. I do not personally recommend the use of snapshots for long-term reporting, where a single snapshot needs to exist for a long time. Because they cannot...

With the backups that you list, you can restore using the full backup and the last 2 transaction log backups. What happened to the file from the log backup at...

A large log file is not going to cause performance problems by itself.

All 3 instances set to 10GB? Are they all of equal importance and memory usage?

10*3 = 30GB, so there's 18GB remaining. Is there anything else on the server?

Looks like the file has the read-only flag. Right click the file (in explorer), uncheck the ReadOnly checkbox and click OK. Try to attach again.

I see mentions of K2. Is this a database for one of the K2 business process applications? If so, do you have permission from the vendor to make index or...

You can run a checkDB, but corruption won't cause duplicate inserts. It causes high severity error messages.

Run profiler (or a server-side trace) to see what's happening to the database if...

You will need to script ALTER PROCEDURE statements, edit each one and run the whole lot. If it's a parameter with a constant name, it should be possible to get...

Master is in simple recovery and, even if switched to full behaves as if it is...

No and no.

Snapshots can't be moved after they are created. They can't be detached (the one way to move a database) and, since they're readonly, alter database (the other...

Tested and confirmed

CREATE PROCEDURE TestingIfREcompiles (@Option INT)

AS

IF @option = 1

SELECT * FROM dbo.LargeTable

ELSE

SELECT * FROM dbo.LargeTable2

GO

First execution passing 1 (to get first branch) generates a cache miss and a cache...