Introduction to Common Table Expressions
Learn how to use common table expressions to simplify your code. Replace temp tables and correlated subqueries with this cool T-SQL feature.
2009-12-08
15,222 reads
T-SQL
2009-12-07
3,675 reads
2009-12-04
3,447 reads
2009-12-03
4,614 reads
2009-12-02
3,635 reads
Get Rid of Duplicates!
This article contains instructions on how to use some of my favorite methods to remove duplicate fields from a table.
2009-11-30
13,600 reads
Synchronize all stored procedures between two servers
This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure.
2009-12-15 (first published: 2009-11-26)
2,193 reads
2009-12-23 (first published: 2009-11-26)
593 reads
2009-12-18 (first published: 2009-11-26)
596 reads
Synchronize several stored procedure between two servers
Synchronize source code between two servers for multiple stored procedures
2009-12-21 (first published: 2009-11-26)
2,254 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers