State a few properties of relational databases?

0 Answers  

---

What is create statement?

0 Answers  

---

Explain “row_number()” in sql server with an example?

0 Answers  

---

What are the differences between sql server and mysql.

0 Answers  

---

SQL Server Architecture ?

0 Answers   IBM, Sapient,

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers  

---

How to update multiple rows with one update statement in ms sql server?

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,

---

Do you know what is rank function?

0 Answers  

---

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

4 Answers   Satyam,

---

What is the STUFF function and how does it differ from the REPLACE function?

2 Answers  

---

what is Full Text Search ?

1 Answers   TCS,

---