I feel your pain.  This is micromanagement at its worst.  Personally, I won't row to the sound of a beating drum, the cadence of which has been created by people...

I have a script that was running fine but today it is taking way too long.  I looked at the script and I see these errors:

"cannot specify included columns...

where Date From >=  '2020-04-01'  and  Date To <= '2020-04-28'

There is no data in your sample that meets that requirement.

In

2  ----- 2020-04-01 -----...

Ok... first off, your column naming structure flat out isn't going to work.  It's a worst practice to include spaces in any object names including column names.

Second, if you want...

Heh... I'm thinking about Left_Shift() and Right_Shift() (I always knew them as Shift-Left and Shift_right in the old days).  I can see that giving new meaning to the term RBAR. ...

In most cases (there are exceptions to everything) the following settings absolutely suck on any server...

cost threshold for parallelism 5 -- General advice here is to start at 50 and...

+1000

Start with the "Key Configuration Options" in the following article.  Every single thing there can make a pretty good difference.

https://glennsqlperformance.com/2020/08/20/preventing-sql-server-upgrade-performance-issues/

Sorry.  I...

That's a great answer, Gulshan.

Wow.  Thanks Jason.  I seriously had no clue.  Like I said, my aim is to help, not collect accolades for a resume but that comment just made the last 20...

Be careful, now... sometimes the change is from a value to a NULL.

A different type of "pandemic" was recently launched.  The world will not be "normal" any more... they've recently launched "CoPilot" for O365.

Dumb Dumb me was looking at it in the opposite direction. Its 1AM and because the work computer is in the hallway next to my kids bedrooms I can't...

Cool!  What's the answer?