Answer Posted / sqldba29
Trace flags are used to temporarily set specific server
characteristics or to switch off a particular behavior. For
example, if trace flag 3205 is set when an instance of SQL
Server starts
1204: Deadlock information
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the ways to controlling cursor behavior?
What are commonly used odbc functions in php?
Introduction of rollup clause using sum and group by clause?
What is a DBMS, query, SQL?
What is extent? Types of extents?
What is sub query and its properties?
Is sql server a database?
What is database black box testing?
How to create a new schema in a database?
Explain what is the function of sql server agent windows service?
How sql server executes a statement with nested subqueries?
What are character string data types in ms sql server?
How to stop log file growing too big?
How to access the deleted record of an event?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?