Sites Microsoft


Technical Overview: SQL Server 2016 Release Candidate 0

Publié le 7 mars 2016 sur sql server team blog
 

The SQL Server engineering team is pleased to announce the availability of SQL Server 2016 Release Candidate 0. This is an important milestone in the release of SQL Server 2016, as it marks feature completion for most dimensions of the product and mean …

Announcing SQL Server Stretch Database service preview

Publié le 7 mars 2016 sur sql server team blog
 

Microsoft is pleased to announce a preview of the new SQL Server Stretch Database service. With this preview, SQL Server 2016 users can dynamically stretch their on-premises warm and cold data to an Azure service that is engineered from the g …

Columnstore Index Defragmentation using REORGANIZE Command

Publié le 7 mars 2016 sur Microsoft SQL Server database engine blog
 

Columnstore index, both clustered and nonclustered, can get fragmented like any other index. SQL Server 2016 allows customer to defragment this index using the familiar ALTER INDEX <index-name> REORGANIZE command instead of using a heavy hammer a …

Real-Time Operational Analytics: Memory-Optimized Tables and Columnstore Index

Publié le 7 mars 2016 sur Microsoft SQL Server database engine blog
 

SQL Server 2016 supports real-time operational analytics both for disk-based (i.e. traditional tables) and memory-optimized tables without requiring any changes to your transactional workload. For disk-based tables, you can do it by creating a nonclust …

Real-Time Operational Analytics: Compression Delay option with NCCI and the performance

Publié le 6 mars 2016 sur Microsoft SQL Server database engine blog
 

The previous blog https://blogs.msdn.microsoft.com/sqlserverstorageengine/2016/03/06/real-time-operational-analytics-compression-delay-option-for-nonclustered-columnstore-index-ncci/  showed the scenario and benefits of compression-delay option …

Real-Time Operational Analytics: Compression Delay Option for Nonclustered Columnstore Index (NCCI)

Publié le 6 mars 2016 sur Microsoft SQL Server database engine blog
 

The previous blog https://blogs.msdn.microsoft.com/sqlserverstorageengine/2016/03/06/real-time-operational-analytics-filtered-nonclustered-columnstore-index-ncci/  showed how filtered nonclustered columnstore index (NCCI) can be used to …

Real-Time Operational Analytics: Filtered nonclustered columnstore index (NCCI)

Publié le 6 mars 2016 sur Microsoft SQL Server database engine blog
 

The previous blog https://blogs.msdn.microsoft.com/sqlserverstorageengine/2016/03/04/real-time-operational-analytics-dml-operations-and-nonclustered-columnstore-index-ncci-in-sql-server-2016/ showed how updateable nonclustered columnstore index (N …

Real-Time Operational Analytics: DML operations and nonclustered columnstore index (NCCI) in SQL Server 2016

Publié le 4 mars 2016 sur Microsoft SQL Server database engine blog
 

In the previous blog https://blogs.msdn.microsoft.com/sqlserverstorageengine/2016/02/29/real-time-operational-analytics-simple-example-using-nonclustered-clustered-columnstore-index-ncci/ , I showed you how you can create NCCI on a regular rowstore tab …

SQL Server Parallel Query Placement Decision Logic

Publié le 4 mars 2016 sur css sql server engineers
 

Recently I had a conversion with (Jonathan Kehayias jonathan@sqlskills.com) about the placement of workers belonging to a parallel query.   As I asked around and reviewed the code I quickly found that the assumption is still ‘Least Load …

SQL 2016 – It Just Runs Faster: Native Spatial Implementation(s)

Publié le 3 mars 2016 sur css sql server engineers
 

Spatial data is among, if not the fastest, growing storage types for the SQL Server database.   It is common place for customers to have 3,000,000 or more rows in a database.   Customers are tracking vehicles, delivery locations, dr …

Upsert JSON documents in SQL Server 2016

Publié le 3 mars 2016 sur Microsoft SQL Server database engine blog
 

In Sql Server 2016 you can easily insert or update JSON documents by combining OPENJSON and MERGE statement. In this example I will create one procedure that imports events formatted as JSON in Events table. Example code is shown in the following listi …

SQL Server 2016 – Making DBCC CHECKDB Faster

Publié le 1 mars 2016 sur Microsoft SQL Server database engine blog
 

SQL Server 2016 has introduced several improvements to DBCC CHECKDB to make it faster. Please refer to the blog published by Ajay (SQL Server Tiger Team) http://blogs.msdn.com/b/sql_server_team/archive/2016/03/01/several-improvements-to-dbcc-checkdb-to …

Are you running SQL Server 2005 Express? (Are you sure?)

Publié le 1 mars 2016 sur sql server team blog
 

Only a few weeks remain before extended support for SQL Server 2005 ends. Although we’ve been talking about this for months, there’s a chance the April 12 end of support date will sneak up on you — if you’re one of thousands who …

SQL 2016 – It Just Runs Faster: DBCC Extended Checks

Publié le 1 mars 2016 sur css sql server engineers
 

  When checking database consistency using DBCC CHECKDB, in addition to the amount of data or number of tables and indexes, the duration can be exponentially longer, (for example: some customer workloads have reported 10x slower performance for CH …


Pages :