Explore >> Select a destination
|
You are here 
|
explainextended.com | ||
| | | | |
matthewmcgiffen.com
|
|
| | | | | Here we look at a common query "anti-pattern" that can create performance problems - and how you work around it. | |
| | | | |
sqlserverfast.com
|
|
| | | | | I had to skip three months, but finally it is here: part eight of the plansplaining series. Each of these posts takes an execution plan with an interesting pattern, and details exactly how that plan works. I am pretty sure that (almost) everyone reading this blog knows that a CTE (Common Table Expression) is an... | |
| | | | |
jsloop.net
|
|
| | | | | Let's say our objective is to get latest one row by a given set of criteria. Means, say a person has multiple products and we want to get latest one product per person. For this what we need to do is partition the data by the required criteria. Here we will partition the data by person_id and product_type ordered by latest org_insert_dt. This will order the result by person and latest product. Then we use row_number() function which will assign unique, sequential integer to each partition in the result set. Which means the latest product for each person will get a 1. And we use a CTE (Common Table Expression), which is temporary named result set to store this relationship. Now if we need latest product per person, then we can query this CTE which is like a t... | |
| | | | |
www.kevinrchant.com
|
|
| | | For this months T-SQL Tuesday contribution I want to cover how I ended up using SemPy to view DAX in Microsoft Fabric. | ||
