I have a huge table with 3B of rows containing around 6 months of data running on Microsoft SQL server 2017 (RTM), which is partitioned day by day on...

Unfortunately there is an old bug that for some reason Microsoft is not fixing.  When using top clause or min or max aggregation functions on a partitioned table, SQL...

I'm getting the impression that you think a product for hundreds of millions of users has to work the way you want it to. If it doesn't, the product...

Fair point.  I was trying out my solution on a test database that didn't have a prepared Calendar table, so that was my quick hack.  I should have cleaned...

I've been through this one before... How many Foreign Keys are pointing at that table?  You may have to add indexes to the columns in the other tables on the...

Like I said, I didn't find the sorts to be obnoxious for the basic Windowing functions... it's the bloody partitioned COUNT(*) that was doing it and I found a work...

Heh... I look at it another way...

In more than 30...

I am looking for a script  that can return the following values for each of the databases in my instance: Object ID, Object Type, Database Name, Table Name, Schema...

Frederico attached a converted copy as a ZIP file.

I've been playing with this some more, Scott.  It turns out that the Partitioned COUNT(*) is just freakin' nasty (creates 145 extra reads on a 2 page table) compared to...

How would Microsoft actually handle this case though, without disabling the ability to convert MAR1 into the 1st of March for the rest of the users? If the trick...

OMG!  The world has gone completely mad.  If you still don't think that spreadsheets rule the world, read the following article.  The "punch line" after the title of the article...

having a sqlplan won't give you the sql query (the one that matters) on this case as a view is being used.

main query is a view - I would...

For me, the link provided by the OP doesn't point to an SQLPlan file.  It points to a file but SQL Server doesn't recognize it as an SQLPlan.

Eirikur,...

For me, the link provided by the OP doesn't point to an SQLPlan file.  It points to a file but SQL Server doesn't recognize it as an SQLPlan.

Eirikur, what did...