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

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 suffers from the absence...

Tom Staab (12/29/2015)

---

Eirikur, I completely agree about the month formatting. That kind of thing is definitely not preferable. It was only done to try to make the output the same...

GilaMonster (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 suffers from the absence of technical review...

GilaMonster (12/29/2015)

---

BrainDonor (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 suffers from the absence of technical...

Tom Staab (12/29/2015)

---

Thanks for the response, Eirikur. You are correct that I missed the TRUNCATE with the set solution. I'll look into correcting that later today. Regarding your 3 points...

I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from the absence of technical review and the lack...

djj (12/28/2015)

---

Ed Wagner (12/25/2015)

---

Brandie Tarvin (12/25/2015)

---

I'm genuinely curious how you manage that when all the hotels...

Quick solution

😎

USE master;

GO

SET NOCOUNT ON;

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

CREATE TABLE tempdb.[dbo].[temp_result]

(

[DATABASE_NAME] [nvarchar](128) NOT NULL

,[TableName] [sysname] ...

Thank you Tom for this piece!

😎

After reading it I do have few concerns about the findings:

1. The execution times suggest that a covering index for the aggregation is in place,...

charipg (12/28/2015)

---

Hi,

I need to set run time(dynamic) values for Startdate and Enddate in below query

Enddate should be currentdate and Startdate should be minus 7 days of...

Forgot to post the implementation of the "digits only" logic as a subquery without the using a function, here is one that fits the previously posted test harness. This code...

Quick solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

SELECT

X.[DATABASE]

,X.[PARAMETER]

,X.[VALUE]

FROM sys.databases SDB

CROSS APPLY

(

...

Quick suggestion, use FOR XML PATH rather than EXPLICIT

😎