Top of my wish list...
#1 Inline Scalar UDFs.
#2 GREATEST & LEAST functions.
#3 that ability to use DISTINCT in windowed aggregates.
#4 add a "print" option to...

Here's a quick test, using just over 3.25 million rows of data in both dbo.customer_1 and dbo.customer_2.

Aside from the persisted computed columns on 2, both tables identical with identical...

There’s no reason to use Profiler for this.

Simply do a “CTRL+L” in SSMS, to get the estimated execution plan or “CTRL+M” if you need the actual plan.

Alternatively, you...

When you do a delete (same principle applies to inserts and updates as well), you’re actually doing separate deletes for every index on each of the affected tables.

If any of...

I’m not postponing a reply... I’m stupid drunk w/ fiends & family. Like I said, I’m very interested in picking your brain on this topic. I’m not making an argument...

Jeff,

I’m on a phone at the moment so I won’t try to make a full response right now.

I’ll just say, in my environment, insert hot spots aren’t a...

<removed>

LOL... I think I got it now.

Makes more sense than the Hawaiian Punch guy wearing Harry Caray’s glasses.