Shared Flashcard Set

Details

MCITP SQL 2005 to 2008 Upgrade
Study for MCITP exam 70-453, SQL Server 2005 to 2008 upgrade
6
Computer Science
Professional
09/05/2011

Additional Computer Science Flashcards

 


 

Cards

Term
Trace flag 1204; sqlserver.exe -T
Definition
This trace flag provides deadlock information in non-XML format
Term
Trace flag 1222; sqlserver.exe -T
Definition
This trace flag provides deadlock information in XML format
Term
Trace flag 2528; sqlserver.exe -T
Definition
This trace flag disables parallel object checks during DBCC commands (DBCC CHECKDB, DBCC CHECKFILEGROUP, and DBCC CHECKTABLE)
Term
Trace flag 1211; sqlserver.exe -T
Definition
This trace flag disables lock escalation based on memory pressure or the number of locks
Term
msdb
Definition
This system database stores policies for Policy-Based Management
Term
varchar(max)
Definition
text, ntext and image datatypes should be replaced by this datatype
Supporting users have an ad free experience!