A Month of SQL Server Tips - Week 3

This month, TechNet Magazine is bringing you A Month of SQL Server Tips.  We're posting a new tip every day, Monday through Friday. Here are the tips from the third week of January 2009.

Ways to Find out What Data Was Deleted by SQL Server Repair
In the unfortunate case that you have to use the REPAIR_ALLOW_DATA_LOSS option, some data will inevitably be lost. Find out how you can determine what data was lost when running the repair option.

Use the Query Governor to Control Excessive Query Execution
You can easily prevent costly queries from executing by configuring the query governor. Find out how to do this in just a few simple steps.

Manage SQL Server Services from the Command Line
You can manage SQL Server from a command line just as you would any other service. Here are the commands you need to know.

Use T-SQL to View Database InformationYou can use Transact-SQL (T-SQL) to examine database information. Here's an overview of how to view database information and what it all means.

Know the Monitoring Tools and Resources Available in SQL Server 2008
Reliability and Performance Monitor and SQL Server Profiler aren't the only tools you can use to monitor SQL Server. Here is an overview of other key resources you can use.