There's probably one other thing that you could do. If you need asyncronous access to the same tables that are being processed so other users can still query them, the queries that are not doing the reconciliation should be specified with nolock. ie select * from table1 with (nolock) hth
2003-06-06
1 reads
Databaes has to be in full recovery mode for logshipping to function.
2003-06-05
1 reads
Thanks rbrow112, I just could not remember yesterday. Know it was quit uneventfull. Thanks!
2003-06-05
2003-06-05
Guess what.. I tried inserting one row to the oracle table from QA, it is taking 7 mts. Is MSDTC service really slow in handling orcle transactions?
2003-06-05
I did not see any login info (but I didn't know what I was looking for) I ran the asp in a dts package and it worked It had the same connectionstring and ado code. I also double checked I Have both SQL and Windows authentication. I think there has to be some sort of […]
2003-06-05
Thanks for your help every one, I have applied what you all wrote and it seems to be working. Just one more question: I was using SQL Profiler based on a workload that I gave it. The indexes that it had put in there were different than what really are making the difference. Is there […]
2003-06-05
1 reads
Ive used the following to retrieve the table name; declare @TbleName nvarchar(324) SET @TbleName=(Select name from sysobjects where sysobjects.id = (select parent_obj from sysobjects where sysobjects.id =@@PROCID)) Of course then what you do with the @TblName value is up to you, throw it into a table somewhere, or a variable for later use. Rick Brown
2003-06-05
Hi BillyWilly, quote: However, My current system runs like the wind and can calculate and serve formatted HTML for 20 funds, 9 time series(Daily, Week To date, Month to date...), for a five year period in under a second - no problems there. have you ever considered a marketing or sales job So what are […]
2003-06-05
1 reads
DBCC INPUTBUFFER(spid) This only gets the first 255 characters of the command. SP3 introduced the fn_get_sql function (see the updated SP3 BOL for details), which returns the information in a text column.
2003-06-05
2 reads
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
Please, let me reiterate: The only valid test of a backup is a restore....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers