Why foreign key column allowing null values even a parent tables reference key column not having null value..

2 Answers   IBM,

---

How would you choose between a clustered and a non-clustered index?

0 Answers  

---

How to create new tables with "create table" statements in ms sql server?

0 Answers  

---

What are the differences between local and global temporary tables?

0 Answers  

---

What is the difference between local table and global table

1 Answers   CarrizalSoft Technologies, Polaris,

---

---

Explain foreign key in sql server?

0 Answers  

---

What is the filtered index?

0 Answers  

---

Can we execute a stored procedure inside a trigger?

6 Answers   BirlaSoft, CarrizalSoft Technologies, United Healthcare,

---

Explain subquery and state its properties?

0 Answers  

---

What is snapshot replication?

0 Answers  

---

What are different types of Keys? Please explain all the keys with a suitable example.

4 Answers  

---

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

0 Answers  

---