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

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

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

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

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

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 | 27 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 | 32 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 | 989 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 | 299 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 | 971 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 | 823 reads
   Items 1 to 6 of 6