SQL Database Concepts Question: Download Questions PDF
Do you know what is a Trace frag? Where do we use it?
Answer:
Temporary setting of specific server characteristics is done by trace tags. DBCC TRACEON is the command to set the trace flags. Once activated, trace flag will be in effect until the server is restarted. Trace frags are frequently used for diagnosing performance issues.
For example, the trace flag 3205 is used for disabling hard compression for tape drives, when an instance of SQL Server starts.
For example, the trace flag 3205 is used for disabling hard compression for tape drives, when an instance of SQL Server starts.
Download Basic SQL Server Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain difference between cross join and Full outer join? | What is buffer cash and log Cache in sql server? |