I might swing by.

One point, since there are a large quantity of completely different databases that store healthcare information, you are unlikely to find a generic list of "SQL queries" that will apply...

The basic principle of CROSS APPLY can be summed up as, for each row in my data set (defined by the table or tables you're using the CROSS APPLY against)...

If you'll notice it appears a third time right next to the first CONSTRAINT. What you're seeing are different pieces of the command. The first, capitalized, reference is to the...

That's.... a lot.

From an update I can imagine a scenario where you get quite a few page splits and end up with the size growing 2-4 times. A...

Haunted mouse for Halloween. Seems appropriate.

There are a bunch of things that could cause differences between environments. ANSI connection settings, cost threshold for parallelism, max degree of parallelism, memory, cpu, disks, data, statistics, structures. Any...

And our buddy is sending me private messages now. I can't believe how far he's gone in trying to get answers to questions he already has answers to. Ah well....

And I'm done. I really did try, but at the end, it was a serious waste of typing and CPU power. Ah well. I guess I'll never see the super...