Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Scripts by Trevor Makoni 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: | Category: pivot
Rating: |  Discuss |   Briefcase | 4,481 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: | Category: compare
Rating: |  Discuss |   Briefcase | 1,828 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: | Category: file size
Rating: |  Discuss |   Briefcase | 4,053 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: | Category: find
Rating: |  Discuss |   Briefcase | 1,095 reads
   Items 1 to 4 of 4