SQL Clone
SQLServerCentral is supported by Redgate
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,427 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,562 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,779 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,577 reads
<< Newer    Items 21 to 24 of 24   
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)    
datatypes (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)