May 2013 – Technical Rollup Mail – SQL Server
| Technorati Tags: SQL Server,Business,BI,SSAS,SSRS,Analysis Services |
News 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 Premier OpsVault — Operate and Optimize IT 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/ Paul S. Randal - In Recovery... https://www.sqlskills.com/blogs/paul/ SQL Server Storage Engine - Site Home - MSDN Blogs https://blogs.msdn.com/b/sqlserverstorageengine/ SQL Azure SQL Azure Team Blog - Site Home - MSDN Blogs https://blogs.msdn.com/b/sqlazure/ https://blogs.technet.com/trm/default.aspx New KB's Troubleshooting AlwaysOn availability group listener creation in SQL Server 2012 https://support.microsoft.com/kb/2829783/EN-US How to troubleshoot the "Cannot generate SSPI context" error message https://support.microsoft.com/kb/811889/EN-US How to use Kerberos authentication in SQL Server https://support.microsoft.com/kb/319723/EN-US 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 https://support.microsoft.com/kb/2644396/EN-US "Validating WSFC quorum vote configuration" warning when you create an AlwaysOn availability group in SQL Server 2012 https://support.microsoft.com/kb/2833122/EN-US Using SQL Server in Windows 8 and Windows Server 2012 environments https://support.microsoft.com/kb/2681562/EN-US Enable plan-affecting SQL Server query optimizer behavior that can be controlled by different trace flags on a specific-query level https://support.microsoft.com/kb/2801413/EN-US You may experience connectivity issues to SQL Server if SPNs are misconfigured https://support.microsoft.com/kb/2443457/EN-US How to enable Trace Logging in SQL Server 2008 R2 and 2012 Master Data Services https://support.microsoft.com/kb/2423478/EN-US Database file names change when you restore a database by using the WITH REPLACE option in SQL Server 2012 https://support.microsoft.com/kb/2839722/EN-US "A system assertion check has failed" error message when you execute a CREATE PARTITION FUNCTION statement in SQL Server 2008 R2 https://support.microsoft.com/kb/2813697/EN-US 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 https://support.microsoft.com/kb/2756471/EN-US FIX: Business rule does not work when a member code contains special characters in MDS in SQL Server 2012 https://support.microsoft.com/kb/2819383/EN-US SQL Server 2012 performance issues in NUMA environments https://support.microsoft.com/kb/2819662/EN-US FIX: A PowerPivot workbook cannot connect to data source and load data when a PowerPivot server of a SharePoint farm is unavailable https://support.microsoft.com/kb/2760981/EN-US FIX: "Failed Assertion = 'CheckValidInput (wsName, cbName)'" error when you use database mirroring in Microsoft SQL Server 2008 R2 https://support.microsoft.com/kb/2802113/EN-US FIX: Access violation when you put a FILESTREAM-enabled database offline in SQL Server 2008 R2 or in SQL Server 2012 https://support.microsoft.com/kb/2800013/EN-US 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 https://support.microsoft.com/kb/2800797/EN-US FIX: Heap corruption occurs when an MDX error message is generated in SSAS 2008, SSAS 2008 R2 or SSAS 2012 https://support.microsoft.com/kb/2809431/EN-US 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 https://support.microsoft.com/kb/2809339/EN-US FIX: Access violation when you restore transaction log backups in a SQL Server 2008 R2-based or SQL Server 2012-based log shipping environment https://support.microsoft.com/kb/2806244/EN-US FIX: Session deadlock occurs when you use an Analysis Services personalization extension in SSAS 2008 R2 or in SSAS 2012 https://support.microsoft.com/kb/2794260/EN-US 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 https://support.microsoft.com/kb/2803994/EN-US 2803799 FIX: A query that runs against a DMV enters an infinite loop in SQL Server 2008 R2 or in SQL Server 2012 https://support.microsoft.com/kb/2803799/EN-US 2821783 FIX: Out-of-memory errors related to a memory clerk in SQL Server 2012 https://support.microsoft.com/kb/2821783/EN-US Troubleshooting automatic failover problems in SQL Server 2012 AlwaysOn environments https://support.microsoft.com/kb/2833707/EN-US You receive a "Warning SuperSocket Info" warning information when a SQL Server service account is a domain user https://support.microsoft.com/kb/303411/EN-US 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 https://support.microsoft.com/kb/959032/EN-US FIX: Incorrect result when you run an MDX query that returns multiple calculated members in SSAS 2008, SSAS 2012 or SSAS 2008 R2 https://support.microsoft.com/kb/2821836/EN-US FIX: SSAS 2012 freezes when a scheduled data update starts while you run complex DAX queries https://support.microsoft.com/kb/2821686/EN-US FIX: CPU spike when there is no load on a server after you install SQL Server 2012 on the server https://support.microsoft.com/kb/2813214/EN-US FIX: Poor performance when you run a query against an RCSI-enabled table in SQL Server 2012 https://support.microsoft.com/kb/2806979/EN-US 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 https://support.microsoft.com/kb/2504090/EN-US FIX: Security token leak when you run more than two PowerShell steps by using a proxy account in a SQL Server Agent job https://support.microsoft.com/kb/2791496/EN-US FIX: Transaction log backup is created even though the full backup is canceled in SQL Server 2008 or in SQL Server 2008 R2 https://support.microsoft.com/kb/2618676/EN-US 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
- Anonymous
May 17, 2013
Do you know if the fix for 2809339 also included the "FIX" function? I am having a similar problem, but with FIX() not INT()