It could be anything.  Did they switch domains that one of the machines was on?  Did they add any new switches or routers or make any "settings changes".  We had...

Thanks for the links, Martin.

I'm curious... what does the lowest level of management think of what you said.  Has anyone even told them?  And how about the next level or two above that?  Have...

Just to say it out loud... It's very likely that I'll never post anything on GitHub.  However... a lot of companies insist that if you're not adding to GitHub on...

Never mind about me thinking they were talking about "Jump" tables.  I'm not a DW kind of person.

I asked Perplexity.AI the following...

What is a "junk" dimension in a data warehouse?...

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