Cursors are evil with Dave Bannatyne
That’s frequent advice given on forums when asking
about performance problems. Its correct advice, but how do you go about
removing cursors and what do you replace them with? That’s the tricky part! By
deconstructing a cursor based routine, Dave will demonstrate a number of TSQL
techniques and how they can be applied to generate a new routine with
significantly less overhead.
Dave is a freelance SQLServer database developer /
designer and has been working in the IT field for over 20 years, the past
15 of which has been specialising within SQLServer environment. Dave regularly
contributes to online forums and is a regular speaker at UK events such as SQL
Bits and user groups. He also is founder of the Kent .NET/SqlServer user
The more I use T-SQL’s Merge statement the more I
love it. It’s fast, powerful, flexible and above all, it provides a world of
opportunities to save me time.
In this session we’ll look at how merge can be used
to perform complex multi-stage tasks such as loading data into data warehouse
dimensions, including the handling of type 0, 1 & 2 slowly changing
We’ll also look at how we can use simple metadata
configuration and dynamic SQL to completely automate the generation of the
merge statement, resulting in a meta-data configurable data warehouse platform.
Alex is the owner and lead consultant at Purple
Frog, a SQL Server Business Intelligence consultancy with clients including
Barclays Capital, Principality and Confused.com. He specialises in dimensional
data modelling, data warehouse design, ETL systems, OLAP cubes, MDX, PowerPivot
and DAX. Alex runs the Birmingham SQL Server user group and the Midlands
SQL Relay events. He has just completed an MSc in Business Intelligence,
writing a thesis on the performance of loading type 2 SCDs into a data warehouse.
He’s also a regular speaker at SQLBits and at various SQL Server user groups
around the UK.
On arrival please sign in at the reception desk and wait in the foyer to
be taken up to the room.
One of the main objectives of the user groups is to intoduce new
speakers, and here at Cardiff we're always looking for to support anyone who
has something interesting to share with the SQL Community. We'll give you all
the encouragement and support you need. We're really flexible so if you only
want to speak for a shorter amount of time, say 15 mins then this is perfectly
fine. If you've be thinking about this, then please get in touch with myself, Adam Morton.