SQL Server 2014 Service Pack 1 is now available

Approximately one year ago, we launched SQL Server 2014. Today, May 15, we are pleased to announce the release of SQL Server 2014 Service Pack 1 (SP1). The Service Pack is initially available for download on the Microsoft Download Center. SQL Server 2014 with SP1 will be rolling out to additional venues including MSDN/TechNet, the Volume…

0

Upgrading to SQL 2014: Report Server version mismatch

We wanted to let you know of a potential issue that you may experience when upgrading from SQL 2012 SP2 to SQL 2014. Symptom If you have recently upgraded your SQL Server Reporting Services instance from SQL 2012 SP2 to SQL 2014, you may hit the following error message when trying to access your report…


Best practices for maximum performance and scalability gains for SQL Server workloads

We have worked with our colleagues in CSS to publish a KB article that lists recommended configuration and tuning options as well as necessary updates for SQL Server if you are running one of the newer versions of SQL Server on modern hardware. A typical configuration of this high performance workload environment comprises SQL Server…

0

Overcoming Performance limitations in ROLAP and PDW

Overview: The customer uses SSAS ROLAP partition model connect to PDW as data source. The customer wants to do a drill through action, and the ROLAP query generated by the drill through contains a few hundred GROUP BY clauses. The ROLAP query is requesting more data than the customer is asking for in the drill…