What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---

What is the default Port No on which SQL Server listens?

0 Answers  

---

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

---

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

0 Answers  

---

Write a sql query to delete duplicate records from a table called table1

0 Answers  

---

---

What are tables in sql server?

0 Answers  

---

How can I create a table from another table without copying any values from the old table?

3 Answers  

---

what is the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

---

What you can do to delete a table without the delete trigger firing?

0 Answers  

---

When a primary key constraint is included in a table, what other constraints does this imply?

0 Answers  

---

what is the importence of the trigger in sqlserver2000?

1 Answers   ATI,

---