SQL 2022 will give you batch mode execution plans on indexes that are not columnstore, even if batch mode execution plans are slower.

Did you look at the execution plans...

@lisa,

My whole point is that the use of a function for such temporal range labeling is actually easier for the users to use because they don't need to us a...

Oh my.  I can only imagine.  Any chance of you sending an email about that?  I'm just...

Back in the day, before SQL Server 2012 was previewed, I worked on a project which started with a blank database.  My teammate at the time started sending me...

I've been a member of this forum for 17 years, mostly a lurker with very occasional posting or replying.  I am the baby Jeff at my company.  My scope...

😀

Whether you are a Brent or a Jeff there are some pitfalls to watch out for to avoid burning yourself out.

Do others see you as a leg up or...

We have a requirement to allow certain nominated users to execute 'jobs', where the definition of a job could be running a stored proc, or a PoSh script, or...

Whoa... oh my... now there's a subject I didn't plan on reading about tonight. Other than stating that my levels of imposter syndrome just shot through the roof, I'm not...

It depends on where thing are at and where you're running the command from.  For example, if...

Heh... no... I agree... BBFAATT will never be able to compete with RBAR.

Also, sorry about your argument with set-based v.s. RBAR thing.  I'd have to see what the two things...

And, sorry... I forgot that it's a bit new... "BBFAATT" is pronounced as "bee-bee-fat" and is my acronym for "Books, Blogs, Forums, Articles, AI, `Tubes, and Talks".

Heh.. and if sarcasm...

Fair point @jeff, but I think Ron and many other people who build DWs (or Power BI developers?) are more concerned with making the data, and potential calculations, as...

You may have never seen a good data warehouse.  The advantages over standard reporting procedures are significant.  Calculations such as YTD, PTYD and the comparisons of the two, rolling...

I've always had a bit of an issue with Data Warehouses and some of the techniques of using dimension tables... especially temporal dimension tables.  While this is a very nicely...