Answer / sqldba29

Trace flags are used to temporarily set specific server
characteristics or to switch off a particular behavior. For
example, if trace flag 3205 is set when an instance of SQL
Server starts

1204: Deadlock information

What is co-related sub query?

0 Answers  

---

How to drop an existing schema in ms sql server?

0 Answers  

---

How to update existing rows in a table?

1 Answers  

---

Explain about thread and memory management process of SQL?

0 Answers  

---

How do you troubleshoot SQL Server if its running very slow?

2 Answers   HP,

---

What are the types of model in sql server and explain

2 Answers   TCS,

---

SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

1 Answers   CarrizalSoft Technologies,

---

What is database dimension? : sql server analysis services, ssas

0 Answers  

---

Write down the syntax and an example for create, rename and delete index?

0 Answers  

---

How to search for a string in all stored procedure in sql server?

0 Answers  

---

What triggers long term care?

0 Answers  

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

---