Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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  Read more...
By Louis Li 2014/04/07 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 119 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 2014/01/29 | Source: SQLServerCentral.com | Category: table space
Rating: |  Discuss |   Briefcase | 1,533 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,405 reads
   Items 1 to 3 of 3