No, probably not.  Look at the memory setting for the SQL server install on both servers and make sure they are both the same.  You should also look at your...

Andrew is right in that the best performance option will be to try to combine the recordsets before you bring them back using a join operation on the SQL Server. ...

What do you mean you wanted to run it away from the client because it takes 16 seconds?

Triggers in SQL 2000 are not asynchronous - if the procedure takes 16...

If you post the schema information or your final query, you may get some help making this perform better.  I can think of two ways to write this that will...

You probably will not have any issues, but keep in mind that SQL creates execution plans very differently on multi-processor systems.

If you have any issues, there are two things you...

Lots of things use TempDB, so this may be tricky to sort out.  Start by looking at the table in TempDB itself to see if they were created by users...

If you are able, terminal into, or sit at the console of the server, log in with the credentials that the SQL Agent is using, and run the package.  The...

i have had several problems with SQL Server 2000 running on VMWare.  We have experienced a problem with the read and write buffers in the VMWare virtual disks reporting back...

You will also have to watch out for your record sizes.  SQL 2000 can only handle a record up to 8k in total length.  You may get warnings about this...

Remove the new thread.  You have said that you need to wait for the order insert to complete before displaying it (obviously).  The point of creating a new thread would...

Again, avoiding the many religious sects relating to data warehousing, I will make a simple suggestion.  Don't underestimate undertaking a data warehousing project.  Since you have not done this before,...

I think the first step is to try to find a smarter client.  It is amazing how much the return diminishes trying to support multi-language systems as soon as you...

Adding them to a table is not terribly difficult.  I would suggest a VB or C# application that just inserts using a loop.  As far as searching the text, you...

Two things to add to this one.

The first is that deletes will take a very long time if you have foreign keys or other constraints that need to be checked...

Aside from using SQL authentication, you may not have any great options.

You could write an application for the users to change their passowrd (rather than the regular windows dialogs) that...