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

Content with tags Database Design, Strategies Rss

<< Newer    Items 21 to 24 of 24   
 

Using Uniqueindentifier Instead of Identity

Identity columns are last years news. Have you experimented with uniqueindentifiers - better known to programmers as GUID's? Guaranteed to be unique in the world, they offer a powerful alternative to identity columns.   Read more...
By Andy Warren 2001/09/17 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 11,405 reads

SQL Server Database Coding Conventions and Best Practices

Learn the key basics of writing quality Transact-SQL code.   Read more...
By Additional Articles 2001/09/07 | Source: Other | Category: naming standards
Rating:  Rate this |   Briefcase | 6,150 reads

Database Standards and Conventions

Having a good set of naming conventions for your SQL Server objects is one of the most vital things to a company. In the long duration of a business, it saves money and time as programmers are transferred internally and don't need to relearn object names. As learning curves lower, cost lowers. This article covers some of the conventions that Brian Knight uses and why he uses them.   Read more...
By Brian Knight 2005/02/25 (first published: 2001/05/29) | Source: SQLServerCentral.com | Category: naming standards
Rating: |  Discuss |   Briefcase | 27,712 reads

Character Datatype Decisions

The type of datatypes that you use in your schema could impact the performance and the accuracy of your database.   Read more...
By Brian Knight 2001/05/07 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,563 reads
<< Newer    Items 21 to 24 of 24   
 
Tags
naming standards (10)    
miscellaneous (9)    
programming (6)    
administration (5)    
sql server 7 (5)    
t-sql (4)    
basics (3)    
configuring (3)    
best and worst practices (2)    
best practices (2)    
career (2)    
certifications (2)    
data types (2)    
monitoring (2)    
system development life cycle (2)    
advanced (1)    
book reviews (1)    
performance tuning (1)    
reviews (1)    
security (1)    
sql-dmo (1)    
stored procedures (1)    
visual basic 6 (1)