StreamInsight: A new way to think about analyzing data
Last night’s Oregon SQL user
group meeting was very enlightening. Mark Simms form the SQLCAT team came
down from Redmond to talk...
2011-02-11
1,079 reads
Last night’s Oregon SQL user
group meeting was very enlightening. Mark Simms form the SQLCAT team came
down from Redmond to talk...
2011-02-11
1,079 reads
Something recently occurred to me. I’ve been researching chart and dashboard
design standards for an article I’m working on, and the...
2011-01-12
653 reads
I’ve recently come to realize what a truly remarkable feature it is to be able to
format report text using simple...
2011-01-11
755 reads
Last week Donald
Farmer announced that he was leaving his long-time position as Microsoft’s lead
BI technology evangelist for QlikTech, a small...
2011-01-11
699 reads
In concept, designing reports is such a simple thing… you connect to a data source,
write a SQL query, optimize the...
2011-01-05
940 reads
So I must confess that my blogging efforts to date have been on the impersonal side
– perhaps even a bit...
2010-12-31
1,443 reads
I hope everyone is enjoying the holidays. To everyone in the SQL Server community,
Merry Christmas and Happy New Year. Spend...
2010-12-27
961 reads
First of all, the title is intended to be
a little tongue-in-cheek – just a little bit. I’ll explain. Last week
while I...
2010-12-15
418 reads
A consulting client recently asked how they could resolve a capacity-planning issue
on their production report server. They manage a busy...
2010-12-15
638 reads
I’m interested in hearing your response to this question. Microsoft is investing
aggressively in delivering Business Intelligence as a holistic platform...
2010-11-24
528 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