I use Chat-GPT occasionally, instead of Google, to get answers to technical questions. However, I regard Chat-GPT as an indiscriminate conveyor of existing information, not artificial intelligence.
2023-08-30
The whole universe, the well-guarded people—may they all query databases together in a single language!
2022-08-13
205 reads
Git has proved to be a better fit to the needs and workflow of a database development team than anything that came before. Git is valuable because it encourages branching and merging, giving more choice in the way that your team can work. Due to the ease with which you can adapt Git, there is […]
2021-04-03
134 reads
2020-12-12
278 reads
If you're faced by an investigation team, after a data breach, it is no use putting on your 'Mr. Sincerity' face and making vague statements. They want documented facts.
2020-11-14
146 reads
Phil Factor's manual for taming machines, applications, and other wild beasts.
2020-10-17
113 reads
It is not existing knowledge but the skill of acquiring new knowledge rapidly that will help you overcome imposter syndrome.
2020-09-19
308 reads
One of the finest songs of the sixties had the following lines … "Sitting one day by myself, And I'm thinking, "What could be wrong?" When this funny little Hedgehog comes running up to me, And it starts up to sing me this song. Oh, you know all the words, and you sung all the […]
2020-08-22
354 reads
For those of you who haven’t heard of it, MVP stands for Most Valuable Professional. Microsoft gives this award to people in the community – not employees – who help teach the community at large about their products. The award can be given in one or more of the categories such as Data Platform, AI, […]
2020-08-08
160 reads
2020-06-27
190 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