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.
Please differentiate between Data Mining and Data warehousing?
Explain what are different stages of “Data mining”?
Do you know how does the data mining and data warehousing work together?
Can you explain what is MODEL in Data mining world?
Explain what is Discrete and Continuous data in Data mining world?
What is a correlated sub-query?
What are the steps to take to improve performance of a poor performing query?
What is blocking and how would you troubleshoot it?
What authentication modes does SQL Server support?
Why would you call Update Statistics?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
