I wonder what the "compute cost" of these new functions is?

Thanks for your comments. I understand your points and I would like to clarify a couple of things.

Regarding the execution time difference, batch updates are faster because they reduce...

So drop...

To be honest, I'd delete the REORGANIZE job and disable the REBUILD job.  Microsoft finally took down the 5/30 supposed "Best Practices" on 20 April 2021 and a lot of...

Ditto that.

While I do have an appreciation for anyone that steps up to share information, there are a couple of serious problems with the supposed "Practical Use Cases" in the article...

First,...

Humm... I couldn't get it to work.  You gave: 'USE ? select DB_NAME(DB_ID(''?''))

But I don't know the database name. The server has many databases. I want to search all...

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