Answer / Rohit Kumar Kushwaha

1. Trace Flag 3604: This trace flag improves the performance of sort operations.
2. Trace Flag 8608: This trace flag provides memory-granular dump files for troubleshooting memory leaks.
3. Trace Flag 1204: This trace flag increases the size of the plan cache to improve query performance.
4. Trace Flag 908: This trace flag improves the performance of queries with temporary tables.

What value could be assigned to Varchar Type?

3 Answers  

---

What is the command used to check locks in microsoft sql server?

1 Answers  

---

what is a join and explain different types of joins? : Sql server database administration

1 Answers  

---

How can you know if the row fetched from cursor is still valid in underlying table?

1 Answers  

---

write the query for find the top 2 highest salary in sql server

36 Answers   Cranes, Jayanti Software, Medi Assist, Rmax, TCS,

---

how to get the rowid/rownumbes of a table in sqlserver

7 Answers   IBM,

---

How to add an address record into adventureworkslt?

1 Answers  

---

is there a column to which a default can't be bound? : Sql server database administration

1 Answers  

---

How to execute a sql statement using odbc_exec()?

1 Answers  

---

What different steps will a sql server developer take to secure sql server?

1 Answers  

---

Explain linked server in sql?

1 Answers  

---

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1 Answers  

---