Forum Replies Created

Viewing 9 posts - 16 through 24 (of 24 total)

  • RE: Improving performance on joins to large tables

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

  • RE: Accessing a COM Local Server via sp_OACreate

    Please, tell me how?

  • RE: Open Transactions Locking Database

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

  • RE: Accessing a COM Local Server via sp_OACreate

    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?

  • RE: Using SoundEx to find similar Client Names

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

  • RE: Question about using SoundEx to find Client Name Duplication

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

  • RE: make a better query

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

  • RE: Check if a file exists ...

    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.

  • RE: Check if a file exists ...

    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

      ...

Viewing 9 posts - 16 through 24 (of 24 total)