Here's another example where it appears to be a well supported "Holy Grail" article.  But, it produces "week start dates" that are greater than the original date.  That's means it's...

Microsoft SQL Server 2016 service packs are cumulative updates and upgrade all editions and service levels of SQL Server 2016 SP1 to SP2. This service pack contains up to...

Hi and welcome aboard.

Be advised that your post looks and smells like...

I think that the easiest way would be to add a column to table A with an "OffsetDate" column built in.  That will also me nicely indexable and easy to...

Hello friends, I am a casual learner and right now exploring the DBA field (I am a database developer). Now I recently had a discussion with my group of...

Partitioning is not a method of increasing performance of code.  In fact, it usually slows code down, sometimes by a far amount.

A newbie here. I have these columns, here are the samples and the data types I've chosen:

I'd just like to ask if the choices I've made...

It can't be deleted.  No worries there, though.  It can actually help others if they end up with a similar question.

It looks like you want the results from the first table when they don't match.  For this specific case I would use EXCEPT instead of joining and comparing:

            
June 18, 2022 at 7:49 pm
            
#4051531

            
            
                                                
        

You know what I'm going to say, Phil.  SSRS is... an application.  You already know the rest.

Thanks for the code modifications, Steve.  I'll take a deeper dive than just looking at it.  Nice to see someone actually test both out a bit.

In the past, I've shyed...

Thanks a lot Jeff for...

As a bit of a sidebar, man!... The supposed SQL Format for the code windows is absolutely horrible! 🙁  I wish they'd do something about it.

Here's Rev 02 with a shedload more documentation in the flower box and 3 extra columns that seem useful to me.  I think I may turn this into an article...

• This reply was modified 3 years, 9 months ago by Jeff Moden. Reason: Added warning to header

Thanks Jeff,,

I have been using the formula:

if ($Average_Fragmentation -gt 40.00) { Write-Host -ForegroundColor Red "$Index_Name is more than 40% fragmented and will be rebuilt."; $index.Rebuild(); Write-Host -ForegroundColor Green...