Sites Microsoft


Pssdiag & Sqldiag Manager update

Publié le 12 janvier 2017 sur css sql server engineers
 

We are releasing a new version of Pssdiag & Sqldiag Manager which supports SQL Server 2016.   It was originally published on https://diagmanager.codeplex.com. But we just moved it to github under Microsoft organization repo. New location …

SQL Server R Services – Why did we build it?

Publié le 10 janvier 2017 sur Microsoft SQL Server database engine blog
 

Author: Nellie Gustafsson This is the first post in a series of blog posts about SQL Server R Services. We want to take you behind the scenes and explain why we have built this feature and deep dive into how it works. Future posts will include details …

Announcing Columnstore Indexes and Query Store support in Database Engine Tuning Advisor

Publié le 10 janvier 2017 sur sql server team blog
 

The latest version of Microsoft SQL Server Database Engine Tuning Advisor (DTA) supports two new features: (a) Ability to recommend columnstore indexes in addition to rowstore indexes, and (b) Ability to automatically select a workload to tune fro …

Why can’t I get a parallel plan when rebuilding my index?

Publié le 9 janvier 2017 sur css sql server engineers
 

In support, we frequently have customers who call us and want to find out why a particular query doesn’t use parallelism.  Recently, we had a user who wanted to know why his index rebuild didn’t use parallelism.  In some cases, No …


Pages :