Alan.B (6/1/2016)

---

I learned this technique from Eirikur Eiriksson. One of...

Evolution at work: here's Alan's excellent solution tweaked to read the source table only once.

;WITH _Tally (n) AS (

SELECT 0 UNION ALL

SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL))

FROM (VALUES (1),(1),(1),(1),(1),(1),(1),(1),(1),(1))...

Nice job Alan.

A few years ago DC and I played with numerous variations of this method as a spinoff of the PatternSplit project. One of the most promising methods was...

Currently the fastest known method for converting a bigint to an int.

Other than arithabort, the remaining differences - as far as I can see - are...

and does this exclusion apply to inline...

Your script generates an error.

Text data should be delimited with single quotes, columns should be delimited with commas. Each row should be delimited with ( and ), and you...

TheSQLGuru (5/31/2016)

---

Has anyone asked for an estimated execution plan yet? What about table create scripts (complete with all keys and indexes)? Perhaps there is an unintended cartesian to be found,...

Lowell (5/31/2016)

---

ChrisM@Work (5/31/2016)

---

Google "SQL Fertilization" with the quotes and most of the links appear to relate to a single job advert, something to do with Broadridge. Best guess? A dopey...

Google "SQL Fertilization" with the quotes and most of the links appear to relate to a single job advert, something to do with Broadridge. Best guess? A dopey recruiter has...

Can you post an estimated execution plan for this query please, as a .sqlplan file attachment:

SELECT bo.MedRecReviewID, mrr.MedRecReviewDetailID

INTO #MedRecReviewID

FROM [CPROD1].dbo.TABLE_A bo WITH (NOLOCK)

INNER JOIN [CPROD1].[dbo].[TABLE_B] mrr WITH (NOLOCK)...

Focus your attention first on constructing something which can be used as a reference query – 24 hours is too long to wait for two queries to run to see...

Can you confirm that these two queries are logically the same apart from the DISTINCT?

SELECT DISTINCT bo.MedRecReviewID

FROM [CPROD1].dbo.TABLE_A bo WITH (NOLOCK)

INNER JOIN [CPROD1].[dbo].[TABLE_B] mrr WITH (NOLOCK) ON...

ChrisM@Work (5/25/2016)

---

Ideally you would do this by posting a script to...

jc85 (5/25/2016)

---

ChrisM@Work (5/25/2016)

Sorry my bad, missed the correlation:

SELECT

[date] = CAST(b.start_time AS DATE),

[report_item] = (b.[source] + '-' + 'a.report_item'),

[EN] = SUM(CASE WHEN b.lang = 'EN' THEN 1 ELSE 0...