Thinking about Pre-Cons In Orlando in 2019
In the spirit of “do more” we’re hoping to host at least 4 pre-cons in Orlando in 2019. Right now...
2018-11-27
250 reads
In the spirit of “do more” we’re hoping to host at least 4 pre-cons in Orlando in 2019. Right now...
2018-11-27
250 reads
A few weeks back I wrote Some Thoughts on How To Prepare to Serve on the PASS Board of Directors....
2018-11-20 (first published: 2018-11-11)
1,518 reads
This was the 20th PASS Summit, a decent milestone! Interesting to pause and think, what will the Summit look like...
2018-11-12
246 reads
It turns out that the 2019 Summit and Ignite will be held the same week in 2019, see this post...
2018-11-02 (first published: 2018-10-23)
2,341 reads
I was disheartened to read the post that shows we have three candidates for three positions this year. Started with...
2018-11-02
302 reads
From time to time I’m asked for advice and insight on running for and serving on the PASS Board. I...
2018-10-22
247 reads
We wrapped up our 12th SQLSaturday here in Orlando two weeks ago. Overall things went well. Registration was just a...
2018-10-20
250 reads
Notes:
30 registered, 11 attended. No weather or traffic issues. Same as the last meeting we did not send a day...
2018-09-25
244 reads
Sharing this before I forget, Idera is taking applications for their 2019 ACE Program. If you’re wanting to do more...
2018-09-19
756 reads
I just spent a few more minutes looking at the FY 2019 budget. It is hard to assess whether it’s...
2018-09-14 (first published: 2018-09-04)
1,522 reads
Ready to dive into the world of SQL? Whether you're dreaming of a lucrative...
This comic was retweeted into my timeline on Twitter (I refuse to call it...
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it,...
Hi everyone, I have been asked to investigate storing Excel files in Sql Server...
My agency has been using the combo of on-premises SQL Server for the back...
Development Environment I am learning how to use pyodbc and accessing database in SQL...
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