Unlock the power of SQL's NTILE function with our latest deep-dive article. Learn to segment your data effectively into quantiles for more nuanced analysis, discover common pitfalls and their solutions, and optimize your queries for peak performance.
2024-02-03 (first published: 2024-01-03)
4,676 reads
Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.
2023-12-11
7,450 reads
Welcome to the fascinating world of SQL window functions! Today, we'll explore in detail: RANK() and DENSE_RANK().
2023-11-20 (first published: 2023-11-15)
10,850 reads
By Steve Jones
This Friday is the NYC DevOps Devour hour, which is actually 3 hours. Plus...
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...
By Steve Jones
Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...
Hi, I'm trying to make the below query SARGable by removing the ISNULL function...
We're about to upgrade our SQL 2017 Standard to 2022 standard. We have 1...
Comments posted to this topic are about the item Script-Drop Orphan users from SQL...
What is the minimal number of parameters to add a linked server with sp_addlinkedserver?
See possible answers