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

  • 430,227 hits

Hot Topics

  • Azure SQL Database - Error Logs?
  • Azure DB for MySQL – Single server vs Flexible
  • SQL Server - Reading BACPAC Files
  • WinDbg and SQL Server Fun
  • Azure SQL Managed Instance Versions
  • Azure SQL Database – The Default Isolation Is?
  • Azure SQL DB - Failed to update database because the database is read-only
  • SQL Server Backup / Restore from URL
  • SQL Server Encryption in progress stuck
  • Checking Time Zones in SQL Server

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: