I don't know if thats possible, but, perhaps you could write a little test application that simulates the expected load and environment on that table independently of the others,  and...

There are a number of approaches that you can follow, as the others mentioned. A couple of rules though:

1. Have a clustered index on your primary key - I have...

Hi, without more information everything is just a guess. But, I'd say, since re-building your indexes helped for a little while that you may have a couple of problems that...

Duplicates can be checked for using @@error, just remember, if you are calling into SQL using a client, e.g. java, each error you ignore is going to be passed to...

Also, you'll probably find that the statistics are out of date.

Try running the query and profiling with the Profiler for warning and statistics events, or run the same query...

Thanks Jonathan, that would be most helpful.

Thanks Kay,

Thats something I hadn't thought of.

Sorry guys, I mean't one column, not one row. I can do this, but the overhead and risk is not really worth it, since we will have to also find...

We're already using the simple, but since the Alter table command is one "atomic" command, SQL is forced to write all changes to the log first, otherwise, if something goes...

Thanks,

Yeah, I can get the data out of one row with bcp, but I can't bcp only one row back [;-)].

The upgrade is on a test machine, so its...

Thanks Jonathan, looks like our copy will do the trick, we need to grow the log file manually before we upgrade to around 1GB to avoid the extra time SQL...

Hi Mark,

Yes, re-creating the schedules resolved the problem. I have had no luck finding the exact reason for the problem though.

You might wan't to turn it off again afterwards though. I believe that its a connection wide property, and will therefore affect other transactions if you are re-using your connection...

I ran into the the following problem after installing Windows 2000

Service Pack 4 on a Cluster.

The SQL Server Agent jobs that run operating system commands, and were

running and enabled prior...

Hi All,

I have personally seen two issues. The one pertains to Clusters specifically, and is basically that SQLServerAgent stops firing Operating System jobs.

I had to re-create the schedules...