Sites Microsoft


Using DB Compatibility Level 130 with Old CE in SQL Server 2016

Publié le 27 avril 2016 sur Microsoft SQL Server database engine blog
 

In SQL Server 2014 we introduced a revamped Cardinality Estimator (CE), which we further improved in SQL Server 2016 and Azure SQL Database. With the new CE most workloads are seeing better query plans and thus improved performance. However, there …

SQL 2016 – It Just Runs Faster – BULK INSERT Uses Vector Instructions (SSE/AVX)

Publié le 27 avril 2016 sur css sql server engineers
 

SQL Server 2016 enhanced the bulk insert activities (BULK INSERT), leveraging the CPUs vector instructions.   The vector based approach allows the bulk data to be processed faster.   For example, when inserting data from a text file the …

Increased nonclustered index key size with SQL Server 2016

Publié le 26 avril 2016 sur Microsoft SQL Server database engine blog
 

SQL Server 2016 and Azure SQL Database have increased the maximum size for index keys with nonclustered indexes. The new maximum key size for nonclustered indexes is 1700 bytes. The maximum key size for clustered indexes remains 900 bytes. Conside …

SQL 2016 – It Just Runs Faster: Column Store Uses Vector Instructions (SSE/AVX)

Publié le 22 avril 2016 sur css sql server engineers
 

SQL Server’s Column Store feature is designed to accommodate large amounts of data and associated compression capabilities.  Microsoft studied numerous data layouts associated with column store and the CPU instructions required to process th …

Why do we see ENCRYPTION_SCAN locks in a SQL server

Publié le 19 avril 2016 sur css sql server engineers
 

Recently I worked with a customer who noticed that several sessions[spid’s] in their SQL Server was acquiring ENCRYPTION_SCAN locks. So they got curious and started looking at this closer. Naturally, the first thing to check is presence of databa …

Cumulative Update #6 for SQL Server 2014 SP1

Publié le 19 avril 2016 sur microsoft sql server release services
 

Dear Customers, The 6th cumulative update release for SQL Server 2014 SP1 is now available for download at the Microsoft Support site. To learn more about the release or servicing model, please visit: CU#6 KB Article: https://suppor …

Cumulative Update #13 for SQL Server 2014 RTM

Publié le 19 avril 2016 sur microsoft sql server release services
 

Dear Customers, The 13th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. To learn more about the release or servicing model, please visit: CU#13 KB Article: https:/ …

SQL Server 2016 cloud backup and restore enhancements

Publié le 19 avril 2016 sur sql server team blog
 

This post was authored by Eli Fisher, Program Manager, SQL Server. By backing up to the cloud, you can easily store a copy of your data offsite, allowing you to take advantage of cost-effective storage options. In SQL Server 2016, we have added signifi …

SQL 2016 – It Just Runs Faster: Multiple Log Writer Workers

Publié le 19 avril 2016 sur css sql server engineers
 

  SQL Server 2016 introduces multiple log writer workers to the engine.    For many years the log device was limited by the capabilities of spinning media and hardware caches.    The advancement of hardware caches and …

SQL 2016 – It Just Runs Faster: Larger Data File Writes

Publié le 15 avril 2016 sur css sql server engineers
 

SQL Server uses WriteFileGather for the vast majority of data file write requests.   The logic is to consolidate dirty pages into a single I/O request.   For example page 1:13 and 1:12 are dirty resulting in a single WriteFileGather oper …

SQL Server Data Tools Preview update for April 2016

Publié le 15 avril 2016 sur sql server data tools team blog
 

The SQL Server Data Tools team is pleased to announce an update for SSDT Preview is now available. The SSDT Preview update for April 2016 added support for the latest updates of SQL Server 2016 RC3, various bug fixes.   Get it …

SQL Server 2016 Release Candidate 3 now available

Publié le 15 avril 2016 sur sql server team blog
 

We are excited to announce that our fourth and final SQL Server 2016 release candidate, SQL Server 2016 Release Candidate (RC) 3, is now available for download. Our SQL Server Release Candidates represent important milestones in the release of SQL Serv …

Announcing SQL Server Management Studio – April 2016 Release

Publié le 15 avril 2016 sur microsoft sql server release services
 

Today, we are very pleased to announce the latest preview of SQL Server Management Studio (SSMS). This release includes all updates included in the March refresh release, and features improvements in the SSMS installer to add human readable error messa …

Keep data virtually forever with Stretch Database in SQL Server 2016

Publié le 13 avril 2016 sur sql server team blog
 

This post was authored by Joe Young, Sr. Program Manager, SQL Server. Stretch Database in SQL Server 2016 allows users to keep as much data as they need, for as long as they need, without incurring business service level agreement (SLA) risks or the hi …


Pages :