601934

1234567891011121314
Across
  1. 2. Again in the relational model, a foreign key is an attribute or collection of attributes from one relational table whose values must match another relational table's primary key.
  2. 5. Used by SQL Server Agent for scheduling jobs and alerts and recording operators. (Operators are individuals who are assigned responsibility for jobs and alerts.)
  3. 7. 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.
  4. 9. In the relational model, a primary key is a single attribute, or combination of attributes, which can be used to uniquely identify a row of data in a give table.
  5. 11. 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.
  6. 12. A data type used to contain textual material, such as alphabetic characters and punctuation symbols.
  7. 14. 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
  1. 1. 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.
  2. 2. As mentioned a SQL database is made up of a set of operating system files these files are the basis for the database.
  3. 3. 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.
  4. 4. a technique for partitioning data. A database shard is a horizontal (think rows, not columns) partition of data within a database, with each partition being referred to as a shard.
  5. 6. 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.
  6. 8. 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.
  7. 10. This is the data about the data. Metadata describes data relationships and characteristics, and is often referred to as a data dictionary, though that seems to be a term more prevalent in the relational world (though not exclusive to it by any means).
  8. 13. is an umbrella term, one which encompasses a number of different technologies. These different technologies aren't even necessarily related in any way beyond the single defining characteristic of NoSQL: they are not relational in nature.