Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag tables Rss

   Items 1 to 20 of 23    Older >>
 

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 2013/12/26 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |   Briefcase | 15,834 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 2013/12/20 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,301 reads

List all tables and their respective information.

List all tables in a SQL Server database with the details of them.  Read more...
By Fernando Casas Osorio 2013/03/14 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |   Briefcase | 2,566 reads

Tables and rows listing

Simple script which create a list of all the tables and rows of the selected DB.  Read more...
By Claudio Tregambe 2013/02/11 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |   Briefcase | 967 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 2013/12/26 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |   Briefcase | 15,834 reads

Find Primary Column of all tables in database

This code helps in finding Primary Keys for all tables in a database.  Read more...
By Nitesh Dedhia 2012/10/02 | Source: SQLServerCentral.com | Category: primary key (pk)
Rating: |  Discuss |   Briefcase | 1,311 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 2013/12/20 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,301 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 2009/10/20 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 840 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,331 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 | 1,296 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 2009/10/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,190 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 | 1,081 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 2009/10/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,090 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 | 3,839 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 | 4,090 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 | 2,922 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 2013/12/20 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,301 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 2013/12/26 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |   Briefcase | 15,834 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 2009/10/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,090 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 2009/10/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,190 reads
   Items 1 to 20 of 23    Older >>
 
Tags
administration (9)    
sql server 2005 (7)    
t-sql (7)    
maintenance and management (6)    
search (6)    
utility (6)    
columns (3)    
video (3)    
computed column (2)    
storage (2)    
database (1)    
dba (1)    
foreign keys (fk) (1)    
indexed views (1)    
indexing (1)    
list (1)    
locking (1)    
management studio (ssms) (1)    
miscellaneous (1)    
multi process (1)    
performance tuning (1)    
primary key (pk) (1)    
sqlclr (1)    
stored procedures (1)    
table (1)