Answer Posted / rahul

A) Creating a clustered index on a table re-arranges the data in a sequential manner. while creating clustered index, certain guidelines must be followed. They are:

1) Queries should return a range of values by using operators such as, BETWEEN, > , >= , < and <=.

B) Non-clustered index is created on a table, the data is not physically re-arranged in sequential order.

Please explain go command in sql server?

1107

---

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

1032

---

How to apply filtering criteria at group level with the having clause in ms sql server?

1042

---

between cast and convert which function would you prefer and why?

1010

---

What are exact numeric data types in ms sql server?

1134

---

Explain the steps needed to create a scheduled job?

976

---

What is log cache in sql server?

1094

---

What is attribute hierarchy? : sql server analysis services, ssas

1060

---

List out the differences between global and local temp tables in sql server?

1108

---

How to create an inline table-valued function?

1015

---

How can we rewrite sub-queries into simple select statements or with joins?

1026

---

what is a check constraint?

1167

---

Can primary key be a foreign key?

1106

---

How to view existing indexes on an given table using sp_help?

1199

---

Find first and last day of current month in sql server

1080

---