I have awarded back all points to people as of now. Apologies for the delay, but this was not the high priority of the day.

The question was reworded to use...

Couple other questions. When activity is occurring in this database, is it one large transaction that might be occurring? Or implicit transactions set on?

How many log files do you have?

Definitely...

I agree with Gail. You don't usually need duplicate indexes.

I think it's cool both you and your wife have knives 🙂

coffee

That's funny. I wonder how many people will go there right away and not get it?

that URL, for x64, has two conflicting items. There is a para that says: "Windows Server 2003 R2 Datacenter x64 Edition supports up to 2 terabyte (TB) of RAM (with...

The SQLGuru has hit this nail on the head. If you have a failure after TRUNCATE ONLY and before your next full backup, you can lose a lot of data.

You...

The munitions are the code used, so if you write code that does encryption, you need the license. I believe Microsoft has this, so I don't think you're in trouble...

The hard part about profile is scaling it up. If you double or triple up the trace, you need other clients. I'd think that a tool like this would be...

Nice job, Jeff. Learned a few things myself.

Itanium is a 64 bit processor. The question did not specify x64, it merely said 64 bit windows and the software supports 64 processors. It may be nitpicking, but...

LOL, it is for now. Not somewhere I'm going anytime soon.

i'd agree with George on his advice. If you want to create similar values from your old server, run a sample workload from Profiler/Trace against the new server to get...

I would use the code that David has given you, but I'd be careful because of performance issues.