💯 I've known this about myself for awhile and fortunately this, my last job before I retire, is all about cloud, azure, which I wanted to learn but not had...

I recognize some of you from the Chicago Redgate thing this week. The DBA community is an old-crew but I would say young-at-heart.

As for my real comment...just yesterday I spoke...

Very nice. Thanks. That's one of my favorites too.

Thanks Prakash,

Though plan guides and pinning plans has been available in earlier versions, this exemplifies how much easier it is with querystore features in 2022. Thanks

A couple of more thoughts:

I originally made this a table-function but had to replace the waitfor with a clunky loop checking getdate(). The function was nice because you could select...

this was supposed to be in SQL2012...I inadvertently added to sql2005 section...will create a new one there as well.

MY shrink ended after 4hrs.....most of that time the dmvs indicated it was waiting on the same page....too weird.

But the take-aways I have are multiple file objects will require cross...

OK, I've turned up something....my DB has a table with varchar(max) LOBs stored off-row. So some pages on file3 are linked to pages on file1. the process of true-up of...

ok forgot to turn on the traceflag to allow print display.

did this and now I can see stuff from DBCC PAGE....but still don't understand whats goiong on.

DBCC TRACEON(3604)

DBCC PAGE(9,3,15411328,3) with...

Also when I do:

DBCC PAGE(9,3,15411328,1)

no results (tried levels 0,1,2,3 in 4th parm...nothing)

Am I misunderstanding something here? Isn't the "3" in the Activity monitor Wait Resource the fileid?

Any...

SORRY, put this in wrong forum....is SQL2012 not SQL2005 and didn't realize the context I was in....I will add this to a SQL2012 forum instead. Consider this closed. Sorry don't...

Let me know how l can improve....the descrption?...how it helped me?...does it not work? Let me know. Thanks

Good article. Covered the basic configurations that people are "thinking about". Thanks.

I've set up multi-node Oracle RAC that uses a private interconnect for very quick block movement needed to keep...

Yeah, there's a lot out there on lsass.exe ... none of it applied to me until i found this one.

if its a domain controller, there is another fix.