/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 sqlserverfast.com
Plansplaining part 23 / T-SQL Tuesday 168 - Window functions - SQLServerFast
| | pbidax.wordpress.com
Introducing DAX Window Functions (Part 1) - pbidax
17.8 parsecs away

Travel
| | The December 2022 release of Power BI Desktop includes three new DAX functions: OFFSET, INDEX, and WINDOW. They are collectively called window functions because they are closely related to SQL window functions, a powerful feature of the SQL language that allows users to perform calculations on a set of rows that are related to the...
| | avestura.dev
Explaining The Postgres Meme
22.2 parsecs away

Travel
| | Have you seen this legendary SQL iceberg meme? Let's talk about it while wearing our PostgreSQL hat!
| | matthewmcgiffen.com
Avoid "Constants" in T-SQL - Matthew McGiffen Data
20.0 parsecs away

Travel
| | Here we look at a common query "anti-pattern" that can create performance problems - and how you work around it.
| | rcoh.me
Postgres Indexes Under the Hood
38.6 parsecs away

Travel
| Many software engineers use database indexes every day, but few of us really understand how they work. In this post I'll explain: How indexing works in Postgres using B-Trees What B-Trees are Why they are a good fit for this problem Indexes in Postgres Postgres actually offers 4 different kinds of indexes for different use cases. In this post I'll be focusing on the "normal" index, the kind you get by default when you run create index.