IO Statistics now available for queries that use Columnstore indexes

Prior to SQL Server 2014 Service Pack 1, if you turned on STATISTICS IO for queries that touch Columnstore index, it would always report 0 as seen in the simple example below:   CREATE TABLE t (c INT) GO INSERT INTO t VALUES (1) GO CREATE CLUSTERED COLUMNSTORE INDEX cci ON t GO SET STATISTICS…

0

Eliciting your feedback about upgrading SQL Server

SQL Server DBAs –   The SQL Server engineering team needs you and your input! We’re running a high-velocity planning program about upgrading SQL Server and this process is literally driven on your feedback. Don’t think you need a super-sized monster system to qualify; we’re looking for a wide range of inputs and perspectives. If…


MS15-058 SQL Server Security Bulletin Released

A security bulletin for SQL Server has been released on 7/14/2015. This applies to SQL Server 2008, 2008 R2, 2012, and 2014 releases. Please see the bulletin and KB links below for details on the fixes and how to download. Bulletin # KB Title Severity Impact MS15-058 3065718 Vulnerabilities in SQL Server Could Allow Remote…


Upcoming end of support for SQL Server 2005

Please note that SQL Server 2005 will be out of extended support on Apr 12, 2016. If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates. Please see http://www.microsoft.com/en-us/server-cloud/products/sql-server-2005/default.aspx for upgrade options.   More information about SQL Server 2005 support policy is available at https://support.microsoft.com/en-us/lifecycle/search/default.aspx?alpha=sql%20server%202005&Filter=FilterNO.  …

0

Nonclustered Columnstore Index on Base Table Partitioned by Computed Column

If you have SQL Server 2012 and created a NCCI on a base table partitioned by a computed column, you might have noticed that it produces a serial plan instead of a parallel plan. This, naturally, slows down index creation. How slow depends on your database size and number of partitions. You can use sys.dm_exec_query_memory_grants…

0

Secondary Replica may go into suspended state if you alter the readability property of the Availability Group and page compression is enabled

Please apply one of the fixes mentioned at the bottom of this blog page or employ one of the suggested workarounds if you are AlwaysOn Availability Groups and have enabled page compression on any table that is part of a database in the Availability group. In such a setting, if you alter the readability property…

1

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…