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

Explain the difference between control flow and data flow?

1054

---

What are the steps you will take to improve the performance of a poor performing query?

1017

---

What are the purposes of floor and sign functions?

1017

---

When to use null data driven subscription?

213

---

How many tables can be joined in SQL Server?

1111

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1111

---

What is normalization 1nf 2nf 3nf?

1105

---

What is format parameter in ssrs?

150

---

what are candidate key, alternate key and composite key? : Sql server database administration

960

---

Explain ranking functions?

1094

---

what is a join? : Sql server database administration

1323

---

What is the difference between ddl and dml?

1094

---

What is nonclustered index with included columns ?

1014

---

How to display a past time in days, hours and minutes?

1058

---

Explain the use of containers in ssis?

1012

---