Thanks Antares! I finally went and read the MS article you first recommended. I didn't read it at first because I thought it would be something similar to...

I have tested the technique described in example 1 of my article on a table that has 1.8 million rows.

When getting half to all of the rows I...

The first example has been tested on larger searches, up to about 5500 rows and does well. The execution plan for that stored procedure shows a clustered index seek...

Thanks for the suggestions. Let me explain a bit further. The SQL Server 7.0 that we want to put the EM from SQL Server 2000 on is dedicated...

Yes your comments help. Thanks!

I have a few more questions. What kind of profiler problems did you, cjlane, encounter? We don't use it a lot, but on...

Also, does anyone know can we install the EM for SQL Server 2000 on a SQL Server 7 without upgrading the server to 2000 and without installing an instance of...

You would have to work on site.

Robert Marda

You'll forgive me for answering my own question, but I just found out how to fix this problem.

Enties in sysdbmaintplan_databases and sysdbmaintplans were missing. So I inserted one row...

My official title is SQL Programmer. However, from what I read here it sounds like I am doing many DBA tasks.

I develop stored procedures for new features as well...

Thanks Brian!

Robert Marda

It never occured to me to test for Windows only authentication. I've always used mixed authentication mode with the SQL Servers I've managed. I'll have to look into...

One way to modify solution 2 to work with the mentioned operators (=, <>, > , <, IN) is to create the WHERE clause like this:

WHERE (A.name = @Aname or...

You're welcome.

Many performance issues can be solved with indexes when you know the query is not the problem.

Robert Marda

The first thing I would check is to see if the tables have indexes where needed. If not this could be the cause of the slowness you are seeing.

Without...

I am a slow typist. Last I checked I typed at about 40WPM. I may be faster now since I've had more practice.

Before 1994, I hunt and pecked....