Thanks Frank.  That article was very helpful.

I will be:

1) Setting size for the year

2) Running disk defrag (with SQL services off I assume - the article didn't stipulate)

3)  Running DBCC...

From an article by Microsoft:

"All work done by DBCC DBREINDEX occurs as a single, atomic transaction. The new indexes must be completely built and in place before the old index...

That's good news.  This server is licensed by the processor (dual).  So, I have a question about memory.  SQL 2000 standard is only able to recognize 2GB of memory.  Does...

I found the answer.  C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe

This is the server network utilities.  I had to enable Named Pipes and TCP/IP - now I can connect to it. 

No, the MSDE instance was installed with default params.  Is there a way to set this parameter after install?

Thirveni,

Are you sure that the SQL text(16) field is truncating the field?  Any chance you are seeing the display length limitation of SQL Analyzer?  How are you confirming that the...

Hari,

I'm not sure how to do this exclusively in T-SQL...  However, in VB, it wouldn't be too hard.

You could make an ado connection to the DB.  Then create an ado...

Jeff, I'm not entirely sure what you mean.  Although, if the MS Access iif statement is what you need, take a look at SELECT CASE in SQL's books on line...

Thanks to you both.  Both solutions worked properly.

Ryan

Do you have a high minimum query plan threshold for determining what queries recieve parallelism?

Also, have you restarted the server (or at least SQL) since you made the change?

Thanks for the responses.

Ryan

Greg, thanks so much.  That was it.  I didn't know that the arrows connecting the objects were objects as well.

Thanks

Ryan

Kevin, I don't know (and may not know) what columns will show up in the where clause of the SQL.  My programmers often don't provide me with their code.  If...

Carl and Ray, I think you are both partially correct...

Carl, as you said, non-clustered indexes do not have to be covered to be used for a query.  In fact, unless...