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

Content with tags Database Design, Administration Rss

   Items 1 to 20 of 21    Older >>
 

Foreign key

By Igor Micev 2012/04/06 | Category: database design
Rating: (not yet rated) |  Discuss |   Briefcase | 2,594 reads

Table space usage 1

By Hugo Kornelis 2011/11/09 | Category: database design
Rating: (not yet rated) |  Discuss |   Briefcase | 2,448 reads

Lipoaspiration in your SQL Server Database

Once, when disk space was at a premium, DBAs fought hard to keep the size of their database down. Now there seems less motivation to 'fight the flab' of a database. Fabiano Amorim was watching television recently when the subject matter, cosmetic surgery, gave him the theme and inspiration for this guide to keeping your database fit and trim.  Read more...
By Additional Articles 2011/03/16 | Source: SimpleTalk | Category: administration
Rating:  Rate this |   Briefcase | 3,768 reads

Making your SQL Server database changes backward compatible: Adding a new column

As multi-tier architectures grow over time, it is often challenging to coordinate those changes across the data, logic and presentation tiers. Unless planned and implemented carefully, an act as simple as adding a column to a table can grind all of the components of your application to a halt. While some of us have comfortable 12-hour maintenance windows every weekend, many of us are bound by service level agreements that are much more strict. So we must find ways to introduce fixes and new features with zero downtime, and without requiring every single component to be refactored at the same time.   Read more...
By Additional Articles 2010/06/23 | Source: MSSQLTips.com | Category: database design
Rating:  Rate this |   Briefcase | 2,840 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: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 40,033 reads

SQL Server Scalabilty - An Introduction

A brief introduction into the world of scalability, presenting at a high-level the various options  Read more...
By Kev Riley 2008/03/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,032 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: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 40,033 reads

Using SQL Server 2005 to document Sarbanes-Oxley compliance

My CIO and I have looked at a number of commercial solutions for documenting Sarbanes-Oxley compliance. However, we decided to use SQL Server 2005's built-in tools to create our own "home-grown" auditing system.   Read more...
By Additional Articles 2006/05/19 | Source: Builder.com | Category: advanced
Rating:  Rate this |   Briefcase | 3,465 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 published: 2002/02/11) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 35,796 reads

An Automated Solution for Migrating Database Structures

This article by Simon Galbraith (from Red Gate software, maker of SQL Compare) discusses migrating changes from development to staging, QA, and on to production. If you've never seen the need for a schema compare tool (Steve Jones!), this is worth reading.  Read more...
By Additional Articles 2003/05/06 | Source: DevX | Category: administration
Rating:  Rate this |   Briefcase | 2,244 reads

Managing Jobs - Part 2

Jobs are pretty basic aren't they? They are until you get a couple hundred, or a thousand. Andy continues talking about managing jobs by standardizing how you handle notifications and failures, and talks about an interesting idea to monitor jobs separately from SQL Agent. Worth reading!   Read more...
By Andy Warren 2003/02/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,336 reads

Managing Jobs - Part 1

How many jobs do you have? 10? 100? 1000? Andy makes the point that what works to manage for a small number of jobs doesn't work when that number doubles or triples (well, unless you only had 1 job to start with!). In part one of two, this article looks at ideas for using categories and naming conventions to get things under control.   Read more...
By Andy Warren 2003/01/31 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,437 reads

Beware of Mixing Collations - Part 1

A few months ago Greg Larsen ran across a big problem with SQL Server collation when querying. He shares his bruises in this quick article.   Read more...
By Gregory Larsen 2002/12/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,021 reads

User-defined Data Type Basics

This article discusses an often-overlooked feature of SQL Server called user-defined data types.   Read more...
By Don Frazier 2002/12/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,052 reads

Interact with SQL Server's Data and Procedure Cache

This article briefly discusses SQL Server's data and procedure cache and shows you the common Transact-SQL statements/command and system tables that you can use to interact with the cache through Transact-SQL.   Read more...
By Randy Dyess 2002/08/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,801 reads

Bill Wunder's DDL Archive Utility Launches as Freeware

Bill Wunder has donated his utility for those who have a free SQLServerCentral.com mebership. The DDL Archive Utility will look into a database and automatically archive the DDL from the database into Source Safe saving hours of hassles!   Read more...
By Bill Wunder 2002/07/11 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 211 reads

Version Control for Stored Procedures

Version control for stored procedures isn't always popular and certainly isn't easy. Or can it be? Andy discusses a technique he used on a recent project that you might find interesting.   Read more...
By Andy Warren 2002/05/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,382 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 published: 2002/02/11) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 35,796 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: administration
Rating: |  Discuss |   Briefcase | 9,862 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: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,184 reads
   Items 1 to 20 of 21    Older >>
 
Tags
sql server 7 (12)    
configuring (6)    
miscellaneous (6)    
t-sql (6)    
programming (5)    
strategies (5)    
basics (4)    
naming standards (3)    
advanced (2)    
monitoring (2)    
stored procedures (2)    
visual basic 6 (2)    
data types (1)    
foreign keys (fk) (1)    
indexing (1)    
installation (1)    
performance tuning (1)    
scalability (1)    
sql server 2005 (1)    
sql-dmo (1)