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 kind of problems occurs if we do not implement proper locking strategy?

0 Answers  

---

What is the use of sql profiler in sql server 2012?

0 Answers  

---

could u plz explain about joins and views?

2 Answers  

---

Give an example of why you would want to denormalize a database

0 Answers  

---

What do you mean by collation recursive stored procedure?

0 Answers  

---

---

What is an active database?

0 Answers   HCL,

---

What is The Use Of TIMESTAMP DataType in SQL Server 2005?

6 Answers  

---

What is a rownum?

0 Answers  

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

---

What are joins in sql and what are the different types of joins?

0 Answers  

---

What is trigger and different types of Triggers?

0 Answers   QuestPond,

---

check, not null,unique

2 Answers   IBM,

---