Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Trevor Makoni

SQLServerCentral.com profile

   Items 1 to 4 of 4   
 

Dynamic pivoting

Dynamically create and/or execute a pivot sql statement against a provided table.  Read more...
By Trevor Makoni 2015/09/10 | Source: SQLServerCentral.com | Category: pivot
Rating: |  Discuss |   Briefcase | 4,609 reads

Compare two tables for structure and layout

Compare the structure/layout of two tables within an instance of SQL Server (version 2012) and return non-matches.  Read more...
By Trevor Makoni 2014/05/16 | Source: SQLServerCentral.com | Category: compare
Rating: |  Discuss |   Briefcase | 1,848 reads

Get database size, used space, free space

Gets the size, amount of space used & unused, owner and modify date for all databases in a Sql instance.  Read more...
By Trevor Makoni 2015/09/14 | Source: SQLServerCentral.com | Category: file size
Rating: |  Discuss |   Briefcase | 4,159 reads

Find database where table is located

Return a list of databases which contain a table from wildcard table name.  Read more...
By Trevor Makoni 2014/05/05 | Source: SQLServerCentral.com | Category: find
Rating: |  Discuss |   Briefcase | 1,100 reads
   Items 1 to 4 of 4