Tables, Queues, and Indices as a Percent of DB Size
Two views that give you a variety of stats, sortable as a percent of DB size, for tables, indiceses, XML indices, and Service Broker Queues.
2012-10-09 (first published: 2008-06-16)
3,042 reads
Blogs
Daily Coping 13 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Converting a SQL Server Docker image to a WSL2 Distribution
Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives...
Everyone Run a SQL Saturday in 2021
By Steve Jones
With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....
Forums
Upgrade from 2017 to 2019 SQL Instance
I have finally been given the green light to upgrade my SQL instance (starting...
Top 1 makes very fast query into very slow query
I have a very simple query: SELECT AkcesAutoID FROM ( SELECT P.AkcesAutoID, A.AkcesitPred, A.Akcesit,...
SQL Server 2016 - Two issues when restoring database in standby mode
SQL Server 2016 - Two issues when restoring database in standby mode on a...
Ask SSC