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

Content with tags T-SQL, Database Design Rss

   Items 1 to 20 of 22    Older >>
 

Free eBook: 45 Database Performance Tips for Developers

As a developer, if you need to go into the database and write queries, design tables, or determine the configuration of your SQL Server Systems, these tips should help make sure you're not unnecessarily sacrificing database performance. This eBook has 45 easy tips to improve the performance of your indexes and T-SQL queries, and hunt down problems within ORM tools and database design.   Read more...
By Press Release 2014/01/02 (first published: 2013/11/04) | Source: Red-Gate | Category: tips
Rating:  Rate this |   Briefcase | 15,536 reads

Free eBook: 45 Database Performance Tips for Developers

As a developer, if you need to go into the database and write queries, design tables, or determine the configuration of your SQL Server Systems, these tips should help make sure you're not unnecessarily sacrificing database performance. This eBook has 45 easy tips to improve the performance of your indexes and T-SQL queries, and hunt down problems within ORM tools and database design.   Read more...
By Press Release 2014/01/02 (first published: 2013/11/04) | Source: Red-Gate | Category: tips
Rating:  Rate this |   Briefcase | 15,536 reads

More Triggers

This Friday Steve Jones talks about database design and specifically asks how you prefer to design triggers.   Read more...
By Steve Jones 2010/11/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 735 reads

Auto generated SQL Server keys - uniqueidentifier or IDENTITY

I'm designing a table and I've decided to create an auto-generated primary key value as opposed to creating my own scheme or using natural keys. I see that SQL Server offers globally unique identifiers (GUIDs) as well as identities to create these values. What are the pros and cons of these approaches?  Read more...
By Additional Articles 2008/10/23 | Source: MSSQLTips.com | Category: t-sql
Rating:  Rate this |   Briefcase | 4,968 reads

Identity Columns

When Nigel Rivett takes us on a tour of the apparently innocuous subject of Identity Columns in TSQL, even the seasoned programmer is due for one or two surprises.  Read more...
By Additional Articles 2008/06/04 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 4,933 reads

Storing IPs in SQL Server

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.   Read more...
By David Poole 2007/04/02 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 13,960 reads

Computed Columns

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.  Read more...
By Andy Warren 2008/02/12 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 12,381 reads

TinyInt, SmallInt, Int and BigInt

SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database.   Read more...
By David Poole 2006/12/18 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 19,899 reads

Storing IPs in SQL Server

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.   Read more...
By David Poole 2007/04/02 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 13,960 reads

TinyInt, SmallInt, Int and BigInt

SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database.   Read more...
By David Poole 2006/12/18 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 19,899 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,792 reads

Using Bits to Store Data

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.   Read more...
By David Poole 2004/01/06 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,364 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,233 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

A Normalization Primer

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.   Read more...
By Brian Kelley 2003/01/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 17,134 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,800 reads

Querying Responses

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.   Read more...
By Bruce Szabo 2002/06/28 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,421 reads

Storing Checkbox Responses as Integers

This article demonstrates how to store checkbox results as integers in a database...perfect for surveys!   Read more...
By Bruce Szabo 2002/06/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,172 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,376 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,792 reads
   Items 1 to 20 of 22    Older >>
 
Tags
miscellaneous (7)    
sql server 7 (7)    
administration (6)    
programming (6)    
basics (5)    
strategies (4)    
configuring (3)    
performance tuning (3)    
visual basic 6 (3)    
data types (2)    
naming standards (2)    
stored procedures (2)    
ado (1)    
advanced (1)    
advanced querying (1)    
database development (1)    
database performance (1)    
editorial (1)    
friday poll (1)    
identity property (1)    
index (1)    
installation (1)    
monitoring (1)    
orm (1)    
performance (1)    
sql-dmo (1)    
tips (1)    
uniqueidentifier (1)    
xml (1)