That's really a mistake on your part to think so in the world...

Scott - I agree with Jeff in the sense that this test is somewhat unrealistic because you have CTE's and sub queries at your disposal. However, if this is...

This is the main test q I use to test query-writing skill.  It's not as trivial / obvious as it sounds at first.

A table contains 1, 2 or 3...

I would have to say "No"... not acceptable.  The table that you've defined is different than the table that Scott very explicitly described not once but twice in...

I guess my question would be is... where would a 14 year old hear of such things in such a repeatable fashion that he'd be able to repeat them as...

--DECLARE @CurrentDate as date='2020-11-25'
DECLARE @CurrentDate as date='2020-12-10'

;WITH Data (Id, WeekName, WeekDate) AS (
    SELECT 5, 'Gameweek 1', CONVERT(date,'2020-12-01')
    UNION
 ...

Regarding the accidental DBA, has no one seriously running into the anti-virus scanning issue? The more he posts, the more I'm convinced one of his servers is scanning the...

Thank you for pointing this out to anyone! Optimizing queries and keep your statistics up to date is far more efficient for the performance. The impact of fragmentation is...

Earlier in the thread he stated the database was taking 2 hours.

Database was 500Gb, 200 GB worth data deleted and then shrink files to reclaim space, backup was...

Somebody didn't read the article I directed them to.  No problem.  I'll just post the code in the same manner that the example data was posted to ensure they're equally...

You guys must be suffering from Covid or something.  You guys know better than to banter about with claims of performance without demonstrative code to prove your position. Especially since...

Yes , backups are compressed. Before deleting data it was taking around 5 hours ( this is for the all the DBs in the instance), now it is...

I have table with :

if today is 25/11/2020, then i need to retrive ID 5 because nearst date to today WeekDate is: 1/12/2020

then when today date...

It's not often that I say this out loud but now seems like a good time.  Thank you Steve Jones for being one of the people that started this site...

Doubtful the cause of your pain, but.... the SQl Server Max Memory is set at the Default, out of the box value.  This is usually bad - SQL will...