SQL Server 2014

14 posts

SQL Server 2014 SP2 Cumulative Update 9 Released

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 […]

New Cumulative Updates for SQL Server 2012, 2014, and 2016

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 […]

SQL Server 2014 SP2 CU4, SP1 CU11 Released

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, […]

SQL Server 2014 SP2 CU2 Released

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 […]

SQL Server 2014 SP2 Released

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 […]

New SQL Server 2014 Service Pack 1 Cumulative Update 7, plus CU14

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 […]

Urgent: Do Not Install SQL 2014 SP1 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.

New SQL Server 2014 CU11 and SP1 CU4 Available for Download

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.

SQL Server 2014 SP1 CU3, RTM CU 10 Released

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 […]