THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » x64   (RSS)
  • The Myth Around 32-bit SQL Server Instances on 64-bit Operating Systems, and AWE

    (I’m taking a break from my DBA Best Practices blog series to talk about this today – the series continues after the Holidays!) I love to be proved wrong. Really, I do. Recently we had a discussion in an distribution list where somebody asked whether a SQL Server 32-bit instance could address more than 4Gb of RAM when running on top of a 64-bit ...
    Posted to Argenis Fernandez (Weblog) by Argenis on December 30, 2012
  • Upgrading to SQL Server 2012 with Lock Pages in Memory

    During SQL Server 2012 RC0 setup (specifically when upgrading), you may have noticed upgrade rules regarding Lock Pages in Memory (LPIM): However, for most folks, these rules always pass, whether or not they are actually using LPIM. I wanted to run a few tests to demonstrate why this is - or at least in which situations the rule checks will ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 6, 2012
  • SQL Server v.Next (Denali) : OS compatibility & upgrade support

    Microsoft's Manageability PPM Dan Jones has asked for our feedback on their proposed list of supported operating systems and upgrade paths for the next version of SQL Server. (See the original post). This has generated all kinds of spirited debates on twitter, in protected mailing lists, and in private e-mail. If you're going to be involved in ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on June 13, 2011
  • SQL Server 2008 R2 still requires a trace flag for Lock Pages in Memory

    Almost two years ago, I blogged that Lock Pages in Memory was finally available to Standard Edition customers (Enterprise Edition customers had long been deemed smart enough to not abuse this feature).  In addition to applying a cumulative update (2005 SP3 CU4 or 2008 SP1 CU2), in order to take advantage of LPIM, you also had to enable trace ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 7, 2011
  • Using a Mac in a Windows world

    As a ''SQL Server guy'' first and foremost, I often have to defend my use of a Mac both as a travel and presentation laptop, and as my primary development workstation.  Today over on my work-related blog, I penned a story explaining my experiences, why I chose to switch platforms for much of my work, and what kind of problems this has caused ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 30, 2009
  • Cisco VPN Client and Vista x64

    I am disappointed in Cisco. I have Vista Ultimate x64 installed on my snappy new Red laptop but I cannot install Cisco VPN Client software on it because Cisco VPN Client does not run on Vista 64-bit platforms. Digging around for a work-around, I came across a couple interesting comments. One comment, from someone who claims to be with Cisco ...
    Posted to Andy Leonard (Weblog) by andyleonard on May 9, 2008
Privacy Statement