Across
- 1. Used by SQL Server Agent for scheduling jobs and alerts and recording operators. (Operators are individuals who are assigned responsibility for jobs and alerts.)
- 5. Contains the primary data file and all other files not put into another filegroup. System tables-which define the users, objects, and permissions for a database-are allocated to the primary filegroup for that database. The system tables are created automatically by SQL Server when you create a database.
- 8. A data type used to contain textual material, such as alphabetic characters and punctuation symbols.
- 10. As mentioned a SQL database is made up of a set of operating system files these files are the basis for the database.
- 11. Two or more keywords that are used together to create an instruction, which is usu- ally conditional in nature. (See Compound.) In C and C++ programming, a user- defined data type.
- 13. Any filegroups defined by the user during the process of creating the database. A table or an index can be created in a specific user-defined filegroup.
- 14. A template for all other databases created on the system, including tempdb. When database is created, the first part of it is created as copy of the contents of the model database. The rest of the database is filled with empty pages. The model database must exist on the system because it is used to re-create tempdb every time SQL Server is started. You can alter the model database to include user-defined data types tables, and so on so that each new database you create will also have those attributes. Check the Books Online index for the topic "model database" for more information.
- 15. An acronym, pronounced either as "seguel" or "seekel", for Structured Query Language a language developed by IBM Corp. for processing data contained in mainframe computer databases. SQL has now been institutionalized by the creation of an ANSI standard for the language.
Down
- 2. Holds all pages for tables and indexes that do not have a specified filegroup when they are created. Default status can be switched from one filegroup to another by members of the db owner database role.
- 3. A debugging process by which the source code is executed one line at a time to en- able you to inspect the value of variables,find infinite loops or remove other types of bugs.
- 4. A primary data file contains all of the startup information for the database and system tables and objects. It can also be used to store user tables and objects, but it is not required to do so. Each database has exactly one primary file. The recommended file extension is MDE.
- 6. Secondary data files are optional. They can hold Secondary data files data and objects that are not in the primary file.
- 7. A transaction log file holds all of the transaction Transaction log files log information used to recover the database. Every database must have at least one log file and can have multiple log files. The recommended file extension is LDF.
- 9. Used to hold temporary tables and temporary stored procedures. This database is also used for other temporary storage needs of SQL Server, such as for sorting data. A clean copy of the tempdb data- base is re-created at its default size every time SQL Server is started. It then grows automatically as necessary. If you need a large amount of tempdb space, you can set its default to a larger size by using the ALTER DATABASE command. Check the Books Online index for the topic tempdb database" for more information.
- 12. Records the system level information, SQL Server initialization information, and configuration settings for SQL Server. This database also records all login accounts, the existence of all other databases, and the location of the primary file for all user databases. Always keep a recent backup of the master database.