get size from bunch of rows slq server code example

Example 1: how to get the particular record size in table

dbcc showcontig ('YourTableNameHere') with tableresults

Example 2: how to get the particular record size in table

SELECT * FROM sys.dm_db_index_physical_stats (DB_ID(N'AdventureWorks2014'), OBJECT_ID(N'[sales].[SalesOrderHeader]'), NULL, NULL , 'DETAILED')

Tags:

Misc Example

Related