Advanced T-SQL: Replacing Slow Cursors with Window Functions
This article looks at replacing a cursor with a window function to improve performance.
2026-08-03
4,699 reads
Articles
Database Animations: You’ve Heard of Page Splits. Here’s What They Really Mean.
You've heard that page splits are bad, and they're an indication that your table design is making your storage work too hard. You've heard that the right answer to fix it is adjusting fill factor lower, or doing regular index maintenance.
2026-08-03
Why SQL Server Database Attach fails and how to repair it
This article covers a few common errors when attaching database files to an instance, with some information on how to resolve the issues.
2026-07-31
869 reads
Big data: what it is, why projects fail, and how to get value from it
Although ‘Big Data’ (and more specifically, the analysis of it) offers several benefits, organizations often fail to derive the correct insights – the data that could help them make better business decisions. So, in this article, I’ll reveal exactly how organizations can take full advantage of these large datasets to make those better business decisions and improve operational effectiveness.
2026-07-31
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
From bloated error logs to risky logon triggers, a guide to auditing connections without killing performance.
2026-07-29
1,910 reads
Time Series Data Mining Example with T-SQL when Adding New Data
Please demonstrate the steps for updating an existing time series dataset used in a prior data mining project with a fresh batch of data. Then, repeat the mining performed for the original dataset with the freshly updated dataset.
2026-07-29
CROSS APPLY Fundamentals: Part 1
Learn the basics of the CROSS APPLY operator with a few examples in this short piece.
2026-07-27
3,475 reads
5 T-SQL features that should already exist (2026 SQL Server wish list)
2026 T-SQL wish list covering native Parquet imports, arrays, OVERLAPS, simpler licensing, and cloud storage
2026-07-27
SQL Agent Job Automated Change Capture Process
Build a process that captures your SQL Agent job history and changes across time.
2026-07-24
1,401 reads
SQL Server Data Warehouse Concepts, Schema Design, and Implementation
A Data Warehouse acts as a centralized repository, is subject oriented, time variant and non-volatile repository. This article covers some concepts that will help you better design these structures.
2026-07-24
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...