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;
12 Cards in this Set
- Front
- Back
|
-s <instancename>
|
cmd start named instance
|
|
|
-m
|
cmd start in single-user mode
|
|
|
-f
|
cmd start w/ minimal configuration
|
|
|
-d master_file_path
|
cmd fully qualified path for the master db file
|
|
|
-e error_log_path
|
cmd fully qualified path for the error log file
|
|
|
-l master_log_path
|
cmd fully qualified path for the master db log file
|
|
|
-c
|
cmd shortens startup time when starting sql server, skips Service Control Manager
|
|
|
-g
|
cmd specifies an integer number of MB of memory that the SQL Server will leave available for memory allocations w/in the sql server process
|
|
|
-n
|
does not use the windows application log to record sql server events.
|
|
|
-T trace#
|
indicates that an instance of sql server should be started w/a specified trace flag (trace#) in effect. Trace flags are used to start the server w/ nonstandard behavior
|
|
|
-x
|
disables the following monitoring features:
-sql server performance monitor counter -keeping cpu time and cache-hit ratio statistics -collecting info for the DBCC SQLPERF command -Collecting info for some dynamic management views -Many extended-events event points |
|
|
-E
|
Increases the number of extents that are allocated for each file in a filegroup. Helpful for data warehouse applications that have a limited number of users running index or data scans. do not use w/ other applications because it might adversely affect performance. Not supported in 32-bit releases.
|
