You searched for the word(s):
Showing page 1 of 182 (1,815 total posts)
< 1 second(s)
The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #11. This cumulative update includes a fix for the online index rebuild corruption issue I discussed recently on SQLPerformance.com.
KB Article: KB #2975396
Build # is 11.0.3449
Currently there are 32 public fixes listed (32 total)
Relevant for ...
This month's T-SQL Tuesday is about assumptions in SQL Server. Over on our new consolidated team blog at SQL Sentry, I discuss the following assumptions I come across with relative frequency:
Case will always short circuit
A seek is better than a scan, always
A query without ORDER BY will always order by _________
SQL Server's defaults are ...
@Nate ok, readability is quite subjective, and I am never going to convince everyone about any aspect of what makes code more or less readable - way too many preferences, styles, habits, etc.
But what about the other points that even ogrig conceded (and Brian ignored)? Are you really going to continue using old-style joins just for readability, ...
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 10.50.4319
Relevant for @@VERSION 10.50.4000 through 10.50.4318
My usual disclaimer: these updates are NOT for SQL Server 2008 (or ...
Microsoft has released Cumulative Update #2 for SQL Server 2014.
Important! This Cumulative Update fixes the data loss / corruption issue with online index rebuilds that I talked about in this blog post on sqlperformance.com.
KB Article: KB #2967546
48 fixes listed publicly at time of publication (52 total)
Build number is ...
Paul and LucX, yes, see my last paragraph, they know the T-SQL reference is missing:
@Dale yes, if you are relying on any fixes in CU10 that are not in SP2 (and I believe that's all of them), you will lose them.
@Dale because service packs go through a much longer test and regression cycle than cumulative updates. It is almost always the case that a service pack is missing updates from the most recent CU, sometimes the most recent TWO CUs, because the SP code branch was locked down for testing long before some of those CU issues were even discovered, ...
Service Pack 2 is available:
The build number is 11.0.5058, and this includes fixes up to and including SQL Server 2012 SP1 CU #9. (The complete list of fixes is exhaustive, including all fixes from SP1 CU #1 -> #9, but the post-CU #9 fixes are listed ...
This is how it's been since 2005.
Overrides the max degree of parallelism configuration option of sp_configure and Resource Governor for the query specifying this option. The MAXDOP query hint can exceed the value configured with sp_configure. If MAXDOP exceeds the ...