For those of you setting weight goals, I'd discourage that. I think you ought to work on your health, and trying to get to the point where you can do...

You can snapshot a publication, or at least I believe you can. If you have a pub with ONLY stored procs that can work.

You might be able to script out,...

GilaMonster (1/4/2011)

Missed it when Steve cleaned up. Someone enlighten...

From here: http://www.cpuid.com/softwares/cpu-z.html

Nope, I had this file

cpu-z_1.56-64bits-en.zip

Ambitious goals, Craig, and I wish you luck.

Should the handyman chores for 2011 be more specific? I know I need to add a few of them to my list.

Gail is correct. While it will "act" like a 2005 database, the physical structure changes, and the 2008R2 engine runs against it. The code in interpreted as though it were...

Someone suggested sp_addscriptexec, but carefully.

http://msdn.microsoft.com/en-us/library/ms174360.aspx

I'm thinking that you can add a new article http://msdn.microsoft.com/en-us/library/ms146887%28v=SQL.100%29.aspx

I cannot see a way to get around the snapshot, but if you have a snapshot of procs, is that a...

Is there a question here?

Nice job, Jason. Good explanation, and looking forward to reading about the other join types.

AFAIK, Gail is correct. You do not downgrade from 64 bit to 32 bit. You license the edition. The platform you choose is up to you. 64 bit does not...

I tend to agree with Gus. Despite the good I think it would do, many companies worry that if they release this, they will give something away, or look bad....

You can try something like this: http://www.sqlservercentral.com/articles/Stored+Procedures/tsqldoc/678/

There is still a small chance here that two people would run the SELECT at the same time, then one would get the update lock.

Ultimately, what are you trying to...