http://www.sqlservercentral.com/Content tagged T-SQL, Database Design posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)An IP address is something we all recognize and is a piece of data that is quite prevalent in many systems. However it is a piece of data tha presents some challenges in its storage and retrieval. SQL Server guru David Poole presents us with a look at how you can work with this strange formatting. http://www.sqlservercentral.com/articles/Advanced+Querying/2871/2008/02/19http://www.sqlservercentral.com/articles/Advanced+Querying/2871/Computed columns are an interesting way to cover some queries that might otherwise require a table scan. SQL Server expert Andy Warren brings us a look at this database design feature.http://www.sqlservercentral.com/articles/T-SQL/61764/2008/02/12http://www.sqlservercentral.com/articles/T-SQL/61764/SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database. http://www.sqlservercentral.com/articles/Performance+Tuning/2753/2007/12/10http://www.sqlservercentral.com/articles/Performance+Tuning/2753/An IP address is something we all recognize and is a piece of data that is quite prevalent in many systems. However it is a piece of data tha presents some challenges in its storage and retrieval. SQL Server guru David Poole presents us with a look at how you can work with this strange formatting. http://www.sqlservercentral.com/articles/Advanced+Querying/2871/2008/02/19http://www.sqlservercentral.com/articles/Advanced+Querying/2871/SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database. http://www.sqlservercentral.com/articles/Performance+Tuning/2753/2007/12/10http://www.sqlservercentral.com/articles/Performance+Tuning/2753/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/David recently worked on a project where it turned out storing the answers to a survey using bitmapping was a good approach. He was good enough to write some of it down and share. As he notes bitmapping isn't used as often as it used to be, but it can still be a useful technique to have around. http://www.sqlservercentral.com/articles/Miscellaneous/usingbitstostoredata/1251/2004/01/06http://www.sqlservercentral.com/articles/Miscellaneous/usingbitstostoredata/1251/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/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/For most DBAs, normalization is an understood concept, a bread and butter bit of knowledge. However, it is not at all unusual to review a database design by a development group for an OLTP (OnLine Transaction Processing) environment and find that the schema chosen is anything but properly normalized. This article by Brian Kelley will give you the core knowledge to data model. http://www.sqlservercentral.com/articles/Basic+Querying/normalization/584/2003/01/13http://www.sqlservercentral.com/articles/Basic+Querying/normalization/584/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/Binary data can be stored as integers in a table. This article explains how to query an integer field to return the bits represented by the integer. http://www.sqlservercentral.com/articles/Basic+Querying/queryresponse/717/2002/06/28http://www.sqlservercentral.com/articles/Basic+Querying/queryresponse/717/This article demonstrates how to store checkbox results as integers in a database...perfect for surveys! http://www.sqlservercentral.com/articles/Basic+Querying/storingresponses/718/2002/06/27http://www.sqlservercentral.com/articles/Basic+Querying/storingresponses/718/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/