Without a lot more information, I'm just guessing here. DBCC uses memory. Because of this, data that lives in memory could be flushed out to disk and then it takes...

And one other point, I just noticed, statisticstype you say has three values. You've got it as the first column in your compound key. The statistics probably have one or...

OK, lots to unpack. Honestly, first thing I have to say, it really sounds like this data needs to be properly normalized. I would absolutely focus a lot of effort...

Oh, and...

I can't believe I forgot this...

You can register for the Data Community Summit for free this year. Specifically, look at the Learning Pathways. They'll give you a...

Just take up 3d printing and laser engraving. Then you can print parts for the radio and engrave all the parts. It's a never ending loop.

HA!

In addition to books, you might look above, on the menu bar at the top of this web site, at the Stairways series. They provide a lot of structured learning...

This isn't a bad place for those newly graduated... BUT

Only if they're working with the Microsoft Data Platform. We have some forums on other database systems and some on development,...

Or, look to Extended Events to capture each batch call or each procedure call. It's also possible to capture each statement for either of these, but that results in LOTS...

SQL Server is not open source, so you won't be able to get at the source code. That's a hard limit set by the use of the NVARCHAR data type....

Strangely, during the first lockdown, when I (a DBA, mind) was furloughed (but not for long - they realised their mistake quickly enough) I went looking for things to...

I used to do a lot of volunteering when I was a child but I have since lost that charitable spirit. I do have much less free time but...

Grant, you are a busy man!  What timely post, b/c I was just thinking that I might have stop my volunteer work with the PA Master Naturalist group because...

KC1KCE

And thanks.

To me... no.  Even if you do...

How many files do you have now?