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

Content with tags T-SQL, Basic Querying, Configuring Rss

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

SQL Server 7, 2000 (8)     Indexing (2)     English Query (1)     Replication (1)    
Administering (5)     Security (2)     Monitoring (1)     Reviews (1)    
Installation (4)     Triggers (2)     OpenXML (1)     Service Packs (1)    
Miscellaneous (3)     User-Defined functions (2)     Performance Tuning (1)     UpdateGrams (1)    
Stored Procedures (3)     Basics (1)     Performance Tuning and Scaling (1)     Visual Basic 6 (1)    
Backup and Recovery (2)     Database Design (1)     Product Reviews (1)     XML (1)    
DTS (2)     Distributed Queries (1)     Programming (1)     XSL (1)    
   Items 1 to 8 of 8   
 

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 | 32,291 reads

Getting the Most Out of SQL Server 2000's Query Analyzer, Part III

In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you.   Read more...
By Brian Kelley 2005/01/07 (first posted: 2002/08/01) | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 37,366 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: (not yet rated) |  Discuss |  Briefcase | 16,998 reads

Ways to Determine the Version and SP of SQL Server

There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods.   Read more...
By Dinesh Priyankara 2003/02/28 | Source: SQLServerCentral.com | Category: Service Packs
Rating: |  Discuss |  Briefcase | 19,732 reads

Manage Multiple SQL Server Installations and Databases with OSQL

This article explains how to use a simple batch file and script file to manage multiple databases on multiple servers.   Read more...
By Randy Dyess 2002/10/24 | Source: SQLServerCentral.com | Category: Configuring
Rating: |  Discuss |  Briefcase | 8,320 reads

Ansi Options Part 3 - ANSI_NULL_DFLT_ON

The behavior of SQL Server is influenced in many ways by the various settings and options available. This series will examine some of the ANSI options that can be set and changed in SQL Server.   Read more...
By Steve Jones 2002/08/07 | Source: SQLServerCentral.com | Category: Configuring
Rating: |  Discuss |  Briefcase | 3,511 reads

Getting the Most Out of SQL Server 2000's Query Analyzer, Part III

In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you.   Read more...
By Brian Kelley 2005/01/07 (first posted: 2002/08/01) | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 37,366 reads

Ansi Options Part 1 - ANSI_PADDING

The behavior of SQL Server is influenced in many ways by the various settings and options available. This series will examine some of the ANSI options that can be set and changed in SQL Server.   Read more...
By Steve Jones 2002/07/08 | Source: SQLServerCentral.com | Category: Configuring
Rating: |  Discuss |  Briefcase | 5,138 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,234 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 | 32,291 reads
   Items 1 to 8 of 8