Answer Posted / dilipkumar

there are 1 clustered index and...
in 2008 sql server total 249 non clustered index
in 2010 sql server total 999 non clustered index
in 2012 sql server total 999 non clustered index.

Is null in sql server?

980

---

What is NOT NULL Constraint in sql server 2012?

981

---

Name three of the features managed by the surface area configuration tool? : sql server security

986

---

What is partition index in sql server?

1110

---

How to send email from database?

1008

---

How to rebuild the master database?

1074

---

What is create command?

962

---

How to delete a login name in ms sql server?

1064

---

Name some of the open source software that you can use in alternative to SSR?

159

---

Explain sql server authentication modes?

1120

---

How to recompile stored procedure at run time?

1064

---

What is tcl in sql server?

1113

---

Describe the left outer join & right outer join. : sql server database administration

990

---

How many types of the database links?

1064

---

what is denormalization? : Sql server database administration

920

---