Have you asked anyone???

Two way street here... what was the solution that you figured out?

Hi,

I have a strange situation where SORT operator is taking 10 sec in prod database and when run the same query in Test SQL instanceI'm not seeing that SORT...

Your backup, to a table in same database, is it for migration/upgrade purposes?

(If so, maybe set database to single user mode, first.)

Otherwise is it possible to use the builtin...

Maybe the way you're doing it.  Answer my previous question, please.  You'll be amazed at how fast we can make stuff. ...

Yea right, it's super precise so...

We need to correct your attempt at DDL. By definition, a table must have a key, but this is impossible with your DDL because both columns are NULL You...

This was and...

In the project I'm working on we're about to implement 4 temporal tables in Azure SQL.  In the past I've worked with version tracking using  guids and triggers.  The...

This was and still is...

All of ya’lls comments are absolutely correct.  Not sure where my brain was when I wrote the original paragraph, but obviously not in this universe.  This is what I...

Thanks for setting up the tests and crunching the numbers, Mike!

I just wanted to take issue with this (emphasis mine):

Data can be added row by row to a page...

The OP posted readily consumable test data... show us the code to use LAG to solve this.

Don't you just love it when you get a "urgent" work request that needs to be done "NOW", because it's impacting staff productivity, so you get the work...

Hello,

I'm still fairly new to SQL Server.  We have a production database at our company that has grown from about 40gb to 100gb over the course of about five...