SQL Server includes 5 editions
1. Enterprise edition
2. Standard edition
3.Develeoper edition
4.workgroup edition
5.express edition
1. Enterprise edition has no limitations and has all features and functionality
2. Develeoper edition has no limitations and has all features and functionality, but it is not licensed for production
3. Standard edition has all features and functionality suited for larger data set, but it is limited in the no of nodes(4 processors) it supports for clustering as well as in its capability to use system resources , online indexing, fast recovery, indexing views, online restores and data processing.
4.workgroup edition does not include the features and functionality needed to operate large databases and is restricted in capacity(2 processors) to support mid-size and large companies
5. Express edition is used for small application-installed databases that need to be distributed free of charge. It is not suited for organization-wide databases.
Sunday, March 11, 2007
Saturday, January 6, 2007
A,B,C's of Database
A very simple term to be defined, includes set of tables, stored procedures, views that pertain to particular grouping of data stored in database's tables.
when you first load SQL Server, you will start with 4 system databases
1. Master
2. Model
3. MSDB
4. tempdb
Master: The database holds a special set of tables (system tables) that keeps track of the system as a whole.
-> Master includes metadata such as logon accounts, endpoints, linked servers and system configuration settings. Also, 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.
-> Datatype info for that instance of SQL Server, Monitoring Info(Like last run, CPU time etc), Logins, Users, etc and etc
Model: The model database is used as the template for all databases created on an instance of SQL Server. Because tempdb is created every time SQL Server is started, the model database must always exist on a SQL Server system.
tempdb: One of the key working areas for our server. whenever you issue a complex or large query that sql server needs to build interim tables to solve, it does so in tempdb, even though you think you are creating in the current database.
MSDB: is where SQL Agent process stores any system tasks. If you schedule backups to run on a database nightly, there is an entry in msdb
Transaction Log:
Changes that were made database will not go to database directly instead they are written serially to transaction log. At the later point in time, database is issued a check point – is at that point changes in the log are propagated to the actual database file
-> Database is in a random access arrangement, which helps in speedy access, while log is serial in future, which allows the things to be tracked in the proper order
Table:
Table is made up of what is called domain data(columns) and entity data(rows). The actual data of database is stored in tables.
Indexes:
An index is an object that exists only within the framework of a particular table or view
Clustered Index: table is physically sorted according to that index, Only one clustered index can be there for a table
Non clustered index: This kind of index points to a value which will let you find the data
Triggers:
Triggers are pieces of logical code that are automatically executed when certain things, such as inserts, updates or delete happens to a table. It is an object that exists only within the framework of the table
Constraints
Confine the data in a table to meet certain conditions
Views
view is a virtual table
There are many things like stored proecedures, which is set of t-sql stmts bundled up into a single logic unit, User defined functions, Users and Roles, Rules, defaaults, User-defined datatypes
when you first load SQL Server, you will start with 4 system databases
1. Master
2. Model
3. MSDB
4. tempdb
Master: The database holds a special set of tables (system tables) that keeps track of the system as a whole.
-> Master includes metadata such as logon accounts, endpoints, linked servers and system configuration settings. Also, 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.
-> Datatype info for that instance of SQL Server, Monitoring Info(Like last run, CPU time etc), Logins, Users, etc and etc
Model: The model database is used as the template for all databases created on an instance of SQL Server. Because tempdb is created every time SQL Server is started, the model database must always exist on a SQL Server system.
tempdb: One of the key working areas for our server. whenever you issue a complex or large query that sql server needs to build interim tables to solve, it does so in tempdb, even though you think you are creating in the current database.
MSDB: is where SQL Agent process stores any system tasks. If you schedule backups to run on a database nightly, there is an entry in msdb
Transaction Log:
Changes that were made database will not go to database directly instead they are written serially to transaction log. At the later point in time, database is issued a check point – is at that point changes in the log are propagated to the actual database file
-> Database is in a random access arrangement, which helps in speedy access, while log is serial in future, which allows the things to be tracked in the proper order
Table:
Table is made up of what is called domain data(columns) and entity data(rows). The actual data of database is stored in tables.
Indexes:
An index is an object that exists only within the framework of a particular table or view
Clustered Index: table is physically sorted according to that index, Only one clustered index can be there for a table
Non clustered index: This kind of index points to a value which will let you find the data
Triggers:
Triggers are pieces of logical code that are automatically executed when certain things, such as inserts, updates or delete happens to a table. It is an object that exists only within the framework of the table
Constraints
Confine the data in a table to meet certain conditions
Views
view is a virtual table
There are many things like stored proecedures, which is set of t-sql stmts bundled up into a single logic unit, User defined functions, Users and Roles, Rules, defaaults, User-defined datatypes
Subscribe to:
Posts (Atom)
