Answer Posted / 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 nonclustered index with included columns ?

968

---

Can two tables have the same primary key?

1209

---

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1270

---

How to enter unicode character string literals in ms sql server?

1077

---

Why use stored procedures in sql server?

1016

---

Explain transaction server auto commit?

1044

---

What are the different types of columns types constraints in the sql server?

1080

---

how can a database be repaired? : Sql server administration

974

---

What are the steps you can take to avoid “deadlocks”?

978

---

How to test a dml trigger in ms sql server?

1045

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

986

---

Explain what is the function of sql server agent windows service?

995

---

What is indexed view? How to create it?

1010

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1265

---

What are the disadvantages of merge replication?

1424

---