This issue is on a SQL2K environment
DECLARE @Coverage TABLE
(
VendorID INT,

Can any body tell in what units the following cost are measured
1. Estimated I/O cost.
2. Estimated CPU cost.
3. Estimated Operator cost.

I have a query that selects 31.000 rows with a field list that includes a
ntext field, this query takes over 3 minutes to run.
When running the same query without selecting the ntext field it takes 4
seconds to run.

I know I need to size my databases to avoid growing but I don't always get
the GB's I would like from our storage team.
So I need to grow my datafiles once in a while.
What is the best option for performance? Growing the existing datafile or

I've got a database I'm trying to design for read-only performance. I'm
really a bit out of my element on this, and figured I would ask here...
Quick description of the database:
1. There's one table, with about 25 columns (all NVarChar[50-200]).

In our production environment we have two database clusters.  One is to
handle TX processing and the other is to handle reporting.  At this point in
time, the databases are mirror images on both of the clusters and continuous
transactional replication is being performed to keep ...

Currently we defrage our indexes on a regular basis and defrag then when
statics are at a certain level. What I want to find out is:
Is there a way to add speed control during rebuilding and defragging
process? What I mean by this is that typically I run this at slow times but

        We have SQL 2000 Ent, and Win2003 Ent , In a few day , the sql
server slow performance and error on the sql log , "  Insufficient memory
available " , our applicaition cannot process, we need restart the sql
server,  this is not enough memory or other problem ??? how to ...

Hi, I have a question about indexed views, which I have been reading about
some time now. As far as I understand it, the cost of an update of a base
table will only take place if you update a column that is part of the indexed
view. So (if this is correct) I am thinking that even ...

I see two spools in the execution plan of this query:
----------
USE Northwind
Go