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

What is attribute hierarchy? : sql server analysis services, ssas

961

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

1062

---

How to start sql server browser service?

1066

---

What are the new features of sql server 2008 r2 reporting service?

193

---

Can group functions be mixed with non-group selection fields in ms sql server?

890

---

How many columns can exist together per table?

1102

---

Explain user defined views?

911

---

Tell me what is the difference between locking and multi-versioning?

971

---

What is a trace frag? Where do we use it?

1044

---

Why truncate is ddl?

1028

---

What is auditing in sql server?

880

---

What is the default order of an order by clause?

944

---

Can we check locks in database? If so, how can we do this lock check?

893

---

Explain can you implement data mining in ssrs?

145

---

What is the difference between stored procedure and user defined functions?

1128

---