Friends of Redgate 2015
Reading Time: 2 minutes
It’s official, I am in Friends Of Redgate for 2015!
Ok, the last few months have been an...
2015-01-27
814 reads
Reading Time: 2 minutes
It’s official, I am in Friends Of Redgate for 2015!
Ok, the last few months have been an...
2015-01-27
814 reads
Reading Time: 3 minutesPrimary Keys help keep your database in balance
Continuing the thoughts of knowing what is going on in...
2015-01-13
1,111 reads
Reading Time: 3 minutes
Have we given too much away?
SQL Server has an amazing community. It freely provides information and training...
2014-11-21
333 reads
Have we given too much away?
SQL Server has an amazing community. It freely provides information and training of SQL Server...
2014-11-21
611 reads
Reading Time: 8 minutesWinter is coming! Is your SQL Server ready?
There you sit, watching TV, when you hear it: “Analysts...
2014-11-14
630 reads
Winter is coming! Is your SQL Server ready?
There you sit, watching TV, when you hear it: “Analysts are predicting massive...
2014-11-14
1,062 reads
What Is The Point of Versioning?
How do you know change occurs in your database?
Now, I’m not talking about version control,...
2014-11-12 (first published: 2014-11-07)
6,979 reads
Reading Time: 4 minutes
What Is The Point of Versioning?
How do you know change occurs in your database?
Now, I’m not talking...
2014-11-07
635 reads
What Are Database Triggers?
Do you know what triggers lurk in your database?
Triggers can be implemented to enforce business rules or...
2014-11-05 (first published: 2014-10-24)
11,640 reads
Reading Time: 4 minutesThings are happening
or: Learning to Not Look a Gift Horse in the Mouth
The stars seem to have...
2014-11-02
402 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