Helo friends, hope everyone is doing good. I am working on a project where I have a big fact table having data for 8 years and has around 8-10...

You have datetime columns - don't use between!

where businessdate between '2022-08-01' and '2022-08-31'

means return everything through '2022-08-31 00:00:00.000 (excludes that entire last day of the...

I'm not exactly sure what you're asking but, no matter the language, dates and times are stored as (binary data) Integers behind the scenes.  How they're presented is totally up...

• This reply was modified 3 years, 6 months ago by Jeff Moden. Reason: Added some clarification

Thanks for the feedback.  On this whole thing, remember that planning is the key.  Shoot, the first time I did it, I actually drew a picture of what I wanted...

Just to confirm, the code looks like you only have 1 row per week... is that correct?

If so, LAG would would a treat here.

p.s.  The Sort_In_TempDB thing only takes care of the sorting aspect.  You can leave that in if you want but consider the load it puts TempDB under for such a...

I have a fairly large table, billions of rows, that take up around 3TB of disk. I was tasked with creating a clustered index on this table. I performed...

I thought "cloud" was a polite way of saying "smoke and mirrors" where your wallet gets smoked and they use mirror to deflect your billing questions. 😀

I need to create a query where  the first of March will be  Week 1 starting from Monday to Sunday from the date. If the first of the month...

In the past, we've found a lot of problems with automated deployments that can be described by one, single, four letter word...

"Oops". 😀

I know... I'm weird... I couldn't stop laughing as I read the following article about AI and on-prem.  I mean who knew that computationally intense processes on the cloud might...

The Seek is probably a Seek followed by a range scan of the full table, which probably has little if any advantage over the scan.  I only use the Execution...

So I can learn a bit, which one of Martin's replies does that cover?

On the formatting thing, you could try a free website such as PoorSQL.com with the understanding that there is no support if something goes awry.  There are other sites that...

And, no... I wouldn't do a delete in batches.  You end up blowing out the log file even with that and you end up with no temporary backup if something...