What is difference between count (*) and count 1?

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,

---

Explain table valued parameters in sql server? Why tvp used?

0 Answers  

---

What is the recovery model?

0 Answers  

---

What is ms sql server reporting services?

0 Answers  

---

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---

Which language is supported by sql server?

0 Answers  

---

How to get the number of affected rows?

0 Answers  

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

0 Answers  

---

What is difference between inner join and join?

0 Answers  

---

How to delete existing rows in a table?

0 Answers  

---

How will you make an attribute not process? : sql server analysis services, ssas

0 Answers  

---