#model database

[artyrambles]

I am very happy because I finally found a better way to catalogue my models than that crappy Excel list. c:

Took a LOT of time to make that form because I’m an absolute Access beginner, but now it works like a charm! Also took a lot of time to enter all of the models, cause I wanted to figure out when I bought them (impossible to figure out for some of them) and how much I spent on them. I limited it to everything 1/72 and bigger at the moment, but probably gonna make lists for my smaller and Cobi models too.

Now, I can easily generate to-do lists, take notes, and have a good way of keeping track how much I’m spending, or how long a model has been sitting around unfinished.

If you have a lot of models like I do, I can recommend trying something like this.

[varindersandhu-blog]

Post has been published on Varinder Sandhu 's Blog

Post has been published on http://www.varindersandhu.in/2011/04/02/sql-server-understanding-the-system-database-of-sql-server/

SQL Server – Understanding the System Databases of SQL Server

<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->

We all know there are some system databases available in SQL Server. But we should have understanding about system databases. Here just try to give you understanding of system databases very briefly.

There are four system databases available in SQL Server 2008

Master

Model

msdb

tempdb

Master Database

The master database records all the system-level information for a SQL Server system.

The master is the database that records the existence of all other databases and the location of those database files and records the initialization information for SQL Server. Therefore, SQL Server cannot start if the master database is unavailable. In short, Master database is the logical repository for the system objects residing in the sys schema.

Model Database

The model database is used as the template for all databases created on the instance of SQL Server. Template can include specific settings and all sorts of useful stuff.

Msdb Database

The msdb database is used by SQL Server Agent for scheduling alerts and jobs. If the MSDB database is corrupted or damaged then scheduling information used by SQL Server Agent will be lost.

Tempdb Database

The tempdb database is a workspace for holding temporary objects or intermediate result sets, temporary table creation/processing. The TempDB is recreated every time when ever SQL Server restarts

For more Detail go to below URL

http://msdn.microsoft.com/en-us/library/ms178028%28v=SQL.105%29.aspx