SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts by Louis Li

SQLServerCentral.com profile

   Items 1 to 3 of 3   

Exporting data with header using Powershell

Extracting data with header information using PowerShell 
By Louis Li 2014/04/28 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 1,321 reads

Total space used per table

I have received some comments on getting total space of table and all indexes. Therefore I rewrote previous query and it returns total space used, space used by heap table or clustered index and space used by non-clustered indexes.  Read more...
By Louis Li 2015/02/23 | Source: SQLServerCentral.com | Category: table space
Rating: |  Discuss |   Briefcase | 3,110 reads

List table space usage and row counts

One query to list space used and row counts of all tables  Read more...
By Louis Li 2014/01/17 | Source: SQLServerCentral.com | Category: row count
Rating: |  Discuss |   Briefcase | 1,688 reads
   Items 1 to 3 of 3