Thomas.I Microsoft BI & Analytics

A Site Dedicated to General BI Issues and MS BI Issues: Architecture and Technology

Archive for the ‘SSIS and SQL Server’ Category

Check your TSQL update statements

Posted by thomasivarssonmalmo on May 4, 2008

This is an important blog post about the limitations in TSQL update when you join with other tables.
Seems like I have used this TSQL "enhancement" myself without knowing the limitations.
The blog post points to the new merge statement in SQL Server 2008 and some other solution.
There is another non-ANSI standard solution with update CTE(Common table expressions) that is mentioned in the TSQL Querying book that I have linked to on my blog.
I have a simple example here where I update a key in the first table with a key from the second table.
(Select t1.MyDimKey as SetMyDimKey, t2.MyDimKey as GetMyDimKey
From Table1 as t1 join Table2 as t2 On
t1.MyDimKey = t2.MyDimKey)
Set SetMyDimKey = GetMyDimKey
Why did I not read about this earlier?
What have I been doing during the last month?
I am currently using most of my professional time and some hours after work to learn more about Performance Point Monitoring and Analytics. The time for writing here have been limited during the last month. Still this geeky blog had 15 thousand hits since I started 12 months ago.
I cannot compete with Vidas or Chris Webb since I only write about what come across my mind in the MS-BI area. These guys covers everything about SSAS and MDX with links, blog posts and personal comments. 
It is great that my blog posts on attribute relations have increased the number of visits during the last months.
A new area of interest of mine is the data mining components for Excel 2007 which requires you to learn more about DM. Even if these components give you an eay way to analyze data and see new patterns you will always get a questions about the result and theory behind it.
Thanks to Vidas, Chris Webb, Darren Gosbell and Mosha for posting comments here. And thanks to all others as well.

Posted in SSIS and SQL Server | 2 Comments »