SQL Vs. T-SQL

Structured Query Language (SQL)	Transact-SQL (T-SQL)
ANSI/ISO Standard DB Language	SQL Server's Implementation of Language
Simple SQL Statements. Managing Data	Extension of SQL. Combination of Multiple Transactions sing multiple SQL Commands Control Flow Language. It controlled by… IF and ELSE BEGIN And END WAITFOR RETURN BREAK WHILE CONTINUE DELETE OR UPDATE can be used with FROM & JOIN Clause BULK INSERT

SSAS Processing Options

The following table contains the Lists of Processing Options available in the SQL Server Analysis Services and which objects they applies to:

Processing Option	Database	Dimension	Cube	Measure Group	Partition	Mining Structure	Mining Model
Process Full	X	X	X	X	X	X	X
ProcessClear	X	X	X	X	X	X	X
ProcessDefault	X	X	X	X	X	X	X
ProcessData		X	X	X	X
ProcessIndexes		X	X	X	X
ProcessUpdate		X
ProcessAdd		X			X
ProcessStructure			X			X
ProcessScriptCache			X
ProcessClearStructureOnly						X