Thanks for the feedback.

Well, I am always using the execution plan, so I can understand what's happening, which indexes are used, which are not and I see the suggestions, but I have...

"Bumping" this thread so the first 2nd page post above shows up.

First of all, determine if all those "wonky views" are indexed views or not.

As for not having a DATE dimension, so what?  You've been here on SSC to know exactly...

Talk to your SAN folks.  SAN snapshots are perfect for this.

Hello,

Thank you for your kind response

In this scenario, the goal is to generate a report according to client requirements without using any reporting tools. The query output is directly...

Jonathan's code works only for 3 falculty members.  The op will "settle" for up to 20.

Is there a maximum number of faculty members per course code?

Also, please explain why you need to do this.  This is seriously antithetical to best practices and most practical applications...

We don't use GIT where I work.  I have no need of GIT outside of work.  Until one of those change, I have no need to learn GIT.

I have a...

I'll also suggest that if you're using the Enterprise Edition of 2022, then having only 16GB of Ram isn't healthy.  The reason why your CPUs may be screaming is because...

Why?  In the long run, it's going to be less expensive and less worrisome to buy one, which will also take into...

You have 15 rows that got expanded to 24 and you say you have 30 million original rows, which would be expanded to 48 million rows according the 24/15 ratio...

All,

Thank you for your replies and suggestions. Sorry I haven't been back to this topic, I've had some other unplanned things to sort out. When I get back to...

Step 1 would be to stop doing the re-indexing.  Chances are that you're actually causing more damage than you're fixing especially if your using REORGANIZE or the old supposed 5/30...

I read a wonderful book "A man called Ove" filmed as "A man called Otto" starring Tom Hanks.  Read the book.  Ove is the GOAT of cranky curmudgeons.  The...