will it be any performance issue if i shrink log file?

Thanks Arun,

Here we are storing record everytime....

May be 2000 requests within 2 or 3 seconds...

Thank u guys.....:)

Hi Lynn..

Will it be extra overhead if I create indexes on temporary tables..??

As that procedure will be frequently used ..... Temporary table will be created and deleted,. Indexes will get...

In our procedure we are returning a record set which is made up of multiple queries.

I am fetching rows using seperate queries..

Here is small example......

here I am using one table...

Thanks Gail............:-)

Thanks for ur reply..

Hi Gail,

If I execute the same query in some good server, then will table scans get reduced..?

Its become bit faster after adding index..

plz find the attached file..

No. .. its not possible to have multiple null's for a column which is having unique constriant...

create table temp

(

id int unique

)

insert into temp

values (1)

insert into temp

values (null)

insert into temp

values (null)

drop...

Thank you guys.....

As per the table structure there are only two columns

QuestionID BIGINT (Primary key)

QuestionXML NTEXT

Will it be a problem if the datatype is NTEXT...

And also we wil store XML which...

Thanks Dwierenga

Arun....

Ur logic works only in the case of alphanumeric values... I throws error in case of string

The error is

------

Msg 245, Level 16, State 1, Line 17

Conversion failed when converting...

Thanks Arun....

Your code works fine.........

I will implement this in my procedure....:-P

Thanks Pawan... its working......:-D