Answer / Anuj Kumar Kanoijia

Trace flags (also known as server trace flags or dynamic trace flags) are database options in SQL Server that modify the behavior of certain features. They can be used to troubleshoot performance issues, optimize queries, and fix errors. Trace flags must be set at the server level using the `sp_configure` stored procedure or by modifying the configuration file (SQLServer.exe.config).

why SQL server is more used to store database rather than Access

2 Answers  

---

What are character string data types in ms sql server?

1 Answers  

---

Plz tell about backup&recovery?

3 Answers  

---

Explain what are the database objects? : SQL Server Architecture

1 Answers  

---

What is bcp? When does it use?

1 Answers  

---

what is package and it uses and how can u call a package

1 Answers   Satyam,

---

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,

---

Explain about system stored procedure?

1 Answers  

---

What is 1nf 2nf?

1 Answers  

---

Explain cursor as data base object?

1 Answers  

---

How important do you consider cursors or while loops for a transactional database?

1 Answers  

---

What is sub query and its properties?

1 Answers  

---