February 10, 2009 at 1:42 pm
Grant Fritchey (2/10/2009)
Yep, Gail's right on this one too (you can usually just assume that).
:hehe:
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 10, 2009 at 1:47 pm
Bruce W Cassidy (2/10/2009)
[font="Verdana"]Gotcha. I did a little subsidiary reading on Books Online, and you're quite right -- cached query plans don't apply for views.[/font]
May I very politely and with the greatest respect suggest that it may be a better plan to read first and post second? 😉
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 10, 2009 at 1:52 pm
GilaMonster (2/10/2009)
May I very politely and with the greatest respect suggest that it may be a better plan to read first and post second? 😉
[font="Verdana"]Fair comment. Shamefaced[/font]
February 10, 2009 at 1:53 pm
Bruce W Cassidy (2/10/2009)[font="Verdana"]
Fair comment. Shamefaced[/font]
No worries. We've all done the same thing on occasion.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 10, 2009 at 2:58 pm
Thank guys for the explanation....I did learned a lot from it.
February 11, 2009 at 10:19 am
Its also depends on where you want to use this!! if it in the application then i would recomed to use View.
Thanks -- Vijaya Kadiyala
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply