Search results matching tags 'SQL Server 2008' and 'SP1'

More Cumulative Updates available for SQL Server 2008

AaronBertrand — Wed, 22 Jul 2009 05:04:00 GMT

Looks like dozens of fixes for SQL Server 2008 have made their way into another cumulative rollup; CU3 for SP1 (build 2723), and CU6 for RTM (build 1812). You can get them here:

Cumulative Update 3 for SP1:
http://support.microsoft.com/kb/971491

Cumulative Update 6 for RTM:
http://support.microsoft.com/kb/971490

So what are the main differences? While I won't pretend (like I did last time) that some of the "missing" fixes from a build weren't already in there from a prior cumulative update, and I also won't pretend that I would be motivated in any way to painstakingly go and track them all down, there definitely seem to be some fixes that only made it into one of these builds, and only a handful that made it into both.

KB Article	CU6 for RTM 10.00.1812 KB #971490	CU3 for SP1 10.00.2723 KB #971491	Both
KB #948567	yes	-	-
KB #956574	yes	-	-
KB #967315	yes	-	-
KB #967522	-	yes	-
KB #967552	-	yes	-
KB #968722	yes	-	-
KB #968740	-	yes	-
KB #968741	-	yes	-
KB #968742	-	yes	-
KB #968834	yes	-	-
KB #969050	yes	yes	yes
KB #969357	-	yes	-
KB #969467	-	yes	-
KB #969528	yes	yes	yes
KB #969611	-	yes	-
KB #969793	-	yes	-
KB #969844	yes	yes	yes
KB #969997	-	yes	-
KB #970014	yes	-	-
KB #970044	yes	-	-
KB #970058	yes	yes	yes
KB #970133	yes	-	-
KB #970150	-	yes	-
KB #970160	-	yes	-
KB #970198	yes	-	-
KB #970287	-	yes	-
KB #970399	-	yes	-
KB #970507	-	yes	-
KB #970538	-	yes	-
KB #970551	yes	yes	yes
KB #970666	-	yes	-
KB #970713	yes	yes	yes
KB #970823	yes	yes	yes
KB #970909	yes	yes	yes
KB #970966	yes	yes	yes
KB #971049	-	yes	-
KB #971051	-	yes	-
KB #971057	-	yes	-
KB #971064	-	yes	-
KB #971068	-	yes	-
KB #971132	-	yes	-
KB #971136	yes	yes	yes
KB #971402	yes	yes	yes
KB #971640	-	yes	-
KB #971772	-	yes	-
KB #971780	yes	-	-
KB #971914	yes	-	-
KB #971985	-	yes	-
KB #972068	-	yes	-
KB #972197	-	yes	-
KB #972198	-	yes	-
KB #972200	-	yes	-
KB #972201	-	yes	-
KB #972203	-	yes	-
KB #972207	-	yes	-
KB #972261	-	yes	-
KB #972440	-	yes	-
KB #972521	-	yes	-
KB #972650	yes	-	-
KB #972681	yes	yes	yes
KB #972759	-	yes	-
KB #972763	-	yes	-
KB #972767	yes	yes	yes
KB #972777	-	yes	-
KB #972984	-	yes	-
KB #973200	-	yes	-
KB #973204	yes	-	-
KB #973250	-	yes	-
KB #973257	-	yes	-
KB #973301	yes	yes	yes
KB #973302	yes	-	-

SQL Server 2008 SP1 Cumulative Update 2 is available!

AaronBertrand — Tue, 19 May 2009 14:17:00 GMT

Most importantly, this update includes the new trace flag that will allow users running Standard Edition to enable Locked Pages in Memory. This is a huge win for a lot of customers out there. You can read about this specific enhancement in this blog post by Bob Ward:

http://blogs.msdn.com/psssql/archive/2009/05/19/an-update-for-standard-sku-support-for-locked-pages.aspx

There are some other important updates in this CU as well (at least IMHO), including updates that fix "could not produce a query plan" errors (see KB #961106), as well as two big "incorrect query results" bugs when running parallel queries (see KB #968449) and when using the ROW_NUMBER() function (see KB #970198). Note that some of the individual KBs may reference Cumulative Update 5 for SQL Server 2008 instead of / in addition to CU2 for SP1; obviously you should not download CU5 if you are running Service Pack 1. Also note that you can't get the Locked Pages in Memory fix if you stay on the RTM track instead of moving up to SP1.

You can request the hotfix (and read about the other fixes included) in the following KB article:

http://support.microsoft.com/kb/970315

However, currently, the support site is timing out for me, which is a first. I think Denis Gobo might be taking all of Microsoft's bandwidth!

SQL Server 2008 SP1 Cumulative Update 1 is available!

AaronBertrand — Thu, 16 Apr 2009 00:52:00 GMT

If you were among those who installed CU4 for SQL Server 2008, then installed SP1, you may not know that you lost some of the fixes that came with CU4 (see Bob Ward's post which is slightly more informative than the release notes).

Microsoft today released a post-SP1 cumulative update that adds back all of these fixes. There is nothing else included, so there is no reason to install this CU if you are at SP1 and got there from RTM or one of the CUs. There is always some confusion about the servicing model and what to do when the cumulative update and service pack schedules collide. Here is a summary in this case (the most important one being the first item):

If you are currently on SP1 (2531), and upgraded from any build <= 1787, do nothing.
If you are currently on SP1 (2531), and upgraded from any build > 1787 and < 2520, apply SP1 CU1 (2710).
If you are currently on the SP1 CTP (2520), apply SP1 (2531).
If you are currently on CU4 (1798), or any interim build > 1787 and < 2520, you should install SP1 (2531) and then SP1 CU1 (2710).
If you are currently on RTM (1600), CU1 (1763), CU2 (1779), CU3 (1787), or any other build < 1787, you should install SP1 (2531).
If you are not sure which bullet applies to you, please ask!

How do you tell what build you upgraded from? Well, hopefully you remember; if not, you should be able to tell from the most recent set of setup log files in "%Program Files%\Microsoft SQL Server\100\Setup Bootstrap\Log\" ... the file summary.txt has a section called "Product features discovered" and you should be able to find the instance(s) you patched last time, and the version will be listed under the section "Database Engine Services."

You can download the new CU here:

http://support.microsoft.com/kb/969099

And from there you will find links and descriptions of the list of fixes.

If you're still confused about the SQL Server servicing model, don't worry, you're not alone. Browse Bob Ward's blog starting with the link provided above, and also see KB #935897.

I talked about Resource Governor (again)

AaronBertrand — Fri, 10 Apr 2009 13:10:00 GMT

Last night I gave my Resource Governor spiel at the New England SQL Server User Group meeting in Waltham, MA. About 60 people were in attendance. Unlike the last few times I've presented this technology to an audience (because friends and co-workers don't count), there seemed to be much more genuine interest... I think this has largely to do with the fact that Service Pack 1 is now available, and the light at the end of the tunnel is a lot more visible to some fellow DBAs. There were lots of good questions; for most I had the answers, for a few I did not. I always fear that I will do horribly in front of a crowd, and it usually turns out better than I had feared. This was one of those occasions. :-)

For those looking for the slides from the presentation, they are below, in PDF format. If you want the PowerPoint slides to re-use for your own presentations, they are a moving target - so please get in touch with me directly (aaron [dot] bertrand @ gmail).

After the talk, I was asked to give it again at the CT DOT NET Developers Group in Farmington, CT. It's a bit of a hike for me but I will probably opt in.

SQL Server 2008 Service Pack 1 is now available!

AaronBertrand — Wed, 08 Apr 2009 01:11:00 GMT

No, this is not a late April Fool's joke; SQL Server 2008 Service Pack 1 is finally gold. The final release of SP1 is build 10.00.2531.00, and is available from the Microsoft Download Center:

http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19

Cumulative Updates 1, 2 and 3 are included in this service pack, as well as important fixes found during the CTP process. As with the CTP, the most exciting feature here (IMHO, anyway) is the new slipstream functionality.

SQL Server 2008 Cumulative Update 4 is available

AaronBertrand — Tue, 17 Mar 2009 14:28:00 GMT

If you are running SQL Server 2008 and haven't yet installed the SP1 CTP, you may want to check out Cumulative Update 4 (build 1798) in KB #963036. You obviously won't be able to install the hotfix if you already have the SP1 CTP, even though the new cumulative update contains some fixes that aren't in SP1 (and won't be when it is released).

When I initially downloaded these files, they were about 200K and, just as rumknight commented, had this error message when trying to extract:

I sent a note on to Microsoft right away, and while I have not received a response, in the meantime I tried to download using Google Chrome, and it seems to be getting the correct files this time (don't laugh at my slow download speed, I am doing this inside a VM whose host is connected to a slow work VPN):

So I'm not sure if they've fixed the downloads and IE is still stuck on a cached version of the files, or if Chrome really is better at handling downloads, but it might be worth trying if you are still getting the incorrect files in IE.

SQL Server 2008 SP1 setup is a little confused

AaronBertrand — Thu, 26 Feb 2009 19:23:00 GMT

Of course, it is always annoying when we have to restart a machine or stop a service to service software. I get annoyed when little updates to non-integral pieces of Windows prompt me to reboot; leave me alone and force me to reboot when you actually need those files. Or be smarter about "in-place replace" (if that concept makes sense). I understand the "in use" problem, but have we not made any strides in overcoming this in the past 20+ years of Windows? This is not exclusive to this platform; my Macs need to reboot after updating iTunes or Word, which I can't fathom either.

Anyway, I am straying. The other day I announced here that the CTP for SQL Server SP1 was available. Well, I have installed it on a half dozen machines, and have come across a few minor issues in the tools (mostly around state / registered server names in Object Explorer). But there was a change in setup that I think is going to create confusion all over the place. Basically on a single dialog it says two things:

1) you will need to stop service x to avoid a restart; and,

2) you will not need to stop service x to avoid a restart.

Don't believe me? Here it is in black and white (and blue, and red, and a few other colors, as RDP and a crappy video card on the other end will allow):

Being a "glass is half full" guy for the most part, I believed 2) and, after waiting 47 minutes (yes, 47 MINUTES, I timed it!) for setup to finish, was elated to find that I did not, in fact, have to reboot. Yay! But the text on the dialog needs to be updated. I complained about this on Connect, but I doubt this will meet the bar for a fix:

http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=418470

SQL Server 2008 Service Pack 1 : CTP is available!

AaronBertrand — Tue, 24 Feb 2009 14:20:00 GMT

Yes, you read that right; for those of you waiting to try SQL Server 2008 until SP1 is available, we are one step closer. You can download the CTP from the following URL:

http://microsoft.com/downloads/details.aspx?FamilyID=6f26fc45-f0ca-49cf-a6ee-840c7e8bb8af

The CTP will bring your instance to build # 10.00.2520.

Thumbs up on finally adding slipstream capability and the ability to uninstall the service pack without uninstalling the instance.

Thumbs down on creating a CHM help file that is mostly legalese and requires a self-extracting exe wrapper to extract one file.

There is also an Express version available:

http://microsoft.com/downloads/details.aspx?FamilyID=0f8df01e-b05b-401b-87e7-bc516683cfe0

You can read more about the release at the Release Services blog:

http://blogs.msdn.com/sqlreleaseservices/archive/2009/02/23/sql-server-2008-service-pack-1-sp1-ctp.aspx

Visual Studio 2008 SP1 (RTM) is now available [UPDATE]

AaronBertrand — Mon, 11 Aug 2008 17:02:00 GMT

Now that you can get Visual Studio 2008 SP1 RTM, you probably want to rush out and install it. I would hold off on that until you read Bob Ward's blog entry, which explains the situation, and should help clear up some confusion on whether you need to install anything:

SQL Server 2008, Visual Studio 2008 SP1, and .Net Framework 3.5 SP1 explained....

For those that are really in a hurry, you can get the core download here (this is the base installer which will download the files you need at runtime, based on operating system, edition, etc.):

http://www.microsoft.com/downloads/details.aspx?FamilyId=FBEE1648-7106-44A7-9649-6D9F6D58056E

And as Joe points out, if you want the whole download (800+ MB), you can get that here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=27673C47-B3B5-4C67-BD99-84E525B5CE61