Search this blog

Thursday, July 8, 2010

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

Friday, July 2, 2010

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