This version uses .net...

In my personal view it looks like Microsoft trying hard to kill SQL Server.

Nearly 100% of the added features in recent releases are available in enterprise editions only, and 2014...

Maybe it helps to agree on certain roles first and work out an appropriate list per role?

For example, I would see at least these distinctions as useful in writing about...

David McKinney (2/6/2014)

---

Damned if you do, damned if you don't!

I find the criticism somewhat harsh. Am I alone in thinking that articles don't have to be exhaustive? I...

One more that would be very high on my personal list:

Currently, cascading behavior on foreign key constraints is severely limited, for unnecessary reasons I might add, see the case below:

create...

How could I forget and not add this to my primary wish list:

* Allow computed columns to reference other computed columns. Just throw an error in case of a circular...

I would like them to basically fix everything they added the last few versions to useful levels:

1. Output clause issues

Output result set only works when no trigger is present (but...

I think the term DBA is quite fuzzy.

There are many technical specializations within this blanked title that are widely different in skill set.

Take your pick from this small list for...

This will indeed not work:

declare @date1 as date = '2013-01-01';

declare @time1 as time(2) = '16:20';

select @date1 + @time1;

But this will:

declare @date1 as smalldatetime = '2013-01-01';

declare @time1 as...

Jeff Moden (1/21/2014)

---

JohnFTamburo (1/21/2014)

---

Jeff Moden (1/21/2014)

---

I know it's a personal preference but I've worked with "DateDIM" tables that use date and time serial numbers and I've never understood why people...

We use such date tables as well, but structured quite differently, see the script code for details.

What it amounts to is our own integer based structured date type, with years...

Now, I get the point your trying to make and believe it would be good to incorporate your explanation in your original post in the same manner and maybe I...

Jeff Moden (12/11/2013)

---

Thanks for the heads up and apologies for the error (I've corrected it). Apparently I made a change directly in the article to make up for...

Jeff, I agree and SSD usage to cover up slow code was not my point.

Your explicit RBAR example compares two situations:

1. one does a cross join with an insert...

Jeff,

In your cross join examples the table #TestTable is written as ETestTable, causing an error if not corrected.

In addition to this, I found the explicit examples not match my performance...