Thank you Tomaz for this article.

stefan.lipiec (3/10/2014)

---

I have only scanned the article briefly and I would like say that please check the security implications of enabling xp_cmdshell with whoever is...

Just to point out a possible improvement on the first query in part 3.

The sql engine has to match all rows from the subquery to the outer query. This is...

Thank you Jonathan for this article.

Just a quick note on the last query, it will fail if a table is not in the default user schema.

This will work for...

My 2 cents: SQLCLR is like any other hammer, when you hold it, every thing looks like a nail! I think it is a valuable addition to the SQL Server...

Thank you Darren for this nice peace. I missed the mentioning of some third party tools such as SQL Sentry Plan Explorer.

🙂

don't want to overpromise but could do this in few weeks.

Could do this if you like, would you prefer DBA or data oriented?

Would this be of an interest?

Data de-duplication using 2012 window functions.

Simple cases;

1. A set with no surrogate key defined

2. A set with a surrogate key, related records must be...

Jeff Moden (1/16/2014)

---

Eirikur Eiriksson (1/16/2014)

---

Thank you for the spackle Jeff but it looks like there is a small crack in it as it makes the assumption that the end time...

dcowdery (1/16/2014)

---

I ran into this in the last job...

Calculate the duration between start datetime and end datetime for KPI reporting, factor in:

- Business Days only (no holidays)

- Business...

Thomas Abraham (1/16/2014)

---

Eirikur Eiriksson (1/16/2014)

---

Thank you for the spackle Jeff but it looks like there is a small crack in it as it makes the assumption that the end time...

Thank you for the spackle Jeff but it looks like there is a small crack in it as it makes the assumption that the end time is always greater than...

Thank you Gregory for this clear and concise article.

I cannot resist pitching in some Window function version of the queries;

;WITH CUST_SALES_DETAILS AS

(

SELECT

SSOH.CustomerID

...

Think you nailed it here, just what I was trying to say :Whistling:

Hi Lynn,its an old habit I guess rather than belt and suspender kind of thing.