Welcome to TechNet Blogs Sign in | Join | Help

November 2006 - Posts

Understanding Perfmon Counters while troubleshooting SQL Server Performance Issues

Understanding Performance Counters data while troubleshooting Performance issues in SQL Server To troubleshoot overall Database system performance issue, analyzing performance counters is the best way to start. By collecting performance counters during
Posted by vishah | 2 Comments

Say "No" to in-line SQL

or suffer..... these are some points one should consider when using in-line SQL: ยท Tuning and deployment . Stored procedure code is stored in the database and allows database administrators to review data access code and to tune both the stored procedures
Posted by vishah | 0 Comments

Useful resources for migrating to SQL Server 2005

Comparing Enterprise Development Productivity: SQL Server 2005 versus SQL Server 2000 http://www.microsoft.com/sql/prodinfo/compare/devprod2000.mspx "This independent productivity study, conducted by 3 Leaf, compares two developers working independently
Posted by vishah | 0 Comments
 
Page view tracker