How many types of indexes are available with SQL Server 2005 and SQL Server 2008? MySQL has a variety of options like: Hashed, BTree, etc. What are the choices in SQL Server?
I also want to determine the maximum table size supported and consumed and the type of storage engine SQL Server is using.
Please explain both, 2005 and 2008 professional and express editions.
Best Answer
Note: if you come from MySQL, do not make assumptions about SQL Server. It (like other RDBMS) are more complex and mature then MySQL in many respects