Does querying the sys entities and DMVs lock the underlying tables and what happens when SQL Server tries to write to them?

All we need is an easy explanation of the problem, so here it is. If I do a vanilla SELECT * FROM sys.tables or SELECT * FROM sys.dm_exec_query_stats are those…

Continue ReadingDoes querying the sys entities and DMVs lock the underlying tables and what happens when SQL Server tries to write to them?

reporting space consumption to files in filegroup – how to reverse-engineer the algorithm spreading data across files

All we need is an easy explanation of the problem, so here it is. I would like to know how to calculate the distribution of data consumed per file in…

Continue Readingreporting space consumption to files in filegroup – how to reverse-engineer the algorithm spreading data across files