Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Keep up to date - daily newsletter:
Sign up
Content with tags
SQL Server 7
,
Administration
,
Database Design
Items 1 to 15 of 15
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,537 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,537 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,855 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,579 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,348 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,452 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,037 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,104 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,819 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
|
217 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,424 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,855 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,890 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,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:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
40,537 reads
Items 1 to 15 of 15
Tags
configuring
(6)
miscellaneous
(6)
t-sql
(6)
programming
(5)
strategies
(5)
basics
(4)
naming standards
(3)
monitoring
(2)
stored procedures
(2)
visual basic 6
(2)
advanced
(1)
datatypes
(1)
indexing
(1)
installation
(1)
performance tuning
(1)
sql-dmo
(1)
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.