Answer / Mayank Singh

"The maximum number of indexes per table in SQL Server depends on the edition and the storage engine used. For example, in SQL Server Express (a free version), the maximum limit is 999 indexes. In higher-end editions like Standard, Enterprise, or Developer, the limit can be up to 2499."

Can we write trigger for view?

1 Answers  

---

Explain concepts of analysis services?

1 Answers  

---

Can we use pragma autonomous_transaction in trigger?

1 Answers  

---

What are rows and columns?

1 Answers  

---

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

---

What are different types of views?

1 Answers  

---

what is the difference between a primary key and a unique key? : Sql server database administration

1 Answers  

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

1 Answers   HCL,

---

How to create hyperlink from returned sql query ?

1 Answers   MCN Solutions,

---

What are recommended options to be used while using db mirroring? : sql server database administration

1 Answers  

---

what are the different ways to return the rowcount of a table?

1 Answers   Microsoft,

---

What is the difference between a "where" clause and a "having" clause?

1 Answers  

---