Quickly Find Table Row Count and Disk Size in SQL Server скачать в хорошем качестве

Quickly Find Table Row Count and Disk Size in SQL Server

Here's a quick video to show you how to find the size of any database table in SQL Server. You can use this technique to find the number of rows in a table as well as determining how much storage space the table uses. To find the size of a SQL Server database table just run this query: sp_spaceused 'Person.Address' The table name goes in single quotes after the system stored procedure sp_spaceused. Here the table name is Person.Address. The results contains the following rows: rows: number of rows in the table reserved: total space used by table (KB) data: total space used by just the table's data index_size: total space used by the table's indexes unused: space reserved by but not yet used by the table How to find table names using a SQL query:    • How to Quickly List Table Names in Any SQL...   Just be aware that the data returned may be different if you're using advanced technologies and techniques such as Azure Synapse Analytics, Analytics Platform System, remote tables, stretched tables or memory optimized tables. sp_spaceused reference: https://docs.microsoft.com/en-us/sql/... If you found this video leave a LIKE and SUBSCRIBE for more coding videos. Check out my SQL Programming playlist for more tutorials:    • SQL Programming