Posts From July, 2012

-March 2024+
SMTWTFS
252627282912
3456789
10111213141516
17181920212223
24252627282930
31123456
  • RSS
  • Add To My MSN
  • Add To Windows Live
  • Add To My Yahoo
  • Add To Google

Statistics

  • Entries (106)
  • Comments (0)

Archives

July 18, 2012 David Stein: Have you got the Urge to Merge? 

Monday, July 9, 2012 6:10:00 PM Categories: Meeting

 

The T-Sql Merge statement, introduced in SQL 2008, is powerful, versatile, and performant. However, it is also one of T-SQL's least understood statements. Most DBAs know they can use It to insert, update, and delete data in a target table in a single transaction, generally outperforming separate statements. Fewer know, however, that it can be used to load slowly changing dimensions, facilitate auditing, and for many other uses. Come to the user group meeting and learn the in and outs of T-SQL Merge. I'll even show you how to write complex Merge statements with lightning speed.

 

David Stein is a Senior Business Intelligence Consultant with WaveTwo in Irving, TX. He’s worked in SQL Server Business Intelligence for almost a decade, designed Data Warehouses from scratch, as well as saved projects in serious jeopardy. He is also very active in the community, having spoken at PASS events at all levels, including the PASS Summit, SQL Rally, and at numerous SQL Saturday events and user groups.

 

You can learn more about Data Warehousing, Business Intelligence, and other technical topics on his blog at Made2Mentor.com or follow him on Twitter, @Made2Mentor.

 

 

Food at 6:30

Lecture at 7PM

 

​See you there

​The folks at the Fort Worth SQL Server Users Group

 

​We meet the third Wednesday of most months

 

Site Map | Printable View | © 2008 - 2024 Fort Worth SQL Server Users Group | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund