Automating DBCC Page
Way back in 2006, Paul Randal documented DBCC PAGE on his Microsoft blog at http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/10/625659.aspx. In his post, you will...
2016-12-21
416 reads
Wayne Sheffield
- Website: http://www.waynesheffield.com
T-SQL Tuesday #85: Backup and Recovery
It’s that time of the month… the time when all of the T-SQL bloggers have a party and blog about...
2016-12-13
392 reads
Persisting DBCC output data
Most of the DBCC commands return their results as textual output, even if you have SSMS configured to return result...
2016-11-16
450 reads
Having fun with PARSENAME (SQL Spackle)
PARSENAME is perhaps the most infrequently used built-in documented function in SQL Server. SQL Server Microsoft Certified Master Wayne Sheffield shows why this nifty function ought to be included in your SQL toolbox.
2016-01-15 (first published: 2014-03-17)
23,211 reads
An Introduction to the SQLCMD Mode in SSMS (SQL Spackle)
Using SQLCMD Mode in SSMS is easy. This short piece will show you how to get started.
2015-10-16 (first published: 2013-05-06)
22,429 reads
The SQL Saturday Crazy Train hooks up a caboose!
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2015-07-20
753 reads
How do different types of functions compare performance wise?
A while back, I wrote a blog post showing the differences (including performance) between Inline Table-Valued Functions (ITVF) and Multi-Statement...
2015-07-16
1,056 reads
The Murder Train is pulling into Iowa City
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2015-05-11
570 reads
The new Analytic functions in SQL Server 2012
SQL Server expert Wayne Sheffield looks into the new T-SQL analytic functions coming in SQL Server 2012.
2015-05-01 (first published: 2012-01-19)
31,416 reads
T-SQL Tuesday #61 – The Wrap-Up
Earlier this month, I hosted the 61st occurrence of the monthly TSQL-Tuesday blogging party. With a topic of “Giving Back”,...
2014-12-31
1,374 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers