Skip to primary content
Skip to secondary content

All About Data

All About Data

Main menu

  • Microsoft Azure
  • Microsoft Azure Videos
  • SQL Server
  • Get In Touch
  • Presentations
  • Snowflake

Tag Archives: MAXDOP

Azure SQL DB Maxdop Hint

Posted on June 25, 2019 by blobeater
3

I had a good question from JP via a comment on my blog about whether you can use the MAXDOP query hint in Azure SQL Database. The answer? Yes.

Continue reading →

Share this:

  • Tweet
  • Print
  • Email
  • WhatsApp

Like this:

Like Loading...
Posted in Azure, Azure SQL DB | Tagged MAXDOP, SQL database | 3 Replies

MAXDOP and Azure SQL DB

Posted on September 12, 2018 by blobeater
5

The infamous setting that we all know and love – MAXDOP. Did you know that you can actually control MAXDOP when using Azure SQL Database? You might not be able to tinker with the Cost Threshold for Parallelism setting but you sure can with MAXDOP.

Continue reading →

Share this:

  • Tweet
  • Print
  • Email
  • WhatsApp

Like this:

Like Loading...
Posted in Azure, Azure SQL DB | Tagged MAXDOP, SQL database | 5 Replies

Azure SQL Database and Cost Threshold for Parallelism

Posted on March 16, 2018 by blobeater
3

We all know that the magic figure for cost threshold for parallelism is 5 by default, meaning if the estimated cost of a query is greater than 5 it may very well generate a parallel plan.

Does this apply to Azure SQL Database? Let’s check.

Continue reading →

Share this:

  • Tweet
  • Print
  • Email
  • WhatsApp

Like this:

Like Loading...
Posted in Azure, Azure SQL DB | Tagged MAXDOP, TSQL | 3 Replies

Archives

Enter your email address below.

Blog Stats

  • 445,354 hits

Hot Topics

  • SQL Server Encryption in progress stuck
  • Getting intimate with Brent Ozar (The First Responder Kit)
  • Azure SQL DW – Let’s Shuffle?
  • The dark side of Fn_dump_dblog
  • Azure SQL Database Restore to different server
  • Backup and Restore Options for Azure SQL DB
  • Azure SQL Managed Instance - Cost Saving!
  • Azure DB for MySQL – Single server vs Flexible
  • Tempdb settings in SQL Server 2016
  • Azure SQL Managed Instance CPU and RAM

Categories

  • Azure
    • AKS
    • Always Encrypted
    • Apps
    • Azure DWH
    • Azure SQL DB
    • Azure Video Clips
    • Azure-TDE
    • Databricks
    • DMVs
    • Elastic Pool
    • Managed Instances
    • MySQL
    • Snowflake
  • BLOBEATER
    • About Me
    • General
    • Personal
    • Training
  • Other
    • DevOps
  • Power BI
  • SQL SERVER
    • Admin
    • Backup & Recovery
    • CHECKDB
    • Corruption
    • DBCC
    • Extended Events
    • General TSQL
    • Indexes
    • memory
    • QueryStore
    • SQL Server 2016
    • SQL Server 2017
    • SQL Server Video Clips
    • SSMS
    • TDE
    • vNext
  • T-SQL Tuesday
  • Waits&Latches

SQL Server Quick Video Clips

  • Get In Touch
  • Microsoft Azure Videos
  • Presentations
  • SQL Server Video Library

Follow me on Twitter

My Tweets

Social Media

  • View blobeater1’s profile on Twitter
  • View ASirpal’s profile on LinkedIn
  • View Arun Sirpal’s profile on Google+

Blog Tags

  • 2016
  • About Me
  • adaptive query processing
  • Admin
  • AKS
  • AlwaysEncrypted
  • Automatic Tuning
  • Azure
  • Azure Portal
  • Azure SQL DB
  • Azure SQL DWH
  • Azure Storage
  • backups
  • Brent Ozar
  • bytes
  • CHECKDB
  • Cloud
  • Code
  • Columnstore
  • compression
  • Config
  • Corruption
  • CosmosDB
  • costs
  • CPU
  • Databases
  • Databricks
  • DBA
  • DBCC CHECKDB
  • DBCC Page
  • Deadlock
  • DTU
  • Editions
  • Elastic Jobs
  • Elastic Pool
  • Encryption
  • Execution plans
  • Extended Events
  • Failover Groups
  • Filegroups
  • fn_dump
  • HyperScale
  • IaaS
  • Indexes
  • Install
  • Interleaved Execution
  • Internals
  • Locking
  • Logic Apps
  • Logins
  • Managed Instance
  • Managed Instances
  • MAXDOP
  • memory
  • Microsoft
  • Migration
  • MySQL
  • NOLOCK
  • offline
  • Personal
  • physloc
  • plan cache
  • PowerShell
  • QueryStore
  • readpast
  • Resources
  • RID
  • Scaling
  • Security
  • Shrink
  • SLA
  • Snowflake
  • SQL
  • SQL database
  • SQLDB
  • SQL server
  • SQL Server 2014
  • SQL Server 2016
  • SQL Server 2019
  • SQL Server vNext
  • SQLskills
  • SQL Trace
  • SSMS
  • StackTrace
  • statistics
  • Storage
  • Target vs Total
  • TDE
  • Technology
  • Tempdb
  • Training
  • Transaction Isolation Level
  • TSQL
  • TSQL Tuesday
  • Tuning
  • vCore
  • Video
  • Virtual
  • VMs
  • waits

Translate Here!

Blog at WordPress.com.
  • Follow Following
    • All About Data
    • Join 191 other followers
    • Already have a WordPress.com account? Log in now.
    • All About Data
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
%d bloggers like this: