Sunday, February 19, 2012

Database design - best practices

Does anyone know the location of an offical (Microsoft if possible) document that shows the best practices for databse design?

For instance what to call tables now schema's exist?

Should it be

Countries

LookCountry

Geography.Country

Geography.Countries

What about Views and Stored procedures? prefix with VW_ sp_ or some alternative?

Thanks

I have never seen any Microsoft Official document on this. But SQL Gurn Vyas has his own view which is very helpful. Refer these links

http://vyaskn.tripod.com/object_naming.htm

http://vyaskn.tripod.com/coding_conventions.htm

Do not use SP_ for procedure since those are there for system storedprocdure. Ucan have USP(User Storedprocedure) its again depends. I never uses "_" (unserscore) in my tablename. It may be easy to read but difficult to use.

Madhu

No comments:

Post a Comment