New T-SQL Fixed Width "Splitter"
A brand new tally table based, fixed width "splitter" that can be used for much more than just string splitting
2016-06-22 (first published: 2016-05-14)
1,964 reads
Scripts
Script to Find String in Database object
Script that searches every object in a database for a specific string.
2016-06-20 (first published: 2016-05-02)
1,038 reads
Query to find tables with Forwarded Records
Use below query to find tables that need to be optimized based on number of forwarded records.
2016-06-16 (first published: 2016-05-05)
597 reads
2016-06-14 (first published: 2016-05-02)
1,861 reads
Data Sample Scripter
Generates code for INSERTs as well as generating data form tables for INSERT. Will also find and script all dependencies recursively, present all scripts in dependency order, and generate a reverse-dependency order set of conditional DELETE statements.
2016-06-13 (first published: 2015-06-04)
2,154 reads
PatExclude8K
Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)
2016-06-10 (first published: 2014-10-27)
4,524 reads
Log and report on table growth for trending
Log and report on table growth for trending, so you can track exactly which table(s) are your hotspots for growth.
2016-06-09 (first published: 2016-05-05)
1,776 reads
2016-06-08 (first published: 2016-04-28)
911 reads
Table Comparison Procedure
Procedure to compare two tables , getting table names and rows to display
2016-06-07 (first published: 2016-05-06)
1,047 reads
Replication-Quick way to determine the articles
Replication related script- quick way to determine the publication name, Article and column which are part of the different publications.
2016-06-06 (first published: 2016-05-09)
875 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
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...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers