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,660 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 2016/05/13 | Source: SQLServerCentral.com | Category: compare
Rating: |  Discuss |   Briefcase | 2,532 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,193 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,111 reads
   Items 1 to 4 of 4