Find Invalid Objects in SQL Server
This article shows how you can find which objects in your database might not be valid after schema changes.
2025-10-06
8,598 reads
Advanced SQL
SQL Window Functions Series: NTILE()
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,875 reads
SQL Window Functions Series: RANK() and DENSE_RANK()
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)
12,803 reads
Exploring Parameter Sensitive Plan Optimization in SQL Server 2022
PSPO (Parameter Sensitive Plan Optimization) is a SQL Server feature that improves query performance by accepting varied data sizes based on the runtime parameter value(s) specified by the customer. It deals with the situation in which a single cached plan for a parameterized query isn't the best option for all potential incoming parameter values. Non-uniform data distributions exhibit this phenomenon. When using PSPO, SQL Server keeps several execution plans for a single query, each one customized for a particular parameter value. With the help of this feature, numerous execution plans for a parameterized query are generated, each of which is tailored for a certain range of parameter values.
2023-07-21
4,254 reads
Find Invalid Objects in SQL Server
This article shows how you can find which objects in your database might not be valid after schema changes.
2023-03-13
21,969 reads
How to Find the Start and End Dates for the Current Week (and more)
Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)
2022-07-13
33,199 reads
2019-10-28
7,182 reads
Create a Tally Function (fnTally)
Many people have published high performance, read-less, Inline Table Valued functions that use Itzik Ben-Gan's wonderful "Virtual Numbers Table" to replace WHILE loops and other forms of RBAR. This one is Jeff Moden's version.
2019-08-13 (first published: 2019-08-04)
7,619 reads
Stairway to Advanced T-SQL Level 3: Understanding Common Table Expressions (CTEs)
A CTE is a temporary result set defined by a simple query, and is used within the execution scope of a single INSERT, UPDATE, DELETE, or SELECT statement. In this article we will explore how to define and use CTE's.
2024-04-03 (first published: 2015-03-18)
6,417 reads
Create a Tally or Numbers Table
This creates a Tally or Numbers table which is frequently used to replace loops in code and is much faster than most loops.
2011-11-28 (first published: 2008-03-07)
6,692 reads
Blogs
Build a Snapshot Backup Catalog in Pure Storage - The SQL Server 2022 Edition
In my previous post, I showed you how to build a snapshot backup catalog...
Advice I Like: Training Employees
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Docker Advice for SQL Server in Production
Comments posted to this topic are about the item Docker Advice for SQL Server...
DevOps is DevOps
Comments posted to this topic are about the item DevOps is DevOps
Question of the Day
Striped Backup File Limits
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers