Ecotourism, also known as ecological tourism, is a form of tourism that appeals to ecologically and socially conscious individuals. Generally speaking, ecotourism focuses on volunteering, personal growth, and learning new ways to live on the planet. It typically involves travel to destinations where flora, fauna, and cultural heritage are the primary attractions. Responsible ecotourism includes programs that minimize the negative aspects of conventional tourism on the environment and enhance the cultural integrity of local people. Therefore, in addition to evaluating environmental and cultural factors, an integral part of ecotourism is the promotion of recycling, energy efficiency, water conservation, and creation of economic opportunities for the local communities

Non-clustered index. Important thing to note: By default a clustered index gets created on the primary key, unless specified otherwise.An isolation level determines the degree of isolation of data between concurrent transactions. The default SQL Server isolation level is Read Committed. Here are the other isolation levels (in the ascending order of isolation): Read Uncommitted, Read Committed, Repeatable Read, Serializable. See SQL Server books online for an explanation of the isolation levels. Be sure to read about SET TRANSACTION ISOLATION LEVEL, which lets you customize the isolation level at the connection level. CREATE INDEX myIndex ON myTable(myColumn)

Indexes are of two types. Clustered indexes and non-clustered indexes. When you craete a clustered index on a table, all the rows in the table are stored in the order of the clustered index key. So, there can be only one clustered index per table. Non-clustered indexes have their own storage separate from the table data storage. Non-clustered indexes are stored as B-tree structures (so do clustered indexes), with the leaf level nodes having the index key and it's row locater. The row located could be the RID or the Clustered index key, depending up on the absence or presence of clustered index on the table.

Each Non-clustered table has a data segment. All of the table's data is stored in the extents of its data segment. Each cluster has a data segment. The data of every table in the cluster is stored in the cluster's data segment.

The difference is that, Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index. Whereas in case of non-clustered index the leaf level is actually a pointer to the data in rows so we can have as many non-clustered indexes as we can on the db.

Five for the database as a whole, one for each table.