Unit 1 Vocabulary Flashcards
(19 cards)
Model Database
CE
Serves as a template for any other database, a required database. Any future database created has to be at least as large as the model
tempdb database
CE
One of the key working areas for SQL Server, storage for temp tables.
Transaction Log
CE
Place where initial changes to a database are written in serial order. The log accumulates changes that are deemed as having been committed.
Checkpoint
CE
The point in time that all changes in the log are propagated to the actual database files and the log is cleared.
Actual database file
Or
Physical database file
CE
After checkpoint is issued changes from the log are propagated here.
Index
CE
An object that exists only within the framework of a particular table or view. An index works much like the index does in the back of a book.
Cluster Index
CE
An object that exists only within the framework of a table (database object). Triggers are pieces of code that are executed when certain things happen to the table (database object) that they are associated with. The things that can trigger triggers to fire (execute) are inserts, updates, or deletes.
Trigger
CE
An object that exists only within the framework of a table (database object). Triggers are pieces of code that are executed when certain things happen to the table (database object) that they are associated with. The things that can trigger triggers to fire (execute) are inserts, updates, or deletes.
Secondary files
CE
32,000 files that can be added to the primary filegroup. Secondary files are optional, are user defined, and store user data. Secondary files can be used to spread data across multiple disks by putting each file on a different disk drive. Additionally, if a database exceeds the maximum size for single Windows file, you can use secondary data files so the database can continue to grow.
The recommended file name extension for secondary data files is .ndf
View
CE
Sometimes called a virtual table. It is basically a stored query (a preplanned mapping and representation of the data stored in tables.
Stored Procedure
CE
An ordered series of transact- SQL statements bundled into a single logical unit. They allow for variables and parameters as well as selection and looping constructs. They offer several advantages over just sending individual statements to the server (listed on page 11)
User defined functions
CE
Similar to stored procedures except that it can return a value and cannot have “side effects”. Can return a value of most SQL SERVER data types.
User
CE
Equivalent of logins; object represents an identifier for someone to login into the SQL server.
Role
CE
Users belonging to a group that are granted rights to perform certain actions in SQL server. A user can belong to one or more roles.
Constraint
CE
Restriction information about what can go into a table.
[ ] (square brackets)
CE
Are used for any names that are the same as SQL Server keywords or contain embedded spaces.
Query analyzer
CE
A tool that existed in SQL Server 2000. It provided a user interface in which T-SQL statements could be written and executed.
Management Studio
CE
A tool introduced with SQL Server 2005 that replaced query analyzer and enterprise manager. It is where you can execute T-SQL statements and perform numerous database management tasks.
Query Optimizer
CE
Part of SQL Server that figures out the best way to run a query to balance fast results with minimum impact to other users.
