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 WITH CHECK OPTION

3 Answers   Karur Vysya Bank KVB,

---

What is the difference between windows authentication and sql server authentication

7 Answers   HCL,

---

What are sql dirty pages?

0 Answers  

---

What is bcnf normalization form?

0 Answers  

---

Write an sql query to find first weekday of the month?

0 Answers  

---

What causes index fragmentation?

0 Answers  

---

Explain identity in sql server?

0 Answers  

---

What are the different types of joins and what does each do?

2 Answers  

---

Explain how dts is used to extract, transform and consolidate data?

0 Answers  

---

What is Inner Join?

2 Answers  

---

What does the on update no action do?

0 Answers  

---

What command do we use to rename a db, a table and a column?

0 Answers  

---