Azure SQL Database Elastic Scale Part 1 - What is Sharding?
Azure SQL Database Elastic Scale Part 1 - What is Sharding?MARCH 19, 2015
This week, Microsoft introduced an update to Azure SQL...
2019-08-09 (first published: 2015-03-19)
15,392 reads
Azure SQL Database Elastic Scale Part 1 - What is Sharding?MARCH 19, 2015
This week, Microsoft introduced an update to Azure SQL...
2019-08-09 (first published: 2015-03-19)
15,392 reads
Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the ShardsMAY 28, 2015
For those of you who have...
2019-08-09 (first published: 2015-05-28)
4,009 reads
Dynamic Data MaskingFEBRUARY 26, 2015
Have you ever wanted to only show parts of a field to certain sets of users...
2019-08-09 (first published: 2015-02-26)
8,817 reads
Index Fragmentation in Azure SQL DatabaseFEBRUARY 4, 2015
Recently, I read the articles Stop Worrying About SQL Server Fragmentationand When Does...
2019-08-09 (first published: 2015-02-03)
13,300 reads
Setting Up Alerts in Azure SQL DatabaseSEPTEMBER 8, 2015
Introduction
If I've learned one thing with my on premise versions of SQL...
2019-08-09 (first published: 2015-09-08)
3,584 reads
SQL Azure has T-SQL Jobs - Well AlmostJUNE 25, 2015
Introduction
One thing that has been lacking in Azure SQL Database is the...
2019-08-09 (first published: 2015-06-25)
2,817 reads
Using AzCopy in a SQL Job to Upload Files to Azure Blob StorageNOVEMBER 11, 2015
Introduction
In my next series of posts,...
2019-08-09 (first published: 2015-11-10)
6,535 reads
Top 10 Enhancements to Azure SQL Database in 2015DECEMBER 27, 2015
Introduction
2015 has been a massive year for Azure SQL Database....
2015-12-27
995 reads
Top 10 Enhancements to Azure SQL Database in 2015
DECEMBER 27, 2015
Introduction2015 has been a massive year for Azure SQL Database. This year has seen the product mature from "an...
2015-12-27
11 reads
Getting Started with Azure Data Factory - Part 1DECEMBER 9, 2015
Introduction
The Azure Data Factory is a means of moving data around...
2015-12-09
4,097 reads
By Zikato
In SQL Server, using the KILL command to terminate a session results in an...
In today’s data-driven world, having the right tools to manage and process large datasets...
By Steve Jones
flichtish – adj. nervously aware how much of your self-image is based on untested...
Comments posted to this topic are about the item Kubernetes is Cool, But ...
Comments posted to this topic are about the item Multiple Query Trace Flags
Comments posted to this topic are about the item How Big Data Supports Gen...
I want to enable two trace flags, 4199 and 4137, for a single query. How should I do this:
-- A SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, 4137); -- B SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, QUERYTRACEON 4137); -- C SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199), (QUERYTRACEON 4137);See possible answers