Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Database Design, SQL Server 7 Rss

<< Newer    Items 21 to 23 of 23   

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: | Category: administration
Rating: |  Discuss |   Briefcase | 9,887 reads

Design Oversight - Preliminary Review

We all know what the ideal application design environment is for building a database back-end: an experienced DBA takes inputs from end users and developers and creates the database design in order to support the application being developed. But in reality, we don't get the opportunity to do application design like this very often. This article covers how to quickly find and fix problems in a design.   Read more...
By Brian Kelley 2001/08/20 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 8,186 reads

The Basics of Sizing a SQL Server Database

Sizing a database can be one of the most arduous tasks a DBA, analyst or developer must attend to. It?s time consuming and more hours go into analyzing the database than actually sizing it. This article focuses on how to monitor the database?s growth after its deployed and contains some tips on how to size it before deployment. We will also dive a little into how to benchmark your database against a robust data load.   Read more...
By Brian Knight 2008/08/01 (first published: 2001/07/25) | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 40,497 reads
<< Newer    Items 21 to 23 of 23   
administration (12)    
basics (8)    
miscellaneous (8)    
t-sql (7)    
configuring (6)    
programming (6)    
strategies (5)    
advanced (4)    
indexing (4)    
performance tuning (4)    
naming standards (3)    
visual basic 6 (3)    
monitoring (2)    
stored procedures (2)    
ado (1)    
datatypes (1)    
installation (1)    
sql server 6.5 (1)    
sql-dmo (1)    
xml (1)