SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Blogs QotD SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us
 

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...
By Jesse Roberge | Source: SQLServerCentral.com | Category: Administration
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...
By Jesse Roberge | Source: SQLServerCentral.com | Category: Administration
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   
 
 
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use