Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 View All Answers
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Explain the stored procedure?
How do you delete a data source?
What is difference between commit and rollback when used in transactions?
What is primary key and example?
What is a trigger and its types?
Mention the uses of stored procedures.
What is transactional replication?
What is the use of partition by in sql server?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
When is update_statistics command used?
What is the difference between Stored Procedures and triggers?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
