It's the column 'modification_counter' in sys.dm_db_stats_properties.

You don't need to use a cursor for object ID and stats ids. You can use CROSS APPLY to pass them.

Interview question?

The root reason is that fragmentation impact large range scans from disk. Emphasis *large* and *disk*. If the table is small, then fragmentation will have minimal effect and can probably...

Keep in mind that application name can be pretty easily spoofed. It's set by the connecting application.

How big is the index? iirc, by default Ola's script ignores small indexes that don't need to be rebuild/reorganised.

Dividing TempDB won't do anything about space problems. If TempDB is 250GB, it's 250GB, doesn't matter if it's 1 file of 10.

If TempDB is getting full, your options...

Get the queries optimised. The chance that you have a spinlock problem is small.
Most performance problems are bad queries, bad indexing. Address those. Don't go looking deep into...

Spinlocks, for the most part, are not going to be an indication or guide for why a query is slow. They're something that you can and should ignore inmost cases.

Have at least 6 months income in the bank before you quit your job. More is better. It'll be slow to start, and you will have periods with little to...