{"id":7263,"date":"2014-05-07T00:00:44","date_gmt":"2014-05-07T00:00:44","guid":{"rendered":"http:\/\/craftydba.com\/?p=7263"},"modified":"2016-04-19T20:44:29","modified_gmt":"2016-04-19T20:44:29","slug":"maine-sql-server-user-group","status":"publish","type":"post","link":"https:\/\/craftydba.com\/?p=7263","title":{"rendered":"Maine &#8211; SQL Server User Group &#8211; May 2014"},"content":{"rendered":"<p>I am delighted about the opportunity to present at the <a href=\"http:\/\/maine.sqlpass.org\/en-us\/home.aspx?EventID=1268\">Maine SQL Server User Group<\/a> on May 7, 2014.  This group meets at the Tyler Technologies facility in Yarmouth, ME.<\/p>\n<p>I have not been to Maine since a white water rafting trip on the Kennebec River with <a href=\"http:\/\/crabapplewhitewater.com\/maine\/index.shtml\">Crab Apple<\/a> rafting company in July of 2012.<\/p>\n<p>Two times in the next month I will be visiting this northeastern most state.  <\/p>\n<p>Do not forget to drop by the <a href=\"http:\/\/www.sqlsaturday.com\/293\/eventhome.aspx\">SQL Saturday #293<\/a> event in Portland ME on June 28th.  I look forward to seeing old friends and meeting new ones at the event.<\/p>\n<p>Tonight, I will presenting the following topic.<\/p>\n<p><span style=\"color: #008000\">Topic:<\/span><\/p>\n<p style=\"padding-left: 30px\">Effective use of temporary tables<\/p>\n<p><span style=\"color: #008000\">Abstract:<\/span><\/p>\n<p style=\"padding-left: 30px\">Every developer eventually comes against business logic that can\u2019t be handled with a single simple or complex query. TSQL provides the developer with several constructs that can store temporary result sets that are passed to the next query in the script.<\/p>\n<p style=\"padding-left: 30px\">I will be covering these various TSQL techniques with examples using the [AdventureWorks] database as well as a toy database called AUTOS. The pros and cons of each construct will be examined. Advanced options like enabling trace flag 1118 will be explored.<\/p>\n<p><span style=\"color: #008000\">Coverage:<\/span><\/p>\n<p style=\"padding-left: 30px\">1 &#8211; Derived tables.<br \/>\n2 &#8211; Local temporary tables.<br \/>\n3 &#8211; Global temporary tables.<br \/>\n4 &#8211; Table variables.<br \/>\n5 &#8211; Common Table Expressions (CTE).<br \/>\n6 &#8211; User databases in [tempdb].<br \/>\n7 &#8211; Trace Flag 1118.<\/p>\n<p>Details:<\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2011\/09\/nashua-sql-saturday-146-temporary-tables-by-jminer-20oct2012.zip\">presentation bundle<\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I am delighted about the opportunity to present at the Maine SQL Server User Group on May 7, 2014. This group meets at the Tyler Technologies facility in Yarmouth, ME. I have not been to Maine since a white water rafting trip on the Kennebec River with Crab Apple rafting company in July of 2012. Two times in the next month I will be visiting this northeastern most state. Do not forget to drop by the SQL Saturday #293 event in Portland ME on June 28th. I look forward to&hellip;<\/p>\n","protected":false},"author":1,"featured_media":7269,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[600],"tags":[1067,1071,713,798],"class_list":["post-7263","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pres","tag-john-f-miner-iii--pass--presentation--sql-server","tag-maine-user-group","tag-temporary-tables","tag-user-group"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/7263","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7263"}],"version-history":[{"count":0,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/7263\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/media\/7269"}],"wp:attachment":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}