2012-01-18
3 reads
2012-01-18
3 reads
2011-08-24
2 reads
What are the most influential papers in the world of Big Data? Let me suggest:...
2011-05-30
3 reads
2011-05-02
2 reads
2011-02-02
4 reads
2011-01-05
2 reads
I searched the internet for “connect and forget”. Wonderbox.net offer is described as a...
2010-10-10
2 reads
10 years ago IT professionals considered database technology “mature” and analysts were preparing to...
2010-09-13
4 reads
“The information age is an idea that the current era will be characterized by the ability of...
2010-08-22
1 reads
“Content is king” is the golden rule of the SEO. The semantic web is all about data. Any web...
2010-06-25
7 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 as you can see at https://www.sqlservercentral.com/forums/topic/test-sql-servers#post-4422832 we would really like multiple instances in...
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...
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