Simulating TRY_PARSE in SQL Server 2008
Certainly not to encourage people to stay on ancient versions if they don't have to, I took a crack at replicating TRY_PARSE on older versions.
Category: SQL Server 2008 R2
Out-of-band hotfix releases for SQL Server 2008 SP4 and 2008 R2 SP3
Back in September, I blogged about the availability of SQL Server 2008 R2 Service Pack 3 and SQL Server 2008 Service Pack 4. I made it clear that there would be no cumulative updates after...
SQL Server 2008 R2 Service Pack 3 is available!
Microsoft has released a final service pack for SQL Server 2008 R2: Service Pack 3. The build # is 10.50.6000.34 and you can download it here. This is essentially a rollup of all of...
Security Updates Available for SQL Server 2008, 2008 R2, 2012, 2014
If you are running 2008 SP3, 2008 R2 SP2, 2012 SP1 (SP2 is not affected, RTM is no longer supported), or 2014, you'll want to check out Security Bulletin MS14-044 for details on a...
June 2014 Cumulative Update for SQL Server 2008 R2 SP2
Microsoft has released the final Cumulative Update (#13) for SQL Server 2008 R2 Service Pack 2. KB Article: KB #2967540 15 public fixes listed at time of publication (17 fixes total) Build number is...
April 2014 Cumulative Update for SQL Server 2008 R2 SP2
Microsoft has released Cumulative Update #12 for SQL Server 2008 R2 Service Pack 2. KB Article: KB #2938478 13 fixes listed at time of publication Build number is 10.50.4305 Relevant for @@VERSION 10.50.4000 through...
February 2014 Cumulative Update for SQL Server 2008 R2 SP2
Microsoft has released Cumulative Update #11 for SQL Server 2008 R2 Service Pack 2. KB Article: KB #2926028 12 fixes listed at time of publication Build number is 10.50.4302 Relevant for @@VERSION 10.50.4000 through...
December 2013 Cumulative Update for SQL Server 2008 R2 SP2
Microsoft has released Cumulative Update #10 for SQL Server 2008 R2 Service Pack 2. KB Article: KB #2908087 15 fixes listed at time of publication Build number is 10.50.4297 Relevant for @@VERSION 10.50.4000 through...
October 2013 Cumulative Update for SQL Server 2008 R2
Microsoft has released Cumulative Update #9 for SQL Server 2008 R2 Service Pack 2. KB Article: KB #2887606 17 fixes listed at time of publication Build number is 10.50.4295 Relevant for @@VERSION 10.50.4000 through...
August 2013 Cumulative Updates for SQL Server 2008 R2
UPDATE 2013-08-23: 2008 R2 SP2 CU #8 is now available; details below. UPDATE 2013-08-14: I had originally posted about SP1 CU #14, and was sure SP2 CU #8 was coming in shortly behind it,...
June 2013 Cumulative Updates for SQL Server 2008 R2
Well, surely at least partly in response to the CU6 mess I reported earlier today, and partly because they were due, Microsoft has released new cumulative updates that contain – among other things –...
Attention users running SQL Server 2008 & 2008 R2!
In April and May, Microsoft released cumulative updates for SQL Server 2008 and 2008 R2 (I blogged about them here and here). They are: CU #11 for 2008 SP3 (10.00.5840) (KB #2834048) CU #12 for...
April 2013 Cumulative Updates for SQL Server 2008 R2
Today Microsoft released new cumulative updates for SQL Server 2008 R2. SQL Server 2008 R2 Service Pack 1 Cumulative Update # 12 KB Article: KB #2828727 7 fixes listed at time of publication Build...
February 2013 Cumulative Updates for SQL Server 2008 R2
Today Microsoft released new cumulative updates for SQL Server 2008 R2. SQL Server 2008 R2 Service Pack 1 Cumulative Update # 11 KB Article: KB #2812683 4 fixes listed at time of publication Build...
December 2012 Cumulative Updates are available for SQL Server 2008 R2
Microsoft released new cumulative updates for SQL Server. SQL Server 2008 R2 Service Pack 1 Cumulative Update # 10 KB Article: KB #2783135 16 fixes are listed at the time of publication Build number...
SQL Server 2008 R2 Cumulative Updates are available
Microsoft has released cumulative updates for SQL Server 2008 R2. SQL Server 2008 R2 SP1 Cumulative Update #8 KB article is http://support.microsoft.com/kb/2723743 Build number is 10.50.2822.0 There are 20 fixes published as of 2012-08-31...
SQL Server 2008 R2 Service Pack 2 Cumulative Update #1 is available
Microsoft has released a cumulative update for SQL Server 2008 R2 SP2, which was only released last week. KB article is http://support.microsoft.com/kb/2720425 Build number is 10.50.4260.0 There are 35 fixes published as of 2012-08-01...
SQL Server 2008 R2 Service Pack 2 is available
Today Microsoft has released Service Pack 2 for SQL Server 2008 R2. http://www.microsoft.com/en-us/download/details.aspx?id=30437 The build number is 10.50.4000.0 and it includes fixes from 2008 R2 SP1 Cumulative Updates 1, 2, 3, 4 and 5....
Cumulative Updates available for SQL Server 2008 R2
Today the SQL Server Release Services Team has pushed out new cumulative updates for SQL Server 2008 R2: Cumulative Update #14 for SQL Server 2008 R2 RTM – KB article http://support.microsoft.com/kb/2703280 – build number 10.50.1817.0 – 7 fixes – relevant...
SQL Server 2008 R2 Service Pack 2 CTP is available
You can download the Service Pack 2 CTP from the following URL: http://www.microsoft.com/en-us/download/details.aspx?id=29848 The build # is 10.50.3720. This service pack contains all of the fixes from Service Pack 1 & Cumulative Updates 1...
New cumulative updates for SQL Server 2008 R2 (RTM & SP1) are available!
This morning the SQL Server Release Services Team has pushed out new cumulative updates for SQL Server 2008 R2. Cumulative Update #13 for SQL Server 2008 R2 RTM Knowledge Base article: http://support.microsoft.com/kb/2679366 Build number:...
Two new cumulative updates for SQL Server 2008 R2 are available!
Last night Microsoft released two new cumulative updates for SQL Server 2008 R2: Cumulative Update 5 for SQL Server 2008 R2 SP1 KB #2659694 Build 10.50.2806 16 fixes, including a nasty SCOPE_IDENTITY() bug and...
New cumulative updates for SQL Server 2008 R2 are available!
Microsoft has just released cumulative updates for both SQL Server 2008 R2 branches – RTM and Service Pack 1. SQL Server 2008 R2 Service Pack 1 Cumulative Update #4 http://support.microsoft.com/kb/2633146/ Build number is 10.50.2796...
Getting graphical ShowPlans back in SQL Server 2008 R2
For those of you using the SQL Server 2008 R2 version of Management Studio, and have applied Service Pack 1, you have probably noticed that clicking on a ShowPlan in grid results no longer...
Cumulative Updates for SQL Server 2008 R2 are available!
Today Microsoft has released Cumulative Updates for SQL Server 2008 R2. Cumulative Update #10 for SQL Server 2008 R2 RTM Build number: 10.50.1807 KB article: KB #2591746 13 fixes Cumulative Update #3 for SQL...
Cumulative Update #9 for SQL Server 2008 R2 RTM is available
Last night Microsoft released a new cumulative update package (CU #9) for SQL Server 2008 R2. The build # is 10.50.1804 and it contains 26 fixes – some of which, like the new CU...
Cumulative Update #2 for SQL Server 2008 R2 SP1 is available
Last night Microsoft has released Cumulative Update #2 for SQL Server 2008 R2 Service Pack 1. The build # is 10.50.2772 and it contains 14 fixes, a few of which are wrong-results bugs or...
SQL Server 2008 R2 SP1 CU1 is now available!
For those of you that held out on installing SQL Server 2008 R2 Service Pack 1 because it was missing the fixes from RTM's Cumulative Updates 7 & 8, your wait is over –...
SQL Server 2008 R2 Service Pack 1 is now available
And the hits keep coming! Microsoft not only released Denali CTP3 today, they have also released Service Pack 1 for SQL Server 2008 R2, which was first released as a CTP back in April...
Cumulative Update 8 for SQL Server 2008 R2 is available
Today the SQL Server Release Services team has published Cumulative Update #8 for SQL Server 2008 R2. http://support.microsoft.com/kb/2534352 The build number is 10.50.1797, there are 14 fixes showing on the KB article, and this...
More changes you might not have noticed in SQL Server 2008 R2 SP1 CTP
On Friday, after Microsoft released the CTP, I talked a little bit about the changes you will see in SQL Server 2008 R2 SP1. Namely: new rowcount-related columns in sys.dm_exec_query_stats; extended functionality of the FORCESEEK query...
SQL Server 2008 R2 SP1 CTP is now available
Just as I was about to shut my machine down on a Friday, Microsoft goes and releases something we've been waiting on for a long time: a Community Technology Preview (CTP) for Service Pack...
Cumulative Update #7 for SQL Server 2008 R2 is available
Many of you are probably asking, "Where is Service Pack 1 already?" Patience, friends. It will come in due time. In the meantime, you can see if any of the fixes in CU7 for...
New Cumulative Updates for SQL Server 2005 & SQL Server 2008 R2
Early this morning (or late last night, depending on your time zone), the SQL Server Release Services team pushed out three new cumulative updates for SQL Server. KB #2489375 – SQL Server 2005 SP3...
Is SQL Server 2008 R2 a full release of SQL Server?
This has come up in conversations more than once in the past little while – recently on twitter I made the casual comment that later this year, SQL Server 2008 will be "two versions...
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...
SQL Server 2008 R2 Best Practices Analyzer
Maybe I'm a little late to the party, but I thought I would share with you the most recent release of Microsoft's Best Practices Analyzer for SQL Server 2008 R2 (you can also read...
New Cumulative Updates for SQL Server 2005 SP3 & SQL Server 2008 R2
On Monday, Microsoft released two cumulative updates for SQL Server: KB #983329 : CU #10 for SQL Server 2005 SP3 (build # = 9.00.4305) KB #2072493 : CU #2 for SQL Server 2008 R2...
November CTP of SQL Server 2008 R2 : Download now
For those of you that have been wanting to try out SQL Server 2008 R2, you can download the November CTP of Express here (posted yesterday) and the full version of the November CTP...
More testing of Unicode Compression in SQL Server 2008 R2
Background Several weeks ago, I ran some tests on the new implementation of Unicode Compression in SQL Server 2008 R2 – both space-related and performance-related. Of course it was pointed out that my performance...
SQL Server 2008 R2 : More peeking under the hood
A little over a week ago, I performed some initial investigation into what has changed between SQL Server 2008 and 2008 R2. Steve Cooney quickly asked, "Where is all the schema for UCP and...
SQL Server 2008 R2 : Digging deeper into Unicode compression
When SQL Server 2008 R2 was first released, I wrote a quick blog post discussing the additional space savings gained by Unicode compression. In one of the follow-up comments, Adam Machanic was quick to...
Peeking under the hood : what bits have changed in SQL Server 2008 R2?
We know what new features are available in SQL Server 2008 R2: data-tier applications (still with that unfortunate and poorly-chosen acronym, DAC), control point explorer, dashboard viewpoints, report builder 3.0, Unicode compression, StreamInsight, yada...
Is SQL Server 2008 supported on Windows 7 / Windows Server 2008 R2?
Yes it is! See this blog post from Peter Saddow: SQL Server on Windows 7 First, if you have User Access Control in full swing, UAC will generate a prompt to make sure you're...
SQL Server 2008 R2 : A quick experiment in Unicode Compression
Fellow MVP Simon Sabin mentioned today one of the few engine enhancements we'll be seeing in SQL Server 2008 R2 : Unicode compression. You can read more about the topic in Books Online, but...