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 26    Older >>
 

Quickly Investigating What's in the Tables of SQL Server Databases

From SQL Server Management Studio it's hard to look through the first few rows of a whole lot of tables in a database. This is odd, since it is a great way to get quickly familiar with a database. Phil tidied up a SQL routine he uses to investigate databases quickly in a browser. He explains how to use it, how it works, and how to use it from PowerShell.  Read more...
By Additional Articles 2014/08/20 | Source: SimpleTalk | Category: tables
Rating: (not yet rated)  Rate this |   Briefcase | 9,725 reads

SQL Server Tables - 11 Questions You Were Too Shy to Ask

There are some aspects of tables in SQL Server that a lot of people get wrong, purely because they seem so obvious that one feels embarrassed about asking questions. Robert Sheldon reckons that no questions about SQL Tables are off-limits, and deserve frank answers.   Read more...
By Additional Articles 2014/07/03 | Source: SimpleTalk | Category: tables
Rating:  Rate this |   Briefcase | 8,564 reads

On Comparing Tables in SQL Server

How do you compare two SQL tables? Every SQL Developer or DBA knows the answer, which is 'it depends'. It is not just the size of the table or the type of data in it but what you want to achieve. Phil Factor sets about to cover the basics and point out some snags and advantages to the various techniques.  Read more...
By Additional Articles 2014/06/10 | Source: SimpleTalk | Category: comparison
Rating:  Rate this |   Briefcase | 5,280 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,908 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,429 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,655 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 | 997 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,908 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 R Dedhia 2012/10/02 | Source: SQLServerCentral.com | Category: primary key (pk)
Rating: |  Discuss |   Briefcase | 1,349 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,429 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 | 849 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,368 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,310 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,206 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,103 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,094 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,976 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,267 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,976 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,429 reads
   Items 1 to 20 of 26    Older >>
 
Tags
administration (9)    
sql server 2005 (7)    
t-sql (7)    
maintenance and management (6)    
search (6)    
utility (6)    
columns (3)    
video (3)    
computed columns (2)    
storage (2)    
comparison (1)    
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)