Subscribe to this blog
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, 669 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, 807 reads
Posted in DBA Philosophy on 1 September 2011