As its one Db with one table, remove Physical RAM from your machine and put new RAM. You will see physical read for which you are so curious to see...

i suspect this is the problem of data source.

Can you please confirm that all the server which u using in linked server are of similar type....i mean all sql...

can you please share the third party backup tool name you using?

I am using litespeed since ages and never had any problem

How we can start the delete process from the Master table? Put it in other way, how we can traverse from

the Leaf child and go to top (may be we...

you should be...

what is the full description of errorr?

yes correct but if that is not so frequent activity then you can rename old file which you already inserted and then new file should be named exactly as we...

Authentication you define in secuirty tab when you configuring the LinkedServer

begin

INSERT INTO wp4tbl_TblCompVerifySapBatch (Workorder,Docyear,movementtype,BatchNumber,Qty,MaterialNumber)

VALUES (@Workorder,@Docyear,@movementtype,@BatchNumber,@Qty,@MaterialNumber)

--...

you have an alternate of linked server to excel.

Follow this on how to create LS for excel.

http://support.microsoft.com/kb/306397

First of all my previous reply was using LS properly in query and havent looked in your where condition or table name.

Now, looking into your select query:-

SELECT TB.name,...

SELECT TB.name, TB.column

FROM [10.146.22.35].smartreports.sys.tables AS TB

WHERE TB.column = @workorder

AND TB.SCHEMA_ID = 6...

if your database have enough free space then it will not affect performance.

But if your database almost full and then you increasing the space then you will see more IO...

how will you able to run the rebuild on logshipped database?

your database will be either in standby/read-only mode or restoring mode.

1) If I have performed index rebuilding on one table in logshipped database/Primary database, will it effect the same to secondary database or do we need to again index rebuilding...