http://www.sqlservercentral.com/Content tagged Database Design, SQL Server 7, 2000 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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. http://www.sqlservercentral.com/articles/Administering/sizingadatabase/383/2006/06/30http://www.sqlservercentral.com/articles/Administering/sizingadatabase/383/Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online! http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticesnotusingprimarykeysandclusteredindex/488/2008/05/09http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticesnotusingprimarykeysandclusteredindex/488/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. http://www.sqlservercentral.com/articles/Administering/sizingadatabase/383/2006/06/30http://www.sqlservercentral.com/articles/Administering/sizingadatabase/383/Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online! http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticesnotusingprimarykeysandclusteredindex/488/2008/05/09http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticesnotusingprimarykeysandclusteredindex/488/Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary! http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/2005/02/04http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/Most of us know what it is, or do we? Chris works on a good definition and along with that, gets into a good look at the problems denormalization creates and talks about a pretty common form of it - the indexed view. http://www.sqlservercentral.com/articles/Advanced/indexedviews/1205/2003/12/02http://www.sqlservercentral.com/articles/Advanced/indexedviews/1205/Chris Kempster brings us a basic look at the database design topic of denormalization.http://www.sqlservercentral.com/articles/Advanced/whatisdenormalization/1204/2003/12/01http://www.sqlservercentral.com/articles/Advanced/whatisdenormalization/1204/Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online! http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticesnotusingprimarykeysandclusteredindex/488/2008/05/09http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticesnotusingprimarykeysandclusteredindex/488/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.http://www.sqlservercentral.com/redirect/articles/982/2003/05/06http://www.sqlservercentral.com/redirect/articles/982/Disk space is getting cheaper everyday. Why should you worry about the amount of space your data is consuming? This article by Neil Boyle presents some great reasons why you should be concerned. http://www.sqlservercentral.com/articles/Performance+Tuning/savingspace/208/2003/02/21http://www.sqlservercentral.com/articles/Performance+Tuning/savingspace/208/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! http://www.sqlservercentral.com/articles/Administering/managingjobspart2/919/2003/02/14http://www.sqlservercentral.com/articles/Administering/managingjobspart2/919/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. http://www.sqlservercentral.com/articles/Administering/managingjobspart1/906/2003/01/31http://www.sqlservercentral.com/articles/Administering/managingjobspart1/906/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. http://www.sqlservercentral.com/articles/Administering/collate_part1/875/2002/12/19http://www.sqlservercentral.com/articles/Administering/collate_part1/875/This article discusses an often-overlooked feature of SQL Server called user-defined data types. http://www.sqlservercentral.com/articles/Administering/userdefineddatatypes/873/2002/12/17http://www.sqlservercentral.com/articles/Administering/userdefineddatatypes/873/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. http://www.sqlservercentral.com/articles/Administering/cache/766/2002/08/15http://www.sqlservercentral.com/articles/Administering/cache/766/The strength and holy grail of relational databases lies in the very name: relations. Microsoft has put a good deal of intelligence and cunning into query optimizations, caching, indexing and execution plans to make the process of finding related records even smoother and faster. This small article, however, will try to shatter the very sacred notion of relational databases. http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/relationaldatabasewithoutrelations/733/2002/07/29http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/relationaldatabasewithoutrelations/733/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! http://www.sqlservercentral.com/articles/Administering/729/2002/07/11http://www.sqlservercentral.com/articles/Administering/729/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. http://www.sqlservercentral.com/articles/Administering/versioncontrolforstoredprocedures/681/2002/05/10http://www.sqlservercentral.com/articles/Administering/versioncontrolforstoredprocedures/681/Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary! http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/2005/02/04http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it! http://www.sqlservercentral.com/articles/Performance+Tuning/reducingroundtripspart2/588/2002/02/06http://www.sqlservercentral.com/articles/Performance+Tuning/reducingroundtripspart2/588/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. http://www.sqlservercentral.com/articles/Administering/understandingtheimplicationsofansisql92setoptions/482/2001/10/18http://www.sqlservercentral.com/articles/Administering/understandingtheimplicationsofansisql92setoptions/482/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. http://www.sqlservercentral.com/articles/Administering/designoversight-preliminaryreview/414/2001/08/20http://www.sqlservercentral.com/articles/Administering/designoversight-preliminaryreview/414/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. http://www.sqlservercentral.com/articles/Administering/sizingadatabase/383/2006/06/30http://www.sqlservercentral.com/articles/Administering/sizingadatabase/383/