What is the difference between Normalization and De-normalization?

0 Answers   TCS,

---

Define self join in sql server joins?

0 Answers  

---

can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

---

What is public role in sql server?

0 Answers  

---

Which are new data types introduced in sql server 2008?

0 Answers  

---

How to perform key word search in tables?

0 Answers  

---

Explain what are db_options used for?

1 Answers   InterGraph,

---

Explain indexed views and partitioned view with their syntax.

0 Answers  

---

What are the differences between lost updates and uncommitted dependencies?

0 Answers  

---

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

---

What to check if a User database is locked?

0 Answers   TCS,

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

0 Answers  

---