How do you rebuild an identity column?

0 Answers  

---

How to loop through result set objects using odbc_fetch_row()?

0 Answers  

---

What are the types of stored procedures in an sql server?

0 Answers  

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

What is Peer to peer Replication?

1 Answers   CarrizalSoft Technologies, HCL,

---

What is a performance monitor?

0 Answers  

---

What are the commands used in DCL?

0 Answers  

---

Do you know the policy based administration feature of sql server 2008?

0 Answers  

---

What is 4nf in normalization form?

0 Answers  

---

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

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,

---

How to list all tables having unique constraints in any of the columns in a database.

1 Answers  

---