Sometimes you may find that when you are in the SQL Management Studio or creating SQL queries that when you select Help your machine may seemingly take a long time to initialize the Help system or the searches take an inordinate amount of time to load and compete. In SQL 2005 this is not a reflection on the performance of SQL or your local machine it is usually the internet connectivity that is seemingly slowing you down and causing your coffee to turn cold in its pretty pale Styrofoam cup.
By default when you first run the SQL Books On Line (BOL) you choose how you want the help system to behave and therefore load. If you are like me and you were in a hurry to simply get on with it you choose the first option that is pre-selected which is online first. This causes the system to seem slow in responding because the internet has to find the page then load the page and finally perform its search and return the results to you.
Because the default load order for BOL is Online first and then use the local help system therein usually lies the problem. To change the BOL load order open your BOL and from the “Tools” menu select “Options”. Then select Help and click “OnLine”. At the “When loading help content” select the second radio button which reads “Try local first, then online” and select OK.
Note: You can also set the search providers order options or remove them as well by unchecking the appropriate boxes. You can also select the Codezone community links to use or remove them as well.
No Comments