What is sparse columns of sql server 2008?

0 Answers  

---

Can foreign key be deleted?

0 Answers  

---

What is the use of group by clause?

0 Answers  

---

How can you append an identity column to a temporary table?

0 Answers  

---

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

---

---

Explain cross join or cartesian product in sql?

0 Answers  

---

List the different types of joins?

0 Answers  

---

Can a table have 2 foreign keys?

0 Answers  

---

Define cross join in sql server joins?

0 Answers  

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  

---

How to create a ddl trigger using "create trigger" statements?

0 Answers  

---

Define constraints and give an example of their use?

0 Answers  

---