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 » 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
  • SSIS Snack: SSIS, Excel, and a 64-bit OS

    Let's say you want to load data from an Excel 2003 (.xls) file into a database using SSIS: If you're running on a 64-bit machine, you'll get this:   Plus this error: [PASS Regional Mentor Spreadsheet [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 19, 2010
  • SSIS 2005 on Windows 7

    Introduction I recently upgraded from Vista Ultimate (x64) to Windows 7 Ultimate (x64). So far I really like Windows 7, but I'm still in the honeymoon phase. I ran into an issue creating new packages using SSIS 2005 and found a solution I thought I'd share. The Error Unfortunately for both of us, I did not capture a screenshot of ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 28, 2009
  • 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
  • Virtualization, x64, a Red Laptop, and Blue Screens

    Introduction The day started like any other sweltering July dog day in the country between Farmville and Keysville, Va... Ok, I won't quit my day job. I scored a snappy new Dell Red XPS 1530 in early May. About a month ago I started getting blue screens - something I hadn't seen in my year and a half experience with Vista. I Can Fix ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 30, 2008
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement