CASE Statement in SQL - Quick Tip
How to use COUNT in SQL
How to repair corrupt SQL Database (.mdf and .ndf) files