It is recommended to Full process the cube whenever there is structural change in SSAS. But I believe we can get the same results if we process the related dimensions and measure groups. This will give us some saving in processing time for big cubes....

1. To create a unique clustered index on view, The view must be created using schema binding. The SELECT statement in the view cannot contain these Transact-SQL syntax elements: * the select list cannot use the * or table_name.* syntax to specify column...

Float is approximate data type with default 15 digits precision, if not exclusively declared. its rounding to nearest IEEE FP, when you convert to decimal. So we may see different value at lowest side while storing more then 15 digits in default float....

Hi, My take on temp table / table variables **Advantage Table Variable** 1. Data usage is small. 2. Capture rollback transaction data for table (Only way). 3. Can be passed to SP (input /output parameter), Function table valued function. 4. ...