What are the differences between “row_number()”, “rank()” and “dense_rank()”?

0 Answers  

---

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 Answers  

---

What is index?

1 Answers   Cap Gemini,

---

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 Answers  

---

How to find out the list schema name and table name for the database?

0 Answers  

---

What is the difference between sdf and mdf?

0 Answers  

---

Does sql server 2000 clustering support load balancing?

0 Answers  

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

What command would you use to add a column to a table in sql server?

0 Answers  

---

What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

0 Answers  

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---