Why de-normalization required?

0 Answers  

---

How many types of local tables are there in sql server?

0 Answers  

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---

What is sql profiler. What are the default templates with it? : sql server database administration

0 Answers  

---

Write an sql query to find the names of employees start with ‘a’?

1 Answers  

---

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

---

What is nolock hint in sql server 2008

0 Answers   HCL,

---

What is intellisense?

0 Answers  

---

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

---

Can we perform backup restore operation on tempdb?

0 Answers  

---

Can I remove the default constraint columns in SQL SERVER?

5 Answers   Value Labs,

---