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

Archives: September 2011

Find the largest tables in a database (II)

I once wrote a post to find the largest tables in a database, and now after studying PowerShell, I feel it can be written in a more concise and efficient way.

The following script is to find the largest 3 tables in row count in AdventureWorks

$srv = Get-SQLServer –sqlserver… Read more

0 comments, 1,980 reads

Posted in DBA Philosophy on 18 September 2011

Job Exit Planning Strategy

I feel somehow sad today (Aug 31, 2011) to see one of my colleagues “laid-off”. I put quotation mark around “laid-off” because he is a contractor (same as myself), so it is not, strictly speaking, the real laid-off, however, this “laid-off” was a bit unexpected as the project we are… Read more

5 comments, 1,873 reads

Posted in DBA Philosophy on 1 September 2011