Glossary of Micro Economics Chapter 7
The study of how the allocation of resources affects economic well-being.
Willingness to Pay
The maximum amount that a buyer will pay for a good.
A buyer's willingness to pay minus t
SQL Server 7 - Session Level Options
changes SQL Servers understanding of the first day of the week
when true cursors will automatically close when a transaction is committed
Causes SQL Serve
SQL Server 7 - Database Options
dbo use only
only the dbo can access the database
default to local cursor
cursors default to local, not global scope. false by default
when true no users can access the database
any tring enclosed
Glossary of Tortura Microbiology Ch. 4 and part of Ch.5
What does the term prokaryote come from?
The Greek words meaning prenucleus
What does the term eukaryote come from?
The Greek words meaning true nucleus
SQL Server 7 BCP
1. data file uses sql6.5 data types
2. quoted identifiers are used for column names
(4 possible values)
1. ACP - ansi standard
2. oem - default code page for the client
3. raw - no code page conversion should be used
SQL Server 7 Backup
stored procs to add or remove backup devices
how do you restore the master db from a backup?
you need to start sql server in single user mode:
filegroup backup functionality
need to be toi
SQL Server 7 DBCC
checks allocation and structural integrity of all objects in the specified db
checks for consistency in and between system tables in a db
1. marks a table to be pinned, meaning
SQL Server 7 Security
what are statement permissions?
create statements: CREATE TABLE, CREATE VIEW BACKUP DB, etc.
what are object permissions?
select, insert, update, delete, reference, excecute.
example: revoke select on authors to [user].
SQL Server 7 - Misc 2
third normal form
eliminate dependencies between non-key columns in a table
breaking from the normal forms to help performance
3 things about optimistic concurrency
1. may result in loss of concurrency because multipl
Glossary of SQL Server 7 Locking
A mechanism used by transactions to declare their intent of acquiring a lock
Used to maintain structural integrity of tables - i.e. cant drop an index while it is being used