What versions of Microsoft SQL Server 2005 are available?

There are four versions of Microsoft SQL server 2005. Following is the list

1. Express
2. Workgroup
3. Standard
4. Enterprise


Click for details

What types of indexes are available in Microsoft SQL Server?

Microsoft SQL Server two types of indexes as follows:

1. Clustered Index: This defines physical sorting of the database table rows in the storage.
2. Non-clustered Index: This defines outside the database table. This contains sorted list of database references/pointers.

Note: There are limitations on number of indexes one can define on database table.