Skip to content

new-updated-t-sql.md

Latest commit

 

History

History
200 lines (103 loc) · 8.25 KB

new-updated-t-sql.md

File metadata and controls

200 lines (103 loc) · 8.25 KB
title Updated - T-SQL docs | Microsoft Docs
description Display snippets of updated content for recently changed in documentation, for Transact-SQL.
manager craigg
author MightyPen
ms.author genemi
ms.topic article
ms.custom UpdArt.exe
ms.suite sql
ms.prod_service sql-non-specified
ms.component t-sql
ms.date 02/03/2018

New and Recently Updated: Transact-SQL docs

Nearly every day Microsoft updates some of its existing articles on its Docs.Microsoft.com documentation website. This article displays excerpts from recently updated articles. Links to new articles might also be listed.

This article is generated by a program that is rerun periodically. Occasionally an excerpt can appear with imperfect formatting, or as markdown from the source article. Images are never displayed here.

Recent updates are reported for the following date range and subject:

  • Date range of updates:   2017-12-03   -to-   2018-02-03
  • Subject area:   T-SQL.

 

New Articles Created Recently

The following links jump to new articles that have been added recently.

There are no new articles to list, this time.

 

Updated Articles with Excerpts

This section displays the excerpts of updates gathered from articles that have recently experienced a large update.

The excerpts displayed here appear separated from their proper semantic context. Also, sometimes an excerpt is separated from important markdown syntax that surrounds it in the actual article. Therefore these excerpts are for general guidance only. The excerpts only enable you to know whether your interests warrant taking the time to click and visit the actual article.

For these and other reasons, do not copy code from these excerpts, and do not take as exact truth any text excerpt. Instead, visit the actual article.

 

Compact List of Articles Updated Recently

This compact list provides links to all the updated articles that are listed in the Excerpts section.

  1. CREATE STATISTICS (Transact-SQL)
  2. UPDATE STATISTICS (Transact-SQL)

 

 

1.   CREATE STATISTICS (Transact-SQL)

Updated: 2018-01-04           (Next)

 

MAXDOP = max_degree_of_parallelism Applies to: SQL Server (Starting with SQL Server 2017 CU3).

Overrides the max degree of parallelism configuration option for the duration of the statistic operation. For more information, see Configure the max degree of parallelism Server Configuration Option. Use MAXDOP to limit the number of processors used in a parallel plan execution. The maximum is 64 processors.

max_degree_of_parallelism can be:

1 Suppresses parallel plan generation.

>1 Restricts the maximum number of processors used in a parallel statistic operation to the specified number or fewer based on the current system workload.

0 (default) Uses the actual number of processors or fewer based on the current system workload.

<update_stats_stream_option> Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

 

 

2.   UPDATE STATISTICS (Transact-SQL)

Updated: 2018-01-04           (Previous)

 

MAXDOP = max_degree_of_parallelism

Applies to: SQL Server (Starting with SQL Server 2017 CU3).

Overrides the max degree of parallelism configuration option for the duration of the statistic operation. For more information, see Configure the max degree of parallelism Server Configuration Option. Use MAXDOP to limit the number of processors used in a parallel plan execution. The maximum is 64 processors.

max_degree_of_parallelism can be:

1 Suppresses parallel plan generation.

>1 Restricts the maximum number of processors used in a parallel statistic operation to the specified number or fewer based on the current system workload.

0 (default) Uses the actual number of processors or fewer based on the current system workload.

Similar articles about new or updated articles

This section lists very similar articles for recently updated articles in other subject areas, within our public GitHub.com repository: MicrosoftDocs/sql-docs.

Subject areas that do have new or recently updated articles

Subject areas that do not have any new or recently updated articles