May 2013 – Technical Rollup Mail – SQL Server





Leveraging Flash across the Microsoft SQL Server Stack

Viewing and Integrating with SSRS Reports on an iPad

Insight Through Integration: SQL Server Parallel Data Warehouse

PASS Business Analytics Conference

Develop and Test New SQL Server Apps, Scale Existing Apps


OpsVault — Operate and Optimize IT

TechNet Blogs

SQL Server Blogs

Search – MSDN Blogs

MSDN Blogs

SQL Server Team Blog – Site Home – TechNet Blogs

SQL Server Security – Site Home – MSDN Blogs

Paul S. Randal – In Recovery…

SQL Server Storage Engine – Site Home – MSDN Blogs

SQL Azure

SQL Azure Team Blog – Site Home – MSDN Blogs

New KB’s

Troubleshooting AlwaysOn availability group listener creation in SQL Server 2012

How to troubleshoot the "Cannot generate SSPI context" error message

How to use Kerberos authentication in SQL Server

FIX: Merge replication changes are missing on a SQL Server subscriber when they subscribe to a partition in SQL Server 2008 R2 or in SQL Server 2012

"Validating WSFC quorum vote configuration" warning when you create an AlwaysOn availability group in SQL Server 2012

Using SQL Server in Windows 8 and Windows Server 2012 environments

Enable plan-affecting SQL Server query optimizer behavior that can be controlled by different trace flags on a specific-query level

You may experience connectivity issues to SQL Server if SPNs are misconfigured

How to enable Trace Logging in SQL Server 2008 R2 and 2012 Master Data Services

Database file names change when you restore a database by using the WITH REPLACE option in SQL Server 2012

"A system assertion check has failed" error message when you execute a CREATE PARTITION FUNCTION statement in SQL Server 2008 R2

FIX: Incorrect result is returned when you query an indexed view by using the NOEXPAND hint in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012

FIX: Business rule does not work when a member code contains special characters in MDS in SQL Server 2012

SQL Server 2012 performance issues in NUMA environments

FIX: A PowerPivot workbook cannot connect to data source and load data when a PowerPivot server of a SharePoint farm is unavailable

FIX: "Failed Assertion = ‘CheckValidInput (wsName, cbName)’" error when you use database mirroring in Microsoft SQL Server 2008 R2

FIX: Access violation when you put a FILESTREAM-enabled database offline in SQL Server 2008 R2 or in SQL Server 2012

FIX: Incorrect results when you run a FULL JOIN query that uses the CROSS APPLY clause in SQL Server 2008 R2 or in SQL Server 2012

FIX: Heap corruption occurs when an MDX error message is generated in SSAS 2008, SSAS 2008 R2 or SSAS 2012

FIX: High memory usage or OOM error when you run an MDX query in SSAS 2008 R2 or in SSAS 2012 that uses the INT function

FIX: Access violation when you restore transaction log backups in a SQL Server 2008 R2-based or SQL Server 2012-based log shipping environment

FIX: Session deadlock occurs when you use an Analysis Services personalization extension in SSAS 2008 R2 or in SSAS 2012

FIX: Data corruption occurs when LOB data is loaded into a Transact-SQL variable in SQL Server 2008 R2, SQL Server 2012 or SQL Server 2008

2803799 FIX: A query that runs against a DMV enters an infinite loop in SQL Server 2008 R2 or in SQL Server 2012

2821783 FIX: Out-of-memory errors related to a memory clerk in SQL Server 2012

Troubleshooting automatic failover problems in SQL Server 2012 AlwaysOn environments

You receive a "Warning SuperSocket Info" warning information when a SQL Server service account is a domain user

FIX: When you run the "dbcc dbreindex" command or the "alter index" command, some transactions are not replicated to the subscribers in a transactional replication in SQL Server 2005 or in SQL Server 2008

FIX: Incorrect result when you run an MDX query that returns multiple calculated members in SSAS 2008, SSAS 2012 or SSAS 2008 R2

FIX: SSAS 2012 freezes when a scheduled data update starts while you run complex DAX queries

FIX: CPU spike when there is no load on a server after you install SQL Server 2012 on the server

FIX: Poor performance when you run a query against an RCSI-enabled table in SQL Server 2012

FIX: Access violation or incorrect result when you insert data into or update a new partition of a partitioned table in SQL Server 2008 R2, SQL Server 2012 or SQL Server 2008

FIX: Security token leak when you run more than two PowerShell steps by using a proxy account in a SQL Server Agent job

FIX: Transaction log backup is created even though the full backup is canceled in SQL Server 2008 or in SQL Server 2008 R2

FIX: Error when you run the sp_cursoropen stored procedure together with the scrollopt argument in SQL Server 2008 R2

This content is for informational purposes only. Microsoft makes no warranties express or implied, as to the information in this document. If you are a customer of Microsoft, please refer to the terms and conditions which cover the provision of support and consulting services to you/your organization.  If you are not corresponding in the course of, or in connection with a Microsoft contract or program with its own terms and conditions, please note that no liability is accepted by Microsoft for the contents of this document. 

TRM contributor this month was Glen Small.

This message from Microsoft is an important part of a programme, service, or product that you or your company have purchased or participate in. Microsoft respects your privacy. Please read our Privacy Statement


Comments (1)

  1. Shannon Holck says:

    Do you know if the fix for 2809339 also included the "FIX" function?  I am having a similar problem, but with FIX() not INT()