Differentiate between sql temp table vs table variable?

0 Answers  

---

What is the New in SQL server 2008?

0 Answers  

---

What is the difference between a fill factor of 100 and 0?

0 Answers  

---

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,

---

How to disable a login name in ms sql server?

0 Answers  

---

Where is trigger in sql server?

0 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

0 Answers  

---

What happens if you delete a table that is used by a view?

0 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

0 Answers  

---

What are partitioned views?

0 Answers  

---