Explain how to maintain a fill factor in existing indexes?

0 Answers  

---

Tell me what is the order in which the sql query is executed?

0 Answers  

---

You are doing log shipping due to some reasons it is failing. How you will proceed from there

0 Answers  

---

How to loop through result set objects using odbc_fetch_row()?

0 Answers  

---

What authentication modes does sql server support?

0 Answers  

---

What is the difference between having clause and where clause in sql server?

0 Answers  

---

what is IDE,DMV in sql server?

1 Answers   Value Labs,

---

Using the customer, and order table in northwind database, please write a query to produce xml?

0 Answers  

---

Is null vs coalesce?

0 Answers  

---

How to update values in a table with update statements in ms sql server?

0 Answers  

---

How will you go about resolving deadlocks?

0 Answers  

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers   Satyam,

---