Does Your GROUP BY Order Matter?
Sometimes when you do GROUP BY, the order of the columns does matter. For example, these two SELECT queries produce different results:
Sometimes when you do GROUP BY, the order of the columns does matter. For example, these two SELECT queries produce different results:
Management is important to ensuring the success of a team. Steve talks about an anti-pattern that is often used by poor managers.
An updatable view in SQL Server is a view that allows modifications such as INSERT, UPDATE, or DELETE operations on the underlying tables through the view.
Container orchestration has become a cornerstone of modern application deployment. For beginners stepping into the world of modern application deployment and orchestration, understanding the essence and significance of Kubernetes is essential.
I want to make this a participation topic. When you are working, do you listen to music or do you need quiet? And if it isn’t music, do you do something else? TV, movies? For me, it is almost always music. As I write my first Database Weekly newsletter editorial in a few months, I […]
In this article, we discuss market-based analysis techniques for customer purchasing patterns for different products over the years in Power BI.
Pagination is a technique for limiting output. Think of Google search results, shopping the electronics category on Amazon, or browsing tagged questions on Stack Overflow. Nobody could consume all of the results in a single shot, and no site wants to spend the resources required to present them all to us
Learn how to perform full and incremental loads in Fabric with a little SparkSQL.
Steve talks about being back in an office today, at a customer where everyone comes in every day.
By Zikato
In SQL Server, using the KILL command to terminate a session results in an...
In today’s data-driven world, having the right tools to manage and process large datasets...
By Steve Jones
flichtish – adj. nervously aware how much of your self-image is based on untested...
I have few snapshot transactions , now my admin has informed me that put...
Comments posted to this topic are about the item Kubernetes is Cool, But ...
Comments posted to this topic are about the item Multiple Query Trace Flags
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