{"id":577,"date":"2012-04-25T13:24:04","date_gmt":"2012-04-25T13:24:04","guid":{"rendered":"http:\/\/reservoirsw.com\/?p=577"},"modified":"2024-01-06T16:52:58","modified_gmt":"2024-01-06T16:52:58","slug":"may-2012-on-beyond-zebra-adventureworks-or-where-did-i-go-wrong-steve-simon","status":"publish","type":"post","link":"https:\/\/snessug.craftydba.com\/?p=577","title":{"rendered":"May-2012 ~ On beyond Zebra AdventureWorks OR where did I go wrong? ~ Steve Simon"},"content":{"rendered":"<p><a href=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2012\/04\/ss2.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2012\/04\/ss2.jpg\" alt=\"[Steve Simon]\" title=\"Steve Simon\" width=\"150\" height=\"150\" class=\"alignleft size-full wp-image-579\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #800000;\">Presenter:<\/span> Steve Simon<br \/>\n<span style=\"color: #800000;\">Topic:<\/span> On beyond Zebra AdventureWorks OR where did I go wrong?<br \/>\n<span style=\"color: #800000;\">Downloads:<\/span> <a href=\"http:\/\/tinyurl.com\/talkz\">http:\/\/tinyurl.com\/talkz<\/a><br \/>\n<span style=\"color: #800000;\">Mentioned Link:<\/span> <a href=\"http:\/\/elegantcode.com\/2008\/05\/17\/sql-parameter-sniffing-and-what-to-do-about-it\/\">Parameter Sniffing<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>No matter how well planned and executed, the data structures of any data warehouse oft times eventually land up resembling something out of a Dr. Seuss book. In this presentation we shall be looking at and discussing a few of the \u201cperfect\u201d data structures (that I have inherited) and discussing the flaws that have only recently surfaced. We shall be looking at the \u2018before\u2019, discussing a few alternatives to make these structure more efficient and effective, then we shall then look at final \u201cproduction structure\u201d and the resulting improvement metrics; all of which help us to help our clients\u2019 make better decisions in a timely manner.<\/p>\n<p><span style=\"color: #800000;\">Biography:<\/span><\/p>\n<p>Steve Simon is a senior BI engineer with MyWebGrocer. He has been involved with database design and analysis for over 20 years. Steve has presented papers at eight PASS Summits and two at PASS Europe. He has just recently presented a Business Intelligence paper at Oracle World in San Francisco . Steve has also presented 5 papers at the Information Builders&#8217; (IBI) International Summits. He is a PASS regional mentor &#038; chair of the Oracle\/SQL Server VC.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Presenter: Steve Simon Topic: On beyond Zebra AdventureWorks OR where did I go wrong? Downloads: http:\/\/tinyurl.com\/talkz Mentioned Link: Parameter Sniffing &nbsp; &nbsp; No matter how well planned and executed, the data structures of any data warehouse oft times eventually land up resembling something out of a Dr. Seuss book. In this presentation we shall [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[186],"tags":[117,116,20,43,12,118],"class_list":["post-577","post","type-post","status-publish","format-standard","hentry","category-2012-events","tag-bi","tag-datawarehouse","tag-developer","tag-performance","tag-sql-server","tag-steve-simon"],"_links":{"self":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/577","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=577"}],"version-history":[{"count":17,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/577\/revisions"}],"predecessor-version":[{"id":1151,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/577\/revisions\/1151"}],"wp:attachment":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}