You also have some options. One approach is to use Windows built-in Task Scheduler to trigger a PowerShell script only when the service actually stops, rather than polling constantly....

Hi

How to get the below data we can create dynamically using Sql in a Table and then display using query. I will not be using Pivot .

            
March 12, 2025 at 7:01 pm
            
#4558126

            
            
                                                
        

Are you sure they said "junk" and not "jump"?  There is good use for tables that only contain IDs from the Fact Tables and the Dimension tables.  In relational databases,...

My inline responses are in Bold'n'Black print below....

Thank you Jeff, Please find my inline response below.

If those backup drives are on the same system as your SQL Server,...

From your command it looks like you are using SQL native backup. There are other backup products out there (eg SQL Litespeed) that have as part of their USP...

You can always tell when a new article is going to be popular when the SPAM hits the discussion on it two weeks prior to the date it's supposed to...

If it provides a good answer, especially a more effective good answer, I don't mind.  It'll help others when...

@jeff - a lot of this rings true with me and this situation. My real challenge is how do I move forward. Should I update the stats for the...

This will sound odd but you probably won't get much useful data from the deadlock data other than you're now suffering...

Yes well noted and conveyed the same to business and application owners. They are well are of the repercussions and will take a call on this. Thank you all...

Thank you, have you managed to get past the performance issues as a result of the version upgrade? Do you possibly have any links you can share on why...

The error is telling you what is wrong.  Also, if you go to the KB article, it will also tell you what is wrong.  It's saying that the instances where...

I just want them to fix the serious performance problems that started in 2019 and they've done (apparently) nothing to fix even up 'til today for SQL Server 2022. 🙁

Yes... but it won't help... Stand up your 2022 server and do some restores and then do test runs against your old server and the new one.  The tests should...

Heh... and people wonder why such a thing won't stand up in court.  Ant-Green is spot on!