Master Data Services stops working after an upgrade
Recently some SQL Server instances at a client were upgraded to the latest cumulative update of SQL Server 2012 service...
2013-11-27
2,636 reads
Recently some SQL Server instances at a client were upgraded to the latest cumulative update of SQL Server 2012 service...
2013-11-27
2,636 reads
Last week was the 2013 edition of the SQL Server Days. It was an amazing event: there was a great...
2013-11-13
1,128 reads
Last week was the 2013 edition of the SQL Server Days. It was an amazing event: there was a great...
2013-11-13
651 reads
This blog post will not be about Bob Dylan, but rather about some professional changes/challenges I’ve been up to lately.
The...
2013-10-29
491 reads
This blog post will not be about Bob Dylan, but rather about some professional changes/challenges I’ve been up to lately.
The...
2013-10-29
738 reads
I’m very thrilled to be selected again as a speaker for the sixth edition of the SQL Server Days! The...
2013-10-15
412 reads
I’m very thrilled to be selected again as a speaker for the sixth edition of the SQL Server Days! The...
2013-10-15
758 reads
Recently I ran across a forum thread where someone encountered an unexpected result when creating a directory using the File...
2013-10-09
631 reads
Recently I ran across a forum thread where someone encountered an unexpected result when creating a directory using the File...
2013-10-09
348 reads
After over 6 months of silence, it is time again for another Stupid me™®©! For those unfamiliar with the concept:
Every...
2013-10-01
351 reads
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,...
By Brian Kelley
Just as it's important to take care of our physical health (and I'm guilty...
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...
We are seeing multiple frequent deadlocks occurring with the following extract of code, which...
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