SELECT *
FROM (
SELECT 
classement = row_number() over(partition by NumeroContrat order by NumeroContrat desc), -- *
GroupSize = COUNT(*) OVER(PARTITION BY NumeroContrat),
* 
FROM Gestion_Stats.dbo.produit
) d
WHERE GroupSize > 1 AND...

Make it simple - break up the expression using APPLY blocks:

SELECT *

FROM (SELECT output_response_xml = 'A few random words and then... >Thank you') d

CROSS APPLY (SELECT Startpos = LEN(LEFT(d.output_response_xml, CHARINDEX...

Or use an alternative query:

SELECT DISTINCT ec.userID, ec.email 
FROM emailcommunications ec
WHERE ec.email IN ('abc@noemail.com','xyz@noemail.com','wer@noemail.com','lkj@noemail.com','zza@noemail.com','sadd@noemail.com')
AND NOT EXISTS (SELECT 1 FROM tableB b WHERE b.userID = ec.userID)

What's worse: a problem which starts spontaneously and for which nobody is able to track down the cause, or, the same problem spontaneously stopping over the weekend and nobody...

I went ahead and hit the unspam. Let's see what others think. As I said, I could be wrong. More than willing to entertain the possibility (especially since it...

I think there's an error in your GROUP BY, Frederico.

WITH Top5Customers AS (
SELECT TOP(5)
cus_guid, WeekCost = SUM(cost)
FROM job
WHERE duedate >= dateadd(day,-7,getdate()) 
AND duedate < dateadd(day,+1,getdate())
GROUP BY cus_guid
ORDER...

If you're creating a table from scratch and adding indexes to that table, then you won't have to worry about stats from a compression change point of view because they'll...

• This reply was modified 4 years, 8 months ago by  ChrisM@Work. Reason: Added comment about partition-level changes

I page-compressed a table with one Clustered and 4 non-clustered indexes, 5 million rows. Do I need to do any update statistics , rebuild, etc. ?  Before the table...

Grant - just reading your wordpress blog - it strikes me that I'm missing some skills in monitoring SSRS and SSIS using XE... might be...

No no! Nurse! I said "Prick his boil"!

Yep. Friend of mine arrived at the weekend for the trip of a lifetime having booked 22 months ago....

Duplicate of https://www.sqlservercentral.com/forums/topic/overlapping-date-range-query-duplicating-row-in-reverse 

SELECT *

FROM #DATA t1
INNER JOIN #DATA t2
ON t1.MEMBER_ID = t2.MEMBER_ID

AND t1.SERVICE_CODE = t2.SERVICE_CODE

AND t2.SERVICE_START_DATE <= t1.SERVICE_END_DATE

AND t2.SERVICE_END_DATE >= t1.SERVICE_START_DATE

--AND t2.SERVICE_START_DATE >= t1.SERVICE_START_DATE -- I think this is...

There are some excellent papers out there discussing the pros and cons of table variables and temp tables. Here's one of my favourites: https://www.sql.kiwi/2012/08/temporary-tables-in-stored-procedures.html

SELECT 
CwsCalID, StartDateTime, EndDateTime, TimeSlotAvailable,
[ConsecutiveAvailableTimeslots] = COUNT(NULLIF(TimeSlotAvailable,0)) OVER(PARTITION BY Grouper)
FROM (
SELECT *, 
Grouper = ROW_NUMBER() OVER(ORDER BY TimeSlotAvailable, StartDateTime) - ROW_NUMBER() OVER(ORDER BY StartDateTime)
FROM #T
) d
ORDER BY...