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.

The RAQ Report guys are getting on my nerves. I'm tempted to make an announcement that I would not recommend doing business with them as they are disruptive and not...

Sent George a note. We'll sort him out.

Bru is correct. You cannot share the data files for load balancing. There is a shared READ system using a SAN for Enterprise edition, but it will not work for...

Views and stored procedures are used for two different things. A view encapsulates a single query and presents it as a table. A stored procedure is a code block.

What I'd...