It might be faster if you drop the indexes first, then perform the delete and then recreate the indexes. You will need to test whether removing the index on...

Hi Phillip -

Just a couple of questions as I read this.

Is there an unusual amount of data in the table today compared to other days?

Are you verifying there is room...

I haven't had any problems and I've been running 3 7.0 SQL Servers from 2000 EM for a year.

Is this database transaction based? Does it continually get updated?

In my opinion, if you have time to schedule a full backup once a day, then you have a good...

I had a FoxPro application that connected to SQL Server 7.0 via ODBC. When my internet connection went down, all the machines except one would access the server and...

You can use constraints on muliple columns with null values.

Have you checked your table to make sure it doesn't already have a duplicate combination?

suggestion:

select col_a, col_b, count(*)

from table

group by col_a,...

I think I found something. Anyone else had issues or success with the hotfix from Microsoft listed at http://support.microsoft.com/default.aspx?scid=kb;en-us;313005

It appears there is a bug with UDFs if they are...

That is why I posted. I am worried. They are identical servers. On the first server he was able to run the select statement 3 times in...

Thanks, he is going to change it.

We didn't do a test execution of the UDF before we used it in the select query. We tried it again on a...

The developer is ok with your criticisms, but would like to know how to do it without a cursor.

He needs the variable to get the value returned from the select...

Have you recently installed new software on your workstation? I've received that error in the past if some program has changed the client network utility and/or the server network...