This video is part of LearnItFirst’s Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is available here: …
Great video .. an additional suggestion would be extracting execution plans using showplan and saving them in XML which would save considerable time when the host server or application server is restarted which usually flushes the cache memory where execution plans are stored .. this way you could save time on unchanged frequent queries by reusing the saved execution plan XML using useplan .. Hope that helps ..
very nicely explained…thanks.
u r one epic lecturer! forget the content, the delivery itself is the best I've heard on Youtube. Good Job!
One of the best tutorials in this topic.
gd one
Nokia lumia is awesome, with great hardware, but only battery seems to pose few problems.
Great video .. an additional suggestion would be extracting execution plans using showplan and saving them in XML which would save considerable time when the host server or application server is restarted which usually flushes the cache memory where execution plans are stored .. this way you could save time on unchanged frequent queries by reusing the saved execution plan XML using useplan .. Hope that helps ..
Good one…
Thanks Scott, nicely explained.
Very Nice! Continue making such nice and helpful videos!
Thanks Scott .. that was clear and helpful
Thank you 🙂