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 » SQL Server 2005   (RSS)
Showing page 2 of 4 (31 total posts)
  • Installing Service Packs / Cumulative Updates on a SQL 2005 cluster

    In our environment, we run the task scheduler as a cluster resource, so that scheduled tasks always run on the active node.  (In ancient history, we would have scheduled tasks that weren't cluster aware - in the event of a failover, we'd have to manually disable task scheduler on the now passive node, and manually enable it on the active ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 20, 2009
  • New Cumulative Updates for SQL Server 2005 SP2 / SP3

    Some new updates just posted by SQL Server Release Services: For SQL Server 2005 SP2, build 9.0.3355: For SQL Server 2005 SP3, build 9.00.4266: On first glance, it does not appear that the security updates last week were included in the hotfix for SP2.  (See ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 20, 2009
  • New cumulative updates available for SQL Server 2005 SP2/SP3

    Sleeping at the wheel again, I missed some big updates for SQL Server 2005 this past Monday. Cumulative Update #5 for SP3 brings you up to 9.00.4230 (the previous update was 9.00.4226). Cumulative Update #15 for SP2 brings you up to 9.00.3330 (the previous update was 9.00.3328). ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 19, 2009
  • SQL Server 2005 SP3 Cumulative Update 4 is available

    Microsoft quietly released another cumulative update for SQL Server 2005 Service Pack 3 this week.  So quietly, in fact, that it took me 5 days to notice.  As Chad Miller noted in his comment, this is the first build of SQL Server 2005 that supports the ''lock pages in memory'' setting on Standard Edition.  You can read about the ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on June 20, 2009
  • UPDATE : SQL Server 2005 SP3 Cumulative Update 3 is available

    It seems this came out on April 20th, but I did not catch it at the time.  Better late than never, I guess.  As Sean Nolan pointed out in a previous post, CU#3 includes many of the fixes that were available in SP2 CU#13 and not in SP3 CU#2.  You can download the hotfix (which puts you to 9.0.4220) ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 14, 2009
  • Big News : Lock Pages in Memory for Standard Edition

    After much feedback from customers (and some loud feedback from MVPs, led primarily by Maciej Pilecki), Microsoft's Bob Ward just announced at the European PASS Conference that they are going to allow the 'lock pages in memory' privilege for all the lowly peons running Standard Edition.  Currently this has only been allowed on Enterprise ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 24, 2009
  • SQL Server 2005 SP3 through Microsoft Update now supports clusters

    What this says to me is, if any of your clusters have automatic updating turned on, you might get SP3 as a surprise.  Since the blog post states that it must be run in attended / UI mode, maybe that is not quite true (it will probably download but not install), but I would check on your clusters just in case.  It doesn't sound cut and ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 25, 2009
  • Six reasons you should be nervous about parallelism

    Don't get me wrong; parallel processing is great.  And with SQL Server in particular, there are many benefits to taking advantage of the power of multiple CPUs.  However, we have all had cases where what looked like parallelism was actually hurting us (you remember turning off hyperthreading on SQL Server boxes, right?), and cases ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 21, 2009
  • SQLBits 2009

    This the second time in a row I will not able to attend to SQLBits - but don't lose this event if you can go to Manchester on March 28th, 2009. The conference is free, but registration is required. A training day (with a reasonable fee) is also scheduled the day before. I hope to attend the next one... The reason I cannot go is mainly because a ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 23, 2009
  • SQL Server 2005 : Comparing SP2 CU#12 and SP3 CU#2

    The recent release of security fixes for SQL Server 2000 and 2005 (the issue did not impact SQL Server 2008) announced in MS09-004 seemed to spur two SQL Server 2005 cumulative updates (CUs) earlier this week -- one for those on SP2, and one for those on SP3.  (This typically happens when there is a new service pack released, as adoption ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 20, 2009
Privacy Statement