Answer Posted / neel

Establishes the maximum number of SQL Server 2008 instances
that can be created on a server. Enterprise Edition
supports up to 50 instances on a server, Compact Edition
only supports one instance, and all the other editions
support up to 16 instances.

What is the purpose of the model database?

1009

---

What is implicit cursors?

1076

---

What is log shipping?

954

---

What is the bookmark lookup and rid lookup?

991

---

Can we create clustered index on composite key?

1066

---

What is sql language?

1123

---

explain different types of cursors? : Sql server database administration

1078

---

What factors you will consider calculating the storage requirement for that view?

936

---

How to assign null values to variables or columns?

965

---

What are the pre-defined functions in the sql server?

1093

---

explain different levels of normalization? : Sql server database administration

994

---

What is query parameter in ssrs?

160

---

What should be the fill factor for indexes created on tables? : sql server database administration

1129

---

What happens if null values are involved in boolean operations?

980

---

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1881

---