SP to find the database usage
This SP helps you to find the data file/s and log usage for a given DB
2008-11-01
1,317 reads
Scripts
Find a string in compiled objects
This utility will find strings in procedures, functions, views, and even check constraints.
2008-10-31
435 reads
Insertion and Deletion by using Partition
for huge data insertion and deletion by avoiding locking you can use partition tables.
2008-10-28
788 reads
2008-10-28 (first published: 2008-07-25)
4,025 reads
Compare databases structure
This procedure is supposed to compare structure (tables, procedures, triggers, foraign keys etc.) of two specified databases.
2008-10-27 (first published: 2008-08-19)
3,077 reads
Are disk volumes fragmented on server? Does it require to be defragged
Disk Fragmentation is one of the cause of degraded performance. Use this script for fragmentation analysis report.
2008-10-24
813 reads
2008-10-24
746 reads
How to insert and update from remote linked server
Please read the how to use. unfortunately the orignal document i submitted was truncated 🙁
and i dont have time to remember what i said
2008-10-24 (first published: 2007-08-07)
2,634 reads
2008-10-23
1,452 reads
2008-10-23 (first published: 2008-08-24)
1,915 reads
Blogs
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...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
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...
Changing the AG Listener
Comments posted to this topic are about the item Changing the AG Listener
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