Forum Replies Created

Viewing 15 posts - 331 through 345 (of 1,114 total)

  • RE: NOT EXISTS vs NOT IN

    Chris,

    After creating the below index to the temp table, the query took 2 seconds only.

    create nonclustered index id1 on #symb_map(sec_id,symbol)

    Thanks for your help!

    Thanks to all!

  • RE: NOT EXISTS vs NOT IN

    create proc p1_t

    as

    begin

    select a.sec_id, b.symbol, b.prtf_id, c.p_id,a.flag into #symb_map

    from funds a, Mapping b, p_identifier c

    where a.sec_id = b.symbol

    and...

  • RE: NOT EXISTS vs NOT IN

    I have executed the scirpt seperately.

    It took 1 second only.

    I put that statement in a procedure, it took 6 seconds.

  • RE: NOT EXISTS vs NOT IN

    Thanks Chris and sqlmaster!

    I am facing a starnge problem while executing the below query. if i execute it seperate it took just 1 second to complete the execution. If i...

  • RE: NOT EXISTS vs NOT IN

    NOT IN:

    Select sec_id, symbol

    from fund

    where symbol not in ( select symbol from exception where err_cd in (20,30))

    NOT EXISTS:

    Select sec_id,symbol

    from fund f

    where not exists ( select * from exception e where...

  • RE: NOT EXISTS vs NOT IN

    Ramesh,

    i used exactly the same query.

    Due to security reason,Here i posted sample table and records.

    But the scenario which i posted is my requirement.

  • RE: Counting the locks held by a procedure

    Any inputs?

  • RE: PhD in Computer Science

    Sorry! A little late here.

    Thanks for all your feedback!

    I would like to do some research about 'OPTIMIZER'. But frankly speaking i haven't decided what to do and the other...

  • RE: Counting the locks held by a procedure

    Sergiy,

    Procedures don't hold locks.

    you mean the above statements within the procedure wont hold locks ?

    I think i have phrased my question wrongly, may be if i ask like locks...

  • RE: What are the Party Plans?

    I don't know if I am considered a regular or not. I am on the site daily.

    I'd be honored and proud if you'd like to send one my way!

  • RE: Sql Server vs Sql server

    I think i should turn on

    set statistics io on

    &

    set statistics time on

    right ?

  • RE: Sql Server vs Sql server

    Now i got access to both the server.

    how should i check the disk speed ?

    how should i look CPU speed ? ( from Task manager window ? )

  • RE: Select from String

    SELECT CHARINDEX( 'Funder', routingheader ),

    CHARINDEX( 'Industry', routingheader...

  • RE: Sql Server vs Sql server

    Thanks Gila,

    I forgot to ask....

    what do you mean by Hard disk speed and CPU speed ? is there any difference between them ?

  • RE: Sql Server vs Sql server

    Gila,

    what do you mean by database activity ?

Viewing 15 posts - 331 through 345 (of 1,114 total)