it is call data cache warm up

Is it any faster speed wise?

Not  really   It should be about the same

 but is something to keep in mind:  Update allows for...

This is a known trick used in OLAP STAGEING situations and rely on the CLustered index being setup.

I do have a bit improvement (?) for the update (which is really...

"text" data type is not available in AFTER triggers but it is in INSTEAD OF triggers. Use the latter if you need access to such columns in the trigger!

Cheers!

This is the site that Bkelly use to check version number and SP/Hotfix Levels

Looks handy to keep around

>> We're at SP3 and we get an error if we pass a varchar to EXEC() that's over 4000 in actual length <<

Sorry but I can't duplicate your scenario

This...

Being in the consulting side you have to consider that the Consultants business is also affected by a lot of irregularities and by a higher tax burden that the FTEs...

It's a shame... I have neither

Yeah I can Imagine!!!

What you did is a good start. Simulation is a BIG topic and with $$$ you can setup many scenarios to see how one interface or the other holds when...

Nice Job. and i think it was a good thread, see my post there 

This is a nice way to demonstrate things but still the subject is even deeper

When you get called to see a server...

Dam! you keep typing fast

And depending on the front end you should use chr(13) + chr(10) instead of chr(10) only

BTW:

DTS and SQL 64bit are ENEMIES no DTS on 64bit SQL) though you can always run...

True, Just making sure that he is aware of that he should pass the list or use one of those tableFunctions that you like to post