And yet it's still absolutely stupid about certain "simple" things...  In the example below, this is NOT the right way to solve the given problem.  Even the note in the...

Be REALLY careful here folks.  The answer and the reason is correct except for one of the most important places in SQL Server and that's for the DATEDIFF() function.  The...

When Agile is used for rapid feedback with responsive customers it can be an effective way to flush out system requirements.  I've more often seen Agile used as...

@sathishkm-2

Did either of Ed B's solutions work for you?

If not, could you post what the output should look like using the test data you've provided?  I'm also not sure what...

My online index rebuild job for a 200G table with 40mil rows took me up to 30hrs to complete, this is a once off activity done since we have...

... I also gave a presentation on how to secure it properly way back in (IIRC) 2013 at the now defunct Kalamazoo, MI SQL Saturday.  It's where I...

Lordy... the wondrous things I've used it for... there's no way for me to list everything I've used it for.

Exporting files is one of the big ones but also the...

I have a number of friends moving to SQL 2022 and haven't had Jeff's issues. If you look at Brent's version spread (For his customers), lots are/have moving/moved to...

I wouldn't use DELETE on a year old table.  That'll be a lot to delete and it'll cause a "log file explosion".

I probably also wouldn't do a whole year at...

I totally concur.  Back in the late 90's and early 2000s Hoshin Principles; Greenbelt and Blackbelt training; Design-for-Six-Sigma, all stressed the importance of the "voice of the customer" and...

A lot of links for that incident show up with the following search.

https://duckduckgo.com/?q=robot+suicide

"Bump" to make the 2nd page of the discussion show up.

The greatest technical debt I have ever experienced is when we migrated from SQL Server 2016 to 2022.  That means that I'm still experiencing that "joy".  Overall, "It just runs...

Jeff - I'm going with Scotts recommendation which sticks with CAST and not FORMAT.  That said, just out of curiosity do you know how much data/rows need to be...

Heh.. "next time".  You're saying that because someone already did it but... they did...