[Edit January 2015: Everything in this post applies to SQL Server 2012 and 2014 still.] This blog post is part of the monthly T-SQL Tuesday
2005 SP3 CU6 contains a fix for a corruption bug that can happen after rebuilding an XML index that contains XML elements greater than 8000
Here's an interesting bug that was just recently fixed, and someone actually hit it today, so it's time to blog it. Bottom line is that
Last week’s survey was on how you should store large-value character data in SQL 2005+ (see here for the survey). Here are the result as
Both 2005 SP3 CU2 and 2005 SP2 CU12 contain fixes for two bugs that cause corruption in LOB data. The first bug may happen when
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.