Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

SQL Server 2008 Query Optimization - Part IV

Loading...

Sign in or sign up now!
17,318
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Oct 22, 2008

http://www.learningsqlserver2008.com/

In this last part on query optimization, we cover using EXISTS clause instead of IN clause. This is especially useful when using sub queries in your code. Next we show you how to use SET NOCOUNT ON to increase query performance. We also show you the query comparison in SQL Profiler. Using stored procedure we measure the query statistics.

Visit our other sites:

http://www.learningcomputer.com/
http://www.learningsqlserver2008.com/
http://www.sqlazuretutorials.com/
http://www.sqlserver2008tutorial.com/
http://compare-insurance-car.com/compare-car-insurance.html
http://www.mycar-insurance.net/
http://datatechnologyllc.com/search-engine-optimization/Dallas-SEO.html

  • likes, 2 dislikes

Link to this comment:

Share to:

Uploader Comments (baghul)

  • Are there Part I,II III for this ?

  • @miamikk Yes there are, plz visit the site listed under the video. Thanks

  • Thank-you.

  • @iandashb You are welcome!

Video Responses

This video is a response to SQL Server 2008 tutorial - What is MS SQL?
see all

All Comments (4)

Sign In or Sign Up now to post a comment!
Loading...

0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more