SQL Server 7.0 and 2000 Clustering Resources
A good place to start before clustering. Written by Brad McGhee, the founder of sql-server-performance.com.
2001-05-29
1,816 reads
Performance Tuning
Getting The Best From The Index Tuning Wizard
The Index Wizard is a handy tool shipped as part of the SQL 7 Profiler that can analyze a set of SQL queries and suggest index changes that could improve their performance.
2001-05-16
5,390 reads
Avoiding Bottlenecks with Temporary Tables
Were you aware that the act of populating a temporary table can cause system-wide bottlenecks on your server? Problems can occur both with SQL Server 6.5 and 7.0/2000 in different ways, and in this article Neil Boyle discusses how best to avoid them.
2001-05-08
9,011 reads
Analyze Databases Using Coefficient
In this product review by Brad McGehee, he shows you how Coefficient helps you performance tune your database.
2001-05-02
1,543 reads
Not All SQL Server Indexes Are Created Equal
Just because a column has an index doesn't mean the SQL Server Query Analyzer will use it. Learn how to create indexes SQL Server will use.
2004-09-24 (first published: 2001-04-22)
4,826 reads
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers