October - Technical Rollup Mail – SQL
News
Financial Services Companies Rely on SQL Server 2012 to Deliver the New Standard in Mission Critical Platforms
SQL Server 2012 SP1 CTP4 Now Available
Premier
OpsVault — Operate and Optimize IT
Microsoft Premier Support UK - Site Home - TechNet Blogs
https://blogs.technet.com/b/mspremuk/
SQL Server Blogs
Search - MSDN Blogs
https://blogs.msdn.com/search/searchresults.aspx?q=SQL%20Server%202008%20R2§ions=5001
MSDN Blogs
https://blogs.msdn.com/b/psssql/
SQL Server Team Blog - Site Home - TechNet Blogs
https://blogs.technet.com/b/dataplatforminsider/
SQL Server Security - Site Home - MSDN Blogs
https://blogs.msdn.com/b/sqlsecurity/
In Recovery... | Paul S. Randal on SQL Server
https://www.sqlskills.com/blogs/paul/
SQL Server Storage Engine - Site Home - MSDN Blogs
https://blogs.msdn.com/b/sqlserverstorageengine/
SQL Azure Team Blog - Site Home - MSDN Blogs
https://blogs.msdn.com/b/sqlazure/
Other
https://blogs.technet.com/trm/default.aspx
New KB's
SQL 2008 & 2008R2
Microsoft SQL Server 2008 R2 Analysis Services: FIX: An MDX query in SQL Server 2008 R2 runs very slowly if the query contains nested Crossjoin functions
https://support.microsoft.com/kb/2707185/en-US
Microsoft SQL Server 2008 R2 Analysis Services: FIX: Incorrect results when you run an MDX query in ROLAP storage mode in SQL Server 2008 R2 Analysis Services
https://support.microsoft.com/kb/2741143/en-US
Microsoft SQL Server 2008 R2 Datacenter: FIX: Access violation in SQL Server internal deadlock monitor when you run multiple applications together with Multiple Active Result Sets enabled in SQL Server 2008 R2
https://support.microsoft.com/kb/2723979/en-US
Microsoft SQL Server 2008 R2 Datacenter: FIX: "Tuning process exited unexpectedly" error message when you run Database Engine Tuning Advisor under the db_owner role in SQL Server 2008 R2
https://support.microsoft.com/kb/2728419/en-US
Microsoft SQL Server 2008 R2 Datacenter: FIX: "A system assertion check has failed" error when you re-create a nonclustered index on a column in SQL Server 2008 R2
https://support.microsoft.com/kb/2728534/en-US
Microsoft SQL Server 2008 R2 Datacenter: FIX: You cannot delete a consolidated or collection member from an entity in SQL Server 2008 R2
https://support.microsoft.com/kb/2730795/en-US
Microsoft SQL Server 2008 R2 Datacenter: FIX: Performance decreases when you run a parallel query after you upgrade from SQL Server 2008 to SQL Server 2008 R2
https://support.microsoft.com/kb/2732742/en-US
Microsoft SQL Server 2008 R2 Integration Services: FIX: Some events are missing when you run an SSIS package by using the dtexec utility (DTExec.exe) or the SQL Server Agent in SQL Server 2008 R2
https://support.microsoft.com/kb/2711189/en-US
Microsoft SQL Server 2008 R2 PowerPivot for Microsoft Excel 2010: FIX: "The syntax of the string representation of a datetime value is incorrect" error when you use SQL Server 2008 R2 PowerPivot for Excel 2010
https://support.microsoft.com/kb/2729495/en-US
Microsoft SQL Server 2008 R2 PowerPivot for Microsoft Excel 2010: FIX: "An unexpected error occurred" when you query some calculation data of an SSAS tabular model by using SQL Server 2008 R2 PowerPivot for Excel 2010 or SQL Server 2008 R2 PowerPivot for SharePoint 2010
https://support.microsoft.com/kb/2731068/en-US
Microsoft SQL Server 2008 R2 Reporting Services: FIX: KeepTogether property does not work when you generate a report that contains a Tablix in SSRS 2008 R2
https://support.microsoft.com/kb/2737499/en-US
Microsoft SQL Server 2008 R2 Service Pack 2: FIX: "Cannot get the supported data types from the database connection" error message when you use the Import and Export Data Wizard to connect to a Sybase database in SQL Server 2008 R2
https://support.microsoft.com/kb/2740507/en-US
SQL 2012
Microsoft SQL Server 2012 Business Intelligence: FIX: "out of memory" error when you use ODBC with SQL Server 2012
https://support.microsoft.com/kb/2667742/en-US
Microsoft SQL Server 2012 Business Intelligence: FIX: Access violation when you try to build a columnstore index for a table in SQL Server 2012
https://support.microsoft.com/kb/2708786/en-US
Microsoft SQL Server 2012 Business Intelligence: FIX: "Dataflow - <SSISPackageName>" error when you try to open an SSIS package in SSIS 2012
https://support.microsoft.com/kb/2713827/en-US
Microsoft SQL Server 2012 Business Intelligence: "No such interface supported" error message when you add a project to a source control in SQL Server Management Studio 2012
https://support.microsoft.com/kb/2727824/en-US
Microsoft SQL Server 2012 Business Intelligence: FIX: Incorrect email priority if you set the SSRS email subscription priority to Low or Normal in SSRS 2012
https://support.microsoft.com/kb/2731402/en-US
Microsoft SQL Server 2012 Developer: "A severe error occurred on the current command" error when you run a full-text query that has the CONTAINS predicate in SQL Server 2012
https://support.microsoft.com/kb/2709075/en-US
Microsoft SQL Server 2012 Developer: FIX: "No object exists with a lineage ID" error message when you run an SSIS 2012 package
https://support.microsoft.com/kb/2714937/en-US
Microsoft SQL Server 2012 Developer: FIX: SQL Server Agent logs verbose logs in the Application log when you start a SQL Server 2012 failover cluster instance
https://support.microsoft.com/kb/2718920/en-US
Microsoft SQL Server 2012 Developer: FIX: Slow performance or deadlock when you restore a database and execute statements at the same time in SQL Server 2012
https://support.microsoft.com/kb/2725950/en-US
Microsoft SQL Server 2012 Developer: FIX: You cannot install a SQL Server 2012 cluster instance on a Server Core operating system that contains an existing cluster instance
https://support.microsoft.com/kb/2727221/en-US
Microsoft SQL Server 2012 Developer: FIX: SQL Server is slow or an "Out-Of-Memory" error occurs when you run a query with nested IF statements on DAX measures in SQL Server 2012
https://support.microsoft.com/kb/2733091/en-US
Microsoft SQL Server 2012 Developer: FIX: "FOR UPDATE clause allowed only for DECLARE CURSOR" error when you execute stored procedures together with cursor-specific syntax in SQL Server 2012
https://support.microsoft.com/kb/2740957/en-US
Microsoft SQL Server 2012 Enterprise: FIX: "Failure sending mail" error when you create a subscription to deliver an RDL report whose file name contains non-Latin characters in SSRS 2012
https://support.microsoft.com/kb/2725256/en-US
Microsoft SQL Server 2012 Enterprise: FIX: Execution of a package ends unexpectedly and status is "Canceled" when you execute many SSIS 2012 packages in parallel