What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

0 Answers  

---

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  

---

How are the unique and primary key constraints different?

0 Answers  

---

Can a database be shrunk with users active?

0 Answers  

---

What are the different types of subquery?

0 Answers  

---

how to invoke a trigger on demand? : Sql server database administration

0 Answers  

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

---

how do we find every fifth record in a table

14 Answers   Aspire, HCL,

---

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  

---

What is @@rowcount in sql?

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,

---