2011-12-20 (first published: 2010-05-19)
10,682 reads
2011-12-20 (first published: 2010-05-19)
10,682 reads
2011-12-15 (first published: 2010-05-12)
10,026 reads
2011-12-13 (first published: 2010-05-05)
10,829 reads
2011-12-08 (first published: 2010-04-21)
10,861 reads
2011-12-06 (first published: 2010-04-14)
10,333 reads
2011-12-01 (first published: 2010-04-07)
9,971 reads
2011-11-29 (first published: 2010-03-31)
9,930 reads
2011-11-24 (first published: 2010-03-24)
10,571 reads
2011-11-22 (first published: 2010-03-17)
10,464 reads
2011-11-17 (first published: 2010-03-10)
7,993 reads
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...
By Zikato
In SQL Server, using the KILL command to terminate a session results in an...
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