Answer / Drishti Bharti

"The UPDATE STATISTICS command in SQL Server is used to rebuild or create statistics for an indexed column. Statistics help the Query Optimizer make better decisions regarding query execution plans, improving performance when running queries involving WHERE, JOIN, GROUP BY, and ORDER BY clauses.

in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?

1 Answers   IBM,

---

What is the usage of the sign function?

1 Answers  

---

What are window functions in sql server?

1 Answers  

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

1 Answers   Verizon,

---

What is indexing explain it with an example?

1 Answers  

---

Does order by actually change the order of the data in the tables or does it just change the output?

1 Answers  

---

What are the main differences between #temp tables and @table variables and which one is preferred?

1 Answers  

---

Define Unique Key?

1 Answers   HCL,

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

explain different types of jions with examples briefly?

3 Answers   Zensar,

---

What is the difference between implicit and explicit transaction?

1 Answers   Beahead Private Limited,

---

Why Master database is required?

1 Answers   Abacus,

---