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

Do you think BCNF is better than 2NF & 3NF? Why?

0 Answers   Ernst Young,

---

What does the automatic recovery do?

1 Answers  

---

What is for xml in sql server?

0 Answers  

---

How to change server name in sql server?

0 Answers  

---

What is Service Broker in sql server 2012?

0 Answers   UGC Corporation,

---

What the different types of Replication and why are they used?

0 Answers  

---

hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 Answers  

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

0 Answers   IGT,

---

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

0 Answers  

---

Explain sub-query?

0 Answers  

---

Write a sql query to delete duplicate records from a table called table1

0 Answers  

---

How to use values from other tables in update statements in ms sql server?

0 Answers  

---