SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Scripts with tags SQL Server 2005, Administration, Maintenance and Management, Search, T-SQL Rss

Refine your search with one of the following additional tags (with number of items):

T-SQL Aids (6)     Utility (4)     column (1)     sys.foreign_key_columns (1)    
SQL 2005 (4)     Search Tables (3)     Search Columns (1)     sys.foreign_keys (1)    
tables (4)     Maintenance (2)     Search Stored PRocedures (1)     sys.sql_modules (1)    
TSQL (4)    

Search for any content tagged SQL Server 2005 & Administration & Maintenance and Management & Search & T-SQL

Add a script

   Items 1 to 6 of 6   
 

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.  Read more...
By Jesse Roberge 2008/12/05 | Source: SQLServerCentral.com | Category: Administration
Rating: (not yet rated) |  Discuss |  Briefcase | 33 reads

The Ultimate Table Searcher Mk2

Searches for tables who's names contain the search string. Gives Aggregate Size, Rows, Index, and Column information as well.  Read more...
Rating: (not yet rated) |  Discuss |  Briefcase | 38 reads

The Ultimate Table Searcher

Searches for tables who's names contain the search string. Gives Size and Rows information as well.  Read more...
By Jesse Roberge 2008/10/30 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 1,004 reads

The Ultimate Column Searcher

Searches for columns with names containing @Colname that belong to tables with names containing @TableName or schemas with names containing @SchemaName. Gives size and rowcount for tables.  Read more...
Rating: (not yet rated) |  Discuss |  Briefcase | 305 reads

The Ultimate Foreign Key Researcher

Searches for actual and potential foreign key columns for a given primary key reference.  Read more...
By Jesse Roberge 2008/08/15 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 981 reads

The Ultimate Precompiled Procedure Searcher

Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.  Read more...
By Jesse Roberge 2008/08/29 | Source: SQLServerCentral.com | Category: SQL Server 2005
Rating: |  Discuss |  Briefcase | 836 reads
   Items 1 to 6 of 6