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)
5,197 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
10,649 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)
15,599 reads
This article compares the performance of finding the most recent row in a child table for updates, looking at four possible solutions.
2023-07-10
3,756 reads
You can master engineering for your SQL Server databases, on premises or in the cloud, with a FREE toolkit!
2022-10-28
4,750 reads
Here's why you should NEVER use the FORMAT() function in SQL Server.
2022-08-05
21,632 reads
Introduction to Query history and server reports i...
2022-03-14
9,809 reads
It’s not difficult to set up an extended event session, but reviewing and saving the data can be complex. In this article, Edward Pollack demonstrates how to collect extended event data.
2021-11-03
SQL Server perfmon counters provide a wealth of information about performance. In this article, Fabiano Amorim shows how current wisdom about one counter, SQL Compilations/sec, can sometimes be misleading.
2021-08-20
SQL Server provides information for troubleshooting performance. Ed Pollack demonstrates collecting SQL Server performance monitor data.
2021-08-11
Both SQL Server and PostgreSQL are moving fast into AI territory — and if...
By Steve Jones
We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Comments posted to this topic are about the item Would You Retire Rather Than...
Comments posted to this topic are about the item Vector Search in SQL Server...
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers