Just a handful of fixes in this one: UPDATE statement fails silently if you reference a nonexistent partition function the WHERE clause Incorrect results for SELECT with batch mode hash aggregate Invalid comparison due to NO COLLATION False alarms from CHECKDB if SOUNDEX function is used in a persisted computed […]
SQL Server 2014
14 posts
Good evening, and how are you doing tonight? Welcome to Café Updaté. Tonight, Chef has prepared a delicious menu from the latest, freshest market ingredients. I’ll be back in a few moments to take your drink orders and tell you about the specials, but in the meantime, get comfortable, enjoy […]
The twins walked into my office like a tank coming through Europe. She meant business, barking at me nonstop, as if she’d already hired my detective services. I kept trying to interject, but he kept waving around his pistol like it was loaded full of fixes. They wouldn’t give me their real names, […]
For those of you who are still stuck in the dark ages on that decrepit SQL Server 2014*, there’s a new Cumulative Update out that puts a little lipstick on that pig. Fixes include: Query performance improvement for columnstore Crashes with an access violation when you use TRY/CATCH for bulk […]
It was a dark and stormy night. The next morning, SQL Server 2014 SP2 arrived, chock full of fixes like: New DBCC CLONEDATABASE command to generate a statistics-only copy of the database for CE troubleshooting Faster performance for large databases with a large number of partitions More AlwaysOn (note the […]
Microsoft just unveiled the latest fashions for their summer lineup. All the best-dressed SQL Server 2014s will be running the new Cumulative Update 7, which includes hotfixes for stuff like: High CPU usage and PAGELATCH_* waits on SP1 Non-yielding scheduler errors on queries with a large number of OR clauses […]
Recently, CU6 was pulled because NOLOCK queries were taking locks that weren’t expected. Today, Microsoft has released a fixed CU6.
Turns out that if a SELECT query with a NOLOCK hint goes parallel, it will take a lock on the underlying table and block other queries. For more information, check out the Microsoft Release Services blog. We’ve removed the CU6 from our downloads list until a patch comes out.
Normally, I talk a little about the updates included in each of these: SQL Server 2014 Service Pack 1 Cumulative Update 4, or SQL Server 2014 Cumulative Update 11 (for those of you who aren’t on SP1 yet) But I think this one speaks for itself: Merry Christmas.
Also known as the Pumpkin Spice Cumulative Updates: SQL Server 2014 SP1 CU3, 12.0.4425 SQL Server 2014 RTM CU10, 12.0.2556 The list of fixes includes a lot of good stuff: Rare index corruption when you build a columnstore index with parallelism on a partitioned table Can’t back up in-memory OLTP […]