Orlando Colamatteo (1/1/2016)

---

Eirikur Eiriksson (12/21/2015)

---

That's correct, neither optional parameters nor default values can be...

Jeff Moden (1/1/2016)

---

Heh... without going into too many details, I've found that one of the most common query blunders is the nearly religious belief in rote, so called "best practices"...

drew.allen (12/31/2015)

---

GREAT! But suppose your...

Ed Wagner (12/31/2015)

---

Eirikur, I've really come to enjoy your test harness. I particularly like how it uses the actual execution times instead of SET STATISTICS and I appreciate the...

Happy new year and may the source be with you.

😎

Jeff Moden (12/30/2015)

---

--=================================================================================================

-- Calculate the sum of the durations

--=================================================================================================

--===== Calculate the total duration in decimal hours.

-- This won't break if...

Happy new year!

😎

Thank you Steve for this article, very good job indeed.

😎

Another quick solution, details in the comment

😎

CREATE PROCEDURE dbo.USP_LIST_TABLE_AS_EAV

(

@DB_NAME SYSNAME = N''

,@SCHEMA_NAME...

Not too bad twin.devil but there is still room for improvement

😎

Test harness

USE tempdb;

GO

SET NOCOUNT ON;

--/*

IF OBJECT_ID(N'dbo.ExchangeRate') IS NOT NULL DROP TABLE dbo.ExchangeRate;

CREATE TABLE dbo.ExchangeRate

(

...

Alvin Ramard (12/29/2015)

---

Phil Parkin (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

Phil Parkin (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

Phil Parkin (12/29/2015)

---

Grant Fritchey (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this...

Luis Cazares (12/28/2015)

---

It seems like your code can be rewritten like this

SELECT *

FROM TblMain m

Where EXISTS ( SELECT 1

...

I think Jeff has a pint point here with the anti XML and SSIS garlic, keep it around your neck and you will stay healthy:-D

😎

Something tells me that things have...

Phil Parkin (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

Phil Parkin (12/29/2015)

---

Grant Fritchey (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously...

GilaMonster (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

The set based code implies a hash aggregation while the loops can utilize stream aggregation as there is effectively no partitioning in each loop's execution. Makes quite...