1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is a Trace frag?Where can we use this?

Question Posted / vamsimadineni


What is a Trace frag?Where can we use this?..

Answer / bru medishetty

A Trace Flag (not Trace Frag) is used inorder to
activate/suppress a certain behaviour of the SQL Server.

You need to restart the SQL Server after adding the Trace
Flag.

Thanks,
Bru Medishetty
www.LearnSQLWithBru.com

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the benefits of normalization?

0 Answers  

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 Answers  

What is the use of custom fields in report?

0 Answers  

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

0 Answers  

What is service broker? : sql server database administration

0 Answers  




explain the type of contraints

3 Answers  

What is view in sql?

0 Answers  

how do we find every fifth record in a table

14 Answers   Aspire, HCL,

What is the use of @@spid?

0 Answers  

Differentiate between mongodb vs. Sql server?

0 Answers  

What do you understand by replication in sql server? Mention the different types of replication in sql server.

0 Answers  

Explain what are the events recorded in a transaction log?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories