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

how to use DTS package in 2000,2005,2008 in sql server

0 Answers   Microsoft,

---

What are the filtered indexes?

0 Answers  

---

how to rest identity columns in sql server

3 Answers   Matrix,

---

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

0 Answers  

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  

---

How will you make an attribute not process? : sql server analysis services, ssas

0 Answers  

---

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

---

How does stuff differ from the replace function?

0 Answers  

---

What is the standby server?

0 Answers  

---

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

What are the types of containers in ssis?

0 Answers  

---

Explain few of the new features of sql server 2008 management studio

0 Answers  

---