SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tag tables Rss

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

Administration (8)     computed column (2)     foreign keys (1)     multi process (1)    
SQL Server 2005 (7)     CLR functions (1)     Index Management (1)     Performance (1)    
T-SQL (7)     CLR Stored Procedures (1)     Indexed Views (1)     Performance Tuning (1)    
Maintenance and Management (6)     CLR UDT (1)     Indexes (1)     SQL Server Management Studio (SSMS) (1)    
Search (6)     column (1)     Locking (1)     Storage (1)    
T-SQL Aids (6)     columns (1)     Management Studio (1)     Stored Procedures (1)    
Utility (6)     DBA (1)     Miscellaneous (1)     TSQL (1)    
Video (3)     foreign key constraints (1)    
   Items 1 to 16 of 16   
 

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 2009/10/20 | Source: SQLServerCentral.com | Category: Administration
Rating: (not yet rated) |  Discuss |  Briefcase | 701 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 2009/10/16 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 1,079 reads

The Ultimate Index-Less Foreign-Key Finder

Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.  Read more...
By Jesse Roberge 2009/10/15 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 516 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 0001/01/01 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 1,932 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.  Read more...
By Jesse Roberge 2009/10/06 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 600 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.  Read more...
By Jesse Roberge 0001/01/01 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 918 reads

Adding a Computed Column to a Table (2) - SQL School Video

Part 2 of how to add a computed column to a table. MVP Andy Warren narrates this SQL School video.  Read more...
By Andy Warren 2009/06/25 | Source: SQLServerCentral.com | Category: Video
Rating: |  Discuss |  Briefcase | 1,538 reads

Adding a Computed Column to a Table (1) - SQL School Video

In this SQL School video, Andy Warren shows how you can alter a table to add a computed column. This is part 1 of 2.  Read more...
By Andy Warren 2009/06/23 | Source: SQLServerCentral.com | Category: Video
Rating: |  Discuss |  Briefcase | 1,576 reads

Creating and Modifying Tables in SSMS - SQL School Video

Learn how to use the SSMS GUI to modify tables in this SQL School video.  Read more...
By Andy Warren 2009/03/03 | Source: JumpStartTV | Category: Video
Rating: |  Discuss |  Briefcase | 1,307 reads

Find Text in all columns of all tables in a Database

Will find the Table Name, Column Name and the number of occurances some text appears in a database.  Read more...
By Joshua A. Walker 2009/02/24 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 3,471 reads

Table Information View -- No Cursors!

Row counts and storage space information for all tables in the database. (SQL Server 2005)  Read more...
By RBarry Young 0001/01/01 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |  Briefcase | 12,713 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.  Read more...
By Jesse Roberge 0001/01/01 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 918 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 0001/01/01 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 1,932 reads

Get Tables by column name

This script lists all the tables which has the specified column name.  Read more...
Rating: |  Discuss |  Briefcase | 441 reads

Switching tables

Switching tables describe the scenario of 2 tables containning data; while making a process on one tables the other table can continue and function in front of some application.  Read more...
By tomer lev 2008/09/05 | Source: SQLServerCentral.com | Category: Locking
Rating: |  Discuss |  Briefcase | 671 reads

Table Information View -- No Cursors!

Row counts and storage space information for all tables in the database. (SQL Server 2005)  Read more...
By RBarry Young 0001/01/01 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |  Briefcase | 12,713 reads
   Items 1 to 16 of 16   
 
Most popular

Table Information View -- No Cursors!

Row counts and storage space information for all tables in the database. (SQL Server 2005)  Read more...
By RBarry Young 0001/01/01 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |  Briefcase | 12,713 reads

Find Text in all columns of all tables in a Database

Will find the Table Name, Column Name and the number of occurances some text appears in a database.  Read more...
By Joshua A. Walker 2009/02/24 | Source: SQLServerCentral.com | Category: Miscellaneous
Rating: |  Discuss |  Briefcase | 3,471 reads

Adding a Computed Column to a Table (1) - SQL School Video

In this SQL School video, Andy Warren shows how you can alter a table to add a computed column. This is part 1 of 2.  Read more...
By Andy Warren 2009/06/23 | Source: SQLServerCentral.com | Category: Video
Rating: |  Discuss |  Briefcase | 1,576 reads