Without the structure, I'm not going to attempt to write the T-SQL, but you could use a TOP 1 value for the matching between your temporary table and the actual...

Look at the statistics directly. Evaluate why it's receiving the numbers it's receiving. Is the data in the histogram accurately reflecting the data in the underlying table? Is your filter...

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....