THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » books online   (RSS)
Showing page 1 of 2 (16 total posts)
  • Yes, you can install SQL Server 2014 Books Online locally

    I've seen people complain that SQL Server 2014 did not ship with documentation you could install locally. While true, it is just because the publication lagged; the local Books Online option is available now. First, make sure you have the documentation components installed. (Note that these use the old, icky, Help Viewer 1.0/1.1 - if you'd like ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 23, 2014
  • Differences in documentation for sys.dm_exec_requests

    I've already complained about this on Connect (see #641790), but I just wanted to point out that if you're trying to make sense of the sys.dm_exec_requests document and what it lists as the commands supported by the percent_complete column, you should check which version of the documentation you're reading.  I noticed the following ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 7, 2011
  • What permissions are required for SET IDENTITY_INSERT ON?

    SQL Server 2000's SET IDENTITY_INSERT ON topic says: Execute permissions default to the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and the object owner. While the SET IDENTITY_INSERT topic for SQL Server 2005 (and up) says: User must own the object, or be a member ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 14, 2010
  • SQL Server v.Next (Denali) : Books Online

    There are posts elsewhere that go through the whole rigamarole (for example, this post from Don Gill, SQL Server's Group Content Publishing Manager).  I just wanted to highlight the key bullet points: if you want to use Books Online locally, you will need to: install Books Online from Denali setup. Note that Management Studio is now ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 13, 2010
  • Bad habits to kick : using ancient copies of Books Online

    In my last post in this series, I talked about inconsistent table aliasing.  Today I was reminded of another behavior that DBAs and developers alike can be lazy about: keeping Books Online current. There are always going to be mistakes in any set of documentation, and this is especially true with the scope of SQL Server Books Online.  ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 22, 2010
  • Connect Digest : 2010-01-11

    Control over procedure cache We are still waiting for more control over procedure cache.  Adam Machanic wrote up this blog post highlighting a Connect item which he opened in 2007.  It is currently closed as ''won't fix'' but it's been shown time and time again that in some cases we need this extra knob. #293188 : Amount of RAM for ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 11, 2010
  • Connect digest : 2009-08-09

    Sorry, I've been trying to keep this to a regular Saturday installment, but it was a beautiful weekend here and I just couldn't pass up on non-computer-related activities.  I have a short list of Connect items to draw your attention to this week. =============================================== Setup messes with authentication mode I was ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 9, 2009
  • How to convert Books Online ms-help: links to MSDN Library http: links [bookmarklet included]

    As you know, Books Online is available in two convenient locations. It's online as part of the MSDN Library, and it's offline as a Document Explorer help collection. Topics are accessible by URIs in each, but the URIs don't match. For example: Books Online Topic: CREATE STATISTICS (Transact-SQL) Document Explorer URI: ...
    Posted to Steve Kass (Weblog) by skass on August 4, 2009
  • SQL Server 2008 Books Online update is available

    Well, let me be more precise: there is an updated version of Books Online online.  As reported earlier by Buck Woody, the online version of SQL Server 2008 Books Online has been updated (we are seeing the updates now but the content was refreshed June 29th).  The download has not been made available as of yet; this usually takes several ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 7, 2009
  • More info on the May 2009 update to SQL Server 2008 Books Online

    I finally got around to installing this update today, and thought I would mention a few things. Don't be surprised that ''Books Online (May 2009)'' actually says ''April 2009'' in the application's title bar and on any page which states the version.  (I already received one private message asking me why they got the April version instead ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 22, 2009
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement