Find a string in compiled objects
This utility will find strings in procedures, functions, views, and even check constraints.
2008-10-31
489 reads
Scripts
Insertion and Deletion by using Partition
for huge data insertion and deletion by avoiding locking you can use partition tables.
2008-10-28
839 reads
2008-10-28 (first published: 2008-07-25)
4,068 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,105 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
842 reads
2008-10-24
765 reads
The Ultimate Prospective-Index Column(s) Selectivity Analyzer
Gets single-column and cumulative-column selectivity stats and @Top largest dupe sets for each cumulative column stepping for a set of one or more columns for a table.
2008-10-24 (first published: 2008-08-01)
2,185 reads
2008-10-23
1,491 reads
2008-10-23 (first published: 2008-08-24)
1,943 reads
2008-10-22
1,350 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
Layanan BCA KCP Radio Dalam +62 838-4945-0961
WhatsApp:0817819444 Jl. Radio Dalam Raya No.5 B-C, RT.9/RW.13, Gandaria Utara, Kec. Kby. Baru, Kota...
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers