Social Networking in the SQL Server Community
Like many SQL Server (and other technology) people, I utilize several social networking vehicles to stay in touch with others...
2009-07-20
1,847 reads
Like many SQL Server (and other technology) people, I utilize several social networking vehicles to stay in touch with others...
2009-07-20
1,847 reads
We are in the early stages of planning a SQL Saturday event in the Dallas area for January or February...
2009-07-19
1,071 reads
I read a post on Brent Ozar’s blog last week that discussed employers’ expectations when hiring new team members. Though the story was specific to database professionals, the same principles apply to almost any hiring situation. The moral of Brent’s story...
2009-07-16
1,541 reads
I read a post on Brent Ozar’s blog last week that discussed employers’ expectations when hiring new team members. Though...
2009-07-13
599 reads
I like my main laptop. It’s big and wide and bright, with lots of power and all of the bells...
2009-07-11
1,388 reads
Have you ever noticed unexpected gaps in sequences in IDENTITY columns? Even though you’ve got transactions set up for your inserts and a no-deletion policy, you find that there are missing values in what should be an unbroken sequence of numbers. The problem could be partially related to transaction rollbacks.
2009-07-09
4,586 reads
I'll be presenting two sessions at the SQL Saturday event in Baton Rouge on August 1. I'll be presenting a...
2009-07-06
476 reads
Have you ever noticed unexpected gaps in sequences in IDENTITY columns? Even though you’ve got transactions set up for your...
2009-07-01
9,919 reads
For those in or around the Dallas area tomorrow (Thursday) evening, I'll be speaking at the North Texas SQL Server...
2009-06-17
784 reads
I received my notification from the PASS Program Committee on Friday evening,
and found out that I will not be...
2009-06-15
592 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