Performance Monitoring by Internal Fragmentation Measurement

It has not been clear to what extent fragmentation, either internal or external, truly affects the performance of your SQL Server 2000 databases. New author Koby Biller discusses some of the impacts that it could have and has a free tool for download that can help you determine how fragmented your disk truly is.

Controlling Transactions and Locks in SQL 2000 and 2005 - Part 1

A look at controlling transactions and locks with hints and snapshots in SQL Server 2000 and 2005.

What is a "covered query" ? submitted by Mark...

you have a number of databases making heavy...

What is a bookmark lookup?

Optimize SQL Server hardware performance

Tuning SQL Server for performance is in many ways like constructing a house. You must find a suitable location with rich soil, build a solid foundation to support two or three levels, install the electrical and plumbing, finish the walls for painting and decorating, and finally conduct ongoing maintenance.

What is the difference between a small temp...

SQL Server Performance Monitor

You can monitor the system performance by using the Performance monitor console and its related counters in Windows 2000. These counters allow you to view or save information about the overall performance of your server. When you install Microsoft SQL Server, additional Performance monitor objects and counters are automatically installed. While you must have administrative access to your SQL Server to use these objects, SQL Server admins should find them invaluable in monitoring and tuning the database server. Furthermore, the Performance monitor can be used either locally or remotely, which allows admins greater control in monitoring SQL Server.

Which of these performs better, temp tables or...

Which is better for performance?