Follow Up Notes on the Custom Whiteboard
A few months back I posted about our latest whiteboard and I thought I'd report back with an update. Initially...
2008-07-17
507 reads
A few months back I posted about our latest whiteboard and I thought I'd report back with an update. Initially...
2008-07-17
507 reads
Below is a list of various tools I use, some SQL related and some not. Follow the links to my...
2008-07-17
1,161 reads
Long time SSC participant Grant Fitchey has published a great book on reading/understanding execution plans. I finally had the chance...
2008-07-16
1,353 reads
The fourth annual Jacksonville Code Camp is set for August 23, 2008 and it looks like they are off to...
2008-07-15
461 reads
I ran across MentoringNet in a recent renewal flyer from ACM. I'm interesting in all things mentoring, so I went...
2008-07-14
1,001 reads
One of the things I use to identify how well a company is managed is by looking at how (well)...
2008-07-13
1,619 reads
My friend Steve Jones posted an article called What's an MVP on SSC that in turn led to a moderately...
2008-07-13
1,400 reads
SQLSaturday #5 in Olympia is progressing nicely. Greg, Russ, and team have locked in a venue and with registration just...
2008-07-11
395 reads
I did quite a bit of reading during a recent week off including two biographies. One was Boyd: The Fighter...
2008-07-10
383 reads
A couple weeks back I posted Employee or 1099 and now that my friend Wes Dumey has posted his last installment, I...
2008-07-09
311 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