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,026 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
814 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,635 reads
2008-10-23
1,453 reads
2008-10-23 (first published: 2008-08-24)
1,915 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Inspection And Auditing | FARE Labs Pvt. Ltd.
At FARE Labs Pvt. Ltd., our inspection and auditing services focus on precision, quality...
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers