As like as UPDATE STATISTICS have a many puposes but right now we have a main purpose which is xplain here :
> It is main;y use for the Updates information about the distribution of key values for one or more statistics groups or collections in the specified table or indexed view.

A livelock is a single lock which is bassically work on the request for an exclusive lock is repeatedly denied because a series of overlapping shared locks keeps interfering. A livelock also occurs when read transactions monopolize a table or page, forcing a write transaction to wait indefinitely. When four denials are cmplete then SQL Server detects the situation and refuses further shared locks.

Surrogated keys are always integer or numeric. It is useful because the natural primary key can change and this makes updates more difficult .Surrogate key is the bassically a type of sunsitution key for the primary key . It is just a unique identifier or number for each row that can be used for the primary key to the table. The only requirement for a surrogate primary key is that it is unique for each row in the table..

There are many diffenrt of ways are there which is two different ways to load data in dimension tables.
> Direct (Fast) : It is the bassically use for the loading purpose in this way All the constraints and keys are can be disabled before the data is loaded. Once a tym data is loaded, it is validated against all the constraints and keys. If data is found invalid or dirty it is not included in index and all future processes are skipped on this data.
> Conventional (Slow) : It is bassically for the All the constraints and keys are validated against the data before, it is loaded, this way data integrity is maintained.

Many Diff are there :
> Active/Active : It is the bassically use for the default nodes, Here first node will be default and second node will be named instance. Both node will be active.
> Its Move group from cluster administration is possible for both side.
> System performance will go down, if both resources are in one node.
> Active/Passive : Its also basically use for nodes But in this case Only one Active node with default instance. No system performance degradation will be there for this case even if we switchover to the other node. Both have
same configuration.

ile stream is the bassically use for the store the large amount of data or objects in the file system which is integrated with the database.It is the SQL Server based applications, Its con be enable for server based applications to store unstructured data such as documents, images, audios, videos etc. In the file system. FILESTREAM basically integrates the SQL Srver Database Engine with New Technology File System (NTFS); it basically stores the data in varbinary (max) data type. Using this data type, the unstructured data is stored in the NTFS file system and the SQL Server Database Engine manages the link between the Filestream column and the actual file located in the NTFS. Using Transact SQL statements users can insert, update, delete and select the data stored in FILESTREAM enabled tables.