Fillfactor=when creating the index

example index node can point to 1000 records before a new node needs to be constructed

fillfactor 100%=all pointers point to actual data, if a new record is...

you can also add a second logfile for your tempdb

one other thing is let us say i run the upate statement itself in a begin tran/rollback tran even then everything is reset and app services start working fine. but...

You're welcome.

I haven't tested the differences as most of my stored procedures are quite static.

You can trace all recompilations with sql profiler or an indication using the performance monitor.

I'm still somewhat suspicious to the low amount of free space.

What happens if you set autogrow size to 100 mb instead of 10%.

Is there something in the sql server logs...

It could be that your database or logfile fails to autogrow.

10% of 7030MB =703 MB

available space:693MB ->not enough

is available space in your post  space free on the hard disk or in the database itself?

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...