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



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 do you understand by a stored procedure?

0 Answers  


Which one is faster delete/truncate? Why?

1 Answers   Infosys,


how would you troubleshoot blocking? : Sql server database administration

0 Answers  


Explain couple pf features of SQL server

2 Answers  


What are locks in sql?

0 Answers  






how can u select the Distinct values in the table, table having 20 columns , i want all columns

2 Answers  


what are the limitations of parameters in a storedprocedure

1 Answers  


What are the approximate numeric data types?

0 Answers  


From where can you change the default port?

3 Answers  


What is delete query?

0 Answers  


Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

0 Answers  


plss anybody specify tha constrian management system in dbms

0 Answers   Police Constable,


Categories