Answer Posted / Anju Kumari

To rebuild an index in SQL Server using 'ALTER INDEX ... REBUILD', you can use the following syntax:nn```sqlnalter index <index_name> on <table_name> rebuild;n```

How do I find the sql server version?

1099

---

What is an indexed view?

1018

---

How to rebuild the master database?

1154

---

How raid can influence database performance?

1104

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1184

---

Explain system functions or built-in functions? What are different types of system functions?

1055

---

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

2291

---

What is the difference between upgrade and migration in sql server?

1170

---

Can sql servers link to other servers like oracle?

907

---

do you know how to configure db2 side of the application? : Sql server database administration

1113

---

Does view occupy space?

1005

---

What is self contained sub query?

1135

---

Can we do dml on views?

1028

---

What is the difference between for xml raw and for xml auto?

1108

---

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

1067

---