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...

Pretty cool, @steve-2.

Hello Gurus,

How I am in need of all databases growth in 10 instance and send the report by an email. What's the best way to accomplish such task. If...

Never do reorganize.  On large tables it will take forever and on small tables why reorganize when you can just rebuild.  Treat all your server maintenance like a man...

The real trouble is most likely the way that someone is concatenating the string.  Post the code doing the concatenation and we can probably confirm the issue and, if so,...

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...