Sql Server Q&A

1. How to check Sql Server version ?
- SELECT @@VERSION

2. What is a Heap Structure in SQL Server ?
- Heap Structure in Sql Server means the data will be stored in the table where ever it finds a space. Hence there is no order of data getting inserted in a table.

3. Diff : clustered index and nonclustered index

A clustered index is a special type of index that reorders the way records in the table are physically
stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain
the data pages.

A nonclustered index is a special type of index in which the logical order of the index does not match
the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of
the data pages. Instead, the leaf nodes contain index rows.

4. Types of functions in sql server

a) System Functions (eg. AVG() , MAX() etc..)

b) User Defined Functions
1) Scalar Functions (returns a single value)
2) In-Line table valued Functions (returns a table )
3) Multi-statement table valued Functions (returns a table)