Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
32 Cards in this Set
- Front
- Back
|
MSREPL_COMMANDS
|
this table lives in the distribution database. contains info about the location of synchronization files-- truncated after successful replication
|
|
|
foreign keys in merge replication
|
when the fk table is not included in the publication you cannot add new rows or update the fk column. you can however still change other columns.
|
|
|
error 1205
|
deadlock situation
security level = 13 |
|
|
what is the general unicode locale identifier?
|
1033
|
|
|
sp_create_removeable
|
creates a removeable media database.
|
|
|
6 create trace wizard options
|
1. find the worse performing queries
2. identify scans of large tables 3. identify the cause of a deadlock 4. profile the performace of a stored procedure 5. trace tsql activity by application 6. trace tsql activity by user |
|
|
what is the sql server agent monitor?
|
component that automatically starts sql server agent if it abnormally stops
|
|
|
virtual table
|
constructed to provide query access against files and folders (read index server)
|
|
|
regrebld
|
utility used to backup and restore SQL Server registry keys
|
|
|
sqlserver.exe -m
|
starts sql server in single user mode
|
|
|
what data columns must you include in a SQL Server profiler trace in order to save captured event data in a table?
|
application name
|
|
|
what exchange server component and be used to monidtor services that are running on the SQL Server computer?
|
server monitor
|
|
|
what is the default SQL Server client net-library
|
named pipes
|
|
|
effect of create statements on security delicated through a NT group
|
if a user has permission to create a table through a NT group their user account automatically gets added to the db upon creation.
|
|
|
what is the default tcp port for sql server?
|
1433
|
|
|
1. SQL Server Netowrk utility
2. SQL Server client network utility |
1. used to reconfigure sql server to listen on additional net libraries.
2. used on client computers to configure network protocols |
|
|
minimum installation requirements:
1. SQL Server HD space 2. Management Tools HD space 3. processor |
1. 65 megs
2. 90 megs 3. pentium 166 |
|
|
MSXOperator
|
the only operator that can recieve notifications for multi-server jobs
|
|
|
how do you change the sort order and unicode collation once SQL Server is installed
|
rebuild all databases
|
|
|
what do performance condidions relate to?
|
alerts
object, counter, instance |
|
|
selectivity
|
Number of rows typically identified for a key value. high for identity columns
|
|
|
distribution statistics
|
used to estimate how effective an index would be in retrieving data associated with data in the index
|
|
|
what is the fully qualified name format for linked server tables?
|
linked_server_name.catalog.schema.object_name
|
|
|
codepages:
1252 850 437 |
1252 - ISO character set - cyrillic
850 - multilingual 437 - us english |
|
|
UPDATE STATISTICS
sp_updatestatistics |
1. update distribution statistics for all user defined tables in the current db.
2. updates info about the distribution of key values for statistics groups in a specified table |
|
|
sp_rename
|
changes the name of an object in the current db
@objname @newname @objtype = ... |
|
|
sp_dboption
|
display or change db options
@dbname @optname @optvalue |
|
|
sp_configure
|
set global configuration settings for a server
@configurename = @configurevalue = |
|
|
sp_attach_db
sp_attache_single_file_db |
1. attache a db to the server
2. same as above but for a db with only one file |
|
|
sp_addextendedproc
sp_dropextendedproc |
add/drop an extended procedure
@functionname @dllname |
|
|
sp_addmessage
sp_dropmessage |
add/drop a message from sysmessages
@msgnum @severity @msgtext @lang @with_log @replace |
|
|
error 9002
|
tl full
severity = 19 nad its written to the nt log |
