Viewing 15 posts - 331 through 345 (of 1,114 total)
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!
February 18, 2009 at 4:45 am
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...
February 18, 2009 at 4:23 am
I have executed the scirpt seperately.
It took 1 second only.
I put that statement in a procedure, it took 6 seconds.
February 18, 2009 at 3:35 am
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...
February 17, 2009 at 10:10 pm
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...
February 17, 2009 at 4:13 am
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.
February 17, 2009 at 2:25 am
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...
February 12, 2009 at 7:08 am
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...
February 12, 2009 at 1:53 am
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!
February 2, 2009 at 9:23 am
I think i should turn on
set statistics io on
&
set statistics time on
right ?
January 16, 2009 at 12:27 am
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 ? )
January 16, 2009 at 12:25 am
SELECT CHARINDEX( 'Funder', routingheader ),
CHARINDEX( 'Industry', routingheader...
January 15, 2009 at 7:22 am
Thanks Gila,
I forgot to ask....
what do you mean by Hard disk speed and CPU speed ? is there any difference between them ?
January 13, 2009 at 1:09 am
Gila,
what do you mean by database activity ?
January 13, 2009 at 1:00 am
Viewing 15 posts - 331 through 345 (of 1,114 total)