I have nice idea for you too...

Just read the DBA books and applies in your Own Server DB 1st...

check for pros..n cons...come up with new solutions and ideas........

Then you can...

Sandy (:P),

I have a nice query for you for DB performance. Given Below...

but I am facing one problem..after running this query my DB Log file is increasing each time I...

Hi Sandy & bcronce,

I am clear now on my topic. I hope I got my answer from Gail and Sandy.

Sandy...I Like you..:)

Thanks a lot Bcronce for nice explanation..

Luvs,

Milu.:)

Thanks you all,

A hearty thanks to Gail for saying me correct way,

luvs

Milu.:)

gail again i got confused ....

clear me now..what u said just now..

luvs

milu

Gail,

Can you please Explain with a situation where you wants to use the table variable and temp table..

I need a complete answer please so i can use as per this....

Luvs,

Milu.:)

bcronce,

Can you please clear me what you are trying to say??

luvs,

Milu.:)

Hi Sandy & Gail,

I got so many new concepts from both of your post..thanks you a lot to both of you. but still i am in dark on my topic..what...

Hi All, (Gail, Sandy, rbarryyoung)

Thanks you all for your valuable inputs regarding the Index on Temp table and Table variable Concepts.

Now I need to see Sandy's Reply for Gails Post.

also...

Gila,

If i am not wrong, you can't creat an index in Table variable...rite explicitly...rite??

then wht u will do now??/

if table is highle highly transactional..then whould u go for Temp table...

Guys, Apology for late reply...

Let me go through each and individual comments for more details and better understanding..

Steve:

--------------------------------------------------------------

That's a gross generalization, but without more information about what you actually...

Thanks,

I will go through this..

Thanks.

milu.:)

hii.. All,

Thanks to all who guide me & clear my concepts...and thanks to them also who added additional point to this topic....

Special thanks to Sandy too, who gives me a...

GSquared, ...

rbarryyoung code was correct, when i copied it got changed.....Sorry for that....:)

As you told..

You'll get an error from that, because the CTE only works for the first one,...

I need the advantage rather than small small use..of CTE....

and I need the script wise compare....I mean to say where VIEW fails that can be possible by CTE..

I need practical...