A picture of a plan isn't a plan. Also, plans are not a measure of performance. They're a description of behavior. Be cautious about looking at them as a measurement...

You can do a lot of DBCC checks offline through a backup. That's one way to reduce the overhead. All the logical checks will work on a backup. You only...

What @michael-2 says.

The reason you need space in tempdb for the index is because the data must be sorted before it can be written out to the index. So, yeah,...

5GB is less than the VM running on my laptop has for managing SQL Server.

You have to think about how SQL Server works. Let's just talk about reads for a...

AWS RDS doesn't support log shipping, but you can build your own scripts to do it. They have an article on this. Otherwise, what @Ant-Green says.

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...