I have mater and child tables. Mater table has primary key and detail table has index on detail field. Detail table is large.

select *

 from mdan m

 left join all_rlists r

 on...

Please, tell me how?

What is isolation level of your transaction and what resources it locking?

if

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

go

begin tran

insert into dbo.LSKLADI values(0,0,0,'qwe','qwe')

WAITFOR DELAY '00:00:20:000'

rollback tran

than in other connections I can't...

Hi.

I do not professional in that, but have to aks you.

How you invoke sp_OACreate? Did you use context argument? Maybe you have to use it with value 4 only?

I has done a SQL routing that tries to capture Malyutin Slava and Malyutin Salava. Within it I can set a number of errors. That script is not small. If...

I has done a SQL routing that tries to capture Malyutin Slava and Malyutin Salava. That is my name (mSlava). But russian name has third-part, therefore it routing tries to...

Hi.

If ProductNumber is primary key column, Query Optimizer using Merge Join algorithm. There is no something better I think.

Probably, better is using 3 columns in application dataset like:

rs.Open "Select * from...

Sorry for English.

Yes, It is great. But I don't understand when that OLE Object is installed. Probably with Win. If you know it, please tell me.

Not all declared will be used!

DECLARE @object int

DECLARE @hr int

DECLARE @property varchar(255)

DECLARE @return varchar(255)

DECLARE @src varchar(255), @desc varchar(255)

-- Create an object.

EXEC @hr = sp_OACreate 'Scripting.FileSystemObject', @object OUT

IF @hr <> 0

BEGIN

  ...