Thanks alot for all of you.

I will try this script posted by jason and surely will let you ppl know....

Thanks again 🙂

Thanks for quick reply

Actually I am not looking for any tool....

I am looking...using SQL job, proc etc ?

Datalength works fine...but this is the last option...

and also I am curious to know that why len is not returning same result...

Thanks for your reply....

I agree with you ppl but can you give me some scenarios or link where I can understand it more deeply...

Thanks for your reply....

I will check the link and let you know

Thanks a lot for all your suggestions...

I will definetly compare the performance....but before starting I need some expert comments thts why I posted it 🙂

I am really looking for some...

Thanks for your reply....

I am not very happy to use DTA...

Can you ppl suggest me some other tools or third party tool to check the performance

If I will add stats in database is there any disadvantage of that....like if we add indexes...it takes space....it slowing the insertion..... etc

what are advantage of it ?

Thanks both of you for ur reply I will test them thoughroly in dev env....then only I will move...thnx again

Thanks for reply....

which is the best version of SQL Server 2005 to be installed in Windows Vista machine....It is for developer prospective...basically we were trying to install Enterprise edition but...

Ton of thanks to all of you for your replies.....

Thanks for your suggestions....

Can you people provide me some refernce...

It is also great if somebody give lights on cube

That means if I have some hash join or something in the view....it will store those intermediate result into tempdb......

Thanks for your reply

Did you mean there is no impact on cache but execution plan will be recreated.

Thanks for your reply.

We have snashot replication we are dropping all tables,views,stored procedures,functions,indexes,foreign keys etc and recreating them. Will they impact in any way to cache and execution plan.