Monday, June 27, 2011

Database Design Guidelines

References :

1.Best practices SQL Server naming conventions
http://www.sqlservercentral.com/articles/Naming+Standards/2895/

2.Best practices SQL Server naming conventions
http://vyaskn.tripod.com/object_naming.htm

3)10+ common questions about SQL Server data types
http://www.techrepublic.com/blog/10things/10-common-questions-about-sql-server-data-types/355

4)Composite Primary Keys
-
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Devops links

  Build Versioning in Azure DevOps Pipelines 

  • Devops links
      Build Versioning in Azure DevOps Pipelines 
  • using Linq methods with caution - E.g FirstorDefault()
    Don't use FirstorDefault() unless you are sure its valid/ verified in the business scenario. else you are going to introduce bugs in t...
  • Sql Query titbits
    Generate Dates and hour between Date Range  DECLARE    @start DateTime = getdate() -1,    @end   DateTime = getdate(); ; WITH Dates_CTE     ...