Archive for the ‘RDBMS’ Category
System Databases in SQL server 2005
Posted by: Manpreet Singh on: May 26, 2009
Whenever we install new SQL server instance on server, it include four system databases by default named: Master, Model, Tempdb, and MSDB. It also contains a fifth, stealth database that you will never see using any of the normal SQL tools or commands. This database is referred to as the resource database, but its actual [...]
SQL Server Naming Conventions
Posted by: Manpreet Singh on: September 9, 2008
- In: General| RDBMS
- Leave a Comment
Naming conventions are as important as a solid design to database. It is very important to name your table, views and stored procedure in a ways so that anyone could easily understand the query or structure of table in first glance. Poor naming convention can result in a lot of problems for both yourself [...]
