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,232 reads
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,232 reads
Searches for actual and potential foreign key columns for a given primary key reference.
2009-10-12 (first published: 2008-06-20)
2,494 reads
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,886 reads
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,167 reads
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,117 reads
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,302 reads
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,466 reads
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)
576 reads
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,188 reads
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,044 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Comments posted to this topic are about the item One more reason to use...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers