Viewing 15 posts - 736 through 750 (of 59,066 total)
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...
February 12, 2024 at 4:32 pm
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...
February 10, 2024 at 12:33 am
... and a few things came together recently that reminded me of you.
Oh my. I can only imagine. Any chance of you sending an email about that? I'm just...
February 9, 2024 at 11:53 pm
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...
February 9, 2024 at 8:10 pm
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...
February 9, 2024 at 7:22 pm
February 9, 2024 at 7:08 pm
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...
February 9, 2024 at 3:49 pm
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...
February 9, 2024 at 3:01 pm
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...
February 9, 2024 at 3:13 am
Just curious why there appears to be a difference with c:\ and UNC.
It depends on where thing are at and where you're running the command from. For example, if...
February 8, 2024 at 6:20 pm
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...
February 8, 2024 at 5:41 am
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...
February 8, 2024 at 3:09 am
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...
February 8, 2024 at 3:03 am
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...
February 8, 2024 at 2:39 am
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...
February 8, 2024 at 12:26 am
Viewing 15 posts - 736 through 750 (of 59,066 total)