The Ultimate Table Searcher
Searches for tables who's names contain the search string. Gives Size and Rows information as well.
2009-10-14 (first published: 2008-08-01)
2,251 reads
Jesse Roberge
- Interests: Computers, Star Wars, Soccer, Jesus
The Ultimate Foreign Key Researcher
Searches for actual and potential foreign key columns for a given primary key reference.
2009-10-12 (first published: 2008-06-20)
2,513 reads
The Ultimate Precompiled Procedure Searcher
Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.
2009-10-08 (first published: 2008-06-20)
1,902 reads
The Ultimate Object Searcher
Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.
2009-10-06 (first published: 2009-09-22)
1,185 reads
The Ultimate PK-Less / CLIDX-Less Table Finder
Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.
2009-10-02 (first published: 2008-11-05)
1,131 reads
Prime Number Table Generator (new ver crunches to 1 Mil in <10.5 sec!)
Generates prime numbers and puts them into a table for future reference by adhoc queries and database and application code. 100% set-based. DDL embedded.
2009-07-20 (first published: 2009-07-03)
1,314 reads
Three Sample reports for the Automated DBA: Space Usage SnapShotter
1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot
2009-07-13 (first published: 2009-07-03)
2,469 reads
The Automated DBA: Batch Database File Grower - SQL 2000 Version
Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.
2009-06-25 (first published: 2009-06-08)
593 reads
The Automated DBA: Batch Database File Grower - SQL 2005 Version
Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.
2009-06-23 (first published: 2009-06-08)
1,202 reads
The Automated DBA: Batch Database File Grower - SQL2005 ReportOnly Ver
Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.
2009-06-22 (first published: 2009-06-08)
1,054 reads
Blogs
T-SQL Tuesday #191: Invitation–Your Favorite String Parsing
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Forums
The Improvement Limit
Comments posted to this topic are about the item The Improvement Limit
Migrate SSRS Reports to a New Server in Just a Few Clicks
Comments posted to this topic are about the item Migrate SSRS Reports to a...