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

Content with tags T-SQL, SQL Server 7, 2000, Miscellaneous, Basic Querying, Administering Rss

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

Configuring (3)     Monitoring (2)     Best and Worst Practices (1)     Replication (1)    
Installation (3)     Programming (2)     Distributed Queries (1)     UpdateGrams (1)    
Stored Procedures (3)     Security (2)     English Query (1)     Visual Basic 6 (1)    
Backup and Recovery (2)     Triggers (2)     OpenXML (1)     Worst Practices (1)    
Database Design (2)     User-Defined functions (2)     Performance Tuning (1)     XML (1)    
DTS (2)     Basics (1)     Performance Tuning and Scaling (1)     XSL (1)    
Indexing (2)    
   Items 1 to 7 of 7   
 

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first posted: 2002/02/11) | Source: SQLServerCentral.com | Category: Installation
Rating: |  Discuss |  Briefcase | 33,396 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: Installation
Rating: |  Discuss |  Briefcase | 17,518 reads

Managing Jobs Using TSQL

We've had a good run of jobs about job management lately, Randy sent us another one that looks at the job of job management and shows us how he tackled the problem.   Read more...
By Randy Dyess 2003/04/02 | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 18,751 reads

Worst Practice - Sorting by Ordinal

If you've been with us for a while you know that Andy started a series last year on worst practices. As he says, maybe you can't always do best practices, but at least dont do the worst ones. Read the article and add a comment, participate!   Read more...
By Andy Warren 2002/10/01 | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 6,914 reads

Review of SQL Server 2000 Programming (MSPress)

Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!   Read more...
By Andy Warren 2002/06/04 | Source: SQLServerCentral.com | Category: Installation
Rating: (not yet rated) |  Discuss |  Briefcase | 6,317 reads

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first posted: 2002/02/11) | Source: SQLServerCentral.com | Category: Installation
Rating: |  Discuss |  Briefcase | 33,396 reads

Understanding the Implications of ANSI SQL92 SET Options

Have you ever experienced a T-SQL query, a stored procedure, view or a trigger returning unexpected results. In this article by Raj Gill, he shows you how ANSI DEFAULTS may be to blame.   Read more...
By Raj Gill 2001/10/18 | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 8,845 reads
   Items 1 to 7 of 7