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.
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.
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...
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...
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...
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...
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...
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...
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...
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...
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,...
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 –...
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...
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...
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...
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...
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...
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...
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....
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...
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...
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:...
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...
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...
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...
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...
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...
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...
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 –...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...