fast_forward read_only cursor would be the fastest

see fast forward only cursor in the books online

I agree with Mike.

Can you break up the seperate validations in set-based validations?

Mostly every week I hear a story of a cursor getting replaced with a set based solution reducing...

You might also want to check the average disk queue length of the data raid/disk. If it is higher than 2/spindle for an extended period you will experience slowdowns.

Comparision: Restoring...

In the 3th version it shouldn't recompile because it passed the parameters to another stored procedure.

In version 1 & 2 it will still need to recompile because

EXEC (‘SELECT TOP 1 FROM...

Have the statistics been updated & stored procedures recompiled?

You could make the extra Date and Linenumber fields computed fields and add an index on them. Everything stays in sync.

Any reason not to use left(BN,14) instead of all those substrings?

*Is the goal to use the linked server using sql authentication or windows authentication?

If Windows authentication:

This article discusses the delegation of windows authentication between linked server

http://www.databasejournal.com/features/mssql/article.php/3341651

Does your existing stored...

Does chlee exists on the linked server?

*You can add the user to the linked server with sp_addlinkedsrvlogin.

(easier via the enterprise manager)

Rather than having to use sp_addlinkedsrvlogin to create a predetermined...

You can monitor the queries with sql profiler. Check on cpu, read, writes.

Have you checked the table scan, sql compilations, recompilations / sec counters in performance monitor?

If you execute the queries step by step, when does it error out?

You can split the stored procedure later in smaller parts.

--step 1

DECLARE @FinFileName varchar(500)

SET FinFileName ='myfile' -- The...

In which Access version?

We've been using docmd.transfertext in a VBA module to import text-files into tables in Access 97 using a import-specification (takes only 1 time to make them and...

Access 97 has a database limit of 2 gb, Access 2000 and higher 1 gb (not sure, check help)

Is the data already located in another database than the forms/queries/code?

Size doesn't...

exp_dt = cast('9999-12-31' as datetime) would be preferable, since sql server only has to convert once and can use an index on exp_dt.

Otherwise it has to convert each value and...

Ain't familiar with SHAPE.

Does the same happen when you make a new stored procedures that calls the other 3? It might be using 3 different connections.

In sql 2000 BOL:

Indexed views are meant for static tables that have very infrequent changes.

Indexed views can be more complex to maintain than indexes on base tables. You should create...