thanks............now please see this also

please run thi script....

set statistics profile on

exec sp_helpserver

set statistics profile off

And explain following terms...how they should be analyzed?

--PhysicalOp

--logicalOp

--estimatedIO

--EstimateCPU

--AvgRowSize

Hi Grasshoper,

Really your reply is APPRECIATED...

can you look into my issuse on below link

http://www.sqlservercentral.com/Forums/Topic555531-146-1.aspx

hi,

here is your solution....

Declare your VAL1 column with varchar datatype ypu will get your solution....

In your case ity is showing 0 instead of 000 because as integer 000...

Thanks..........:):):)

what exactly you want to do ??

please explain it in the context of below written script

create table #Like_Test( Col1 varchar(5) )

go

insert #Like_Test values('_Cus')

insert #Like_Test values('Cus_')

insert #Like_Test values('C_us')

insert #Like_Test values('Cus')

insert #Like_Test values('Cu_s')

GO

select * from #Like_Test where...

can anyone tell how " _" is being treated in LIKE keyword. ??

1.add indexes on columns which are used by where clause....

its better to create indexes on other filegroup the n data filegroup.

2..check union or joins in your query..

if your...

hey ...how did it happen ? my question became QUESTION OF THE DAY..but without my name

? :unsure::unsure:

ok i wont ....then do you have any other alternative other than TEMP table for CURSOR:discuss:

do u still need alternative of CURSORS ???

Hi,

Actually DDl trigger use a function EVENTDATA. when ever DDL is get fired the script of that altered table(in your case ) is stored in its properties...

Hi,

Actually whenever we resotr the master database into server ,it always refers/look the default location od master's ldf anf mdf files...so please make sure that your mdf and...

Now can i expect an answer from ..............experts......???

GLAD TO KNOW THAT YOUR PROBLEM HAS BEEN SOLVED BUT

MY NAME IS NOT JENNY

I AM BHUVNESH:)