Improving SQL Server Performance

From TechRepublic.com:

Diagnosing SQL Server performance issues using sp_lock DBAs can effectively diagnose database locking issues by using the SQL Server sp_lock system stored procedure.

Demo: SQL Server 2005 High-Availability Capabilities Microsoft's demo focuses on the high-availability capabilities of Microsoft SQL Server 2005 and how it enables organizations to do more with less by delivering a data management and analysis solution that is dependable, productive, and economical.