Answer Posted / satish

8

How do you drop an index?

927

---

Does group by or order by come first?

962

---

What is a cube? : sql server analysis services, ssas

1002

---

What will be the maximum number of indexes per table?

963

---

What is function of master database?

114

---

Explain what is cte (common table expression)?

1136

---

Where do you find the default Index fill factor and how to change it?

1063

---

what's the maximum size of a row? : Sql server database administration

1091

---

Explain user defined functions?

996

---

How would you use user_constraints table in DB?

1008

---

Is sql server implemented as a service or an application? : Sql server database administration

970

---

What is a transact-sql statement batch in ms sql server?

1025

---

How to create dbo table in sql server?

957

---

Can you create a logon trigger in sql server 2005 express edition?

1084

---

What is temporary stored procedure?

949

---