We did no index rebuilds were.  The conditions travel with the restores.  The same holds true with statistics.  We do, however, rebuild stats once each week.  It has not made...

My worst nightmare has come true.  We upgraded to 2022 and stuff is crawling now.  We turned off Query Store and went back to the old cardinality estimator and that...

Heh... apparently the OP has left the building!

Thumbs up to the previous 2 replies.  The code is in serious need of some real help and the Developers need to be taught how to write good code.  I'm...

@ericwenger1,

Any chance of you posting the CREATE TABLE statement along with the indexes and constraints?  We might be able to make some additional suggestions, once we see it.

I realize that this is a wicked old post but thought I'd add why I use a backup to NUL.

I do it for testing code demonstrations, especially demonstrations concerning "Minimal...

Me too.  Where's the "Readily Consumable" test data and the desired results that match the test data?

With that being said, be advised... You've been asked to...

I might do that. I confess I've reached a point where I've learned not to ask. Asking tends never to get an answer, only stares. So, learn helplessness.

Still, I'd...

hi,

Just an observation I was trying to make sense of. I'd appreciate anyone's explanation for why this happens.

I've got a table field with datatype varchar(10). If a value greater...

hi,

Just an observation I was trying to make sense of. I'd appreciate anyone's explanation for why this happens.

I've got a table field with datatype varchar(10). If a value greater...

Better yet, click on the following MS Documentation about alerts and teach yourself something new.  It'll look better on your resume, as well.

https://learn.microsoft.com/en-us/sql/ssms/agent/alerts

It's not like the VLF count will go down auto-magically and so your morning report should do just fine in reporting databases that have a high VLF count.  If the...

Yes.  Ola Hallengren's backup  solution.  It's good and it's free.  I'm going to recommend that you do what a lot of people seem to not do... STUDY HIS DOCUMENTATION BEFORE...

I thought I had. Well,...

You haven't mentioned as to whether or not the redesigns are somehow better when all is said and done.

Personally, I'd just ask the boss.