{"id":415,"date":"2011-11-01T00:00:14","date_gmt":"2011-11-01T00:00:14","guid":{"rendered":"http:\/\/reservoirsw.com\/?p=415"},"modified":"2024-01-06T16:55:09","modified_gmt":"2024-01-06T16:55:09","slug":"nov-2011-partitioning-techniques-andy-novick","status":"publish","type":"post","link":"https:\/\/snessug.craftydba.com\/?p=415","title":{"rendered":"Nov-2011 ~ Partitioning Techniques ~ Andy Novick"},"content":{"rendered":"<p><a href=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2012\/03\/fall-leaves-th.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2012\/03\/fall-leaves-th.jpg\" alt=\"\" title=\"fall\" width=\"125\" height=\"124\" class=\"alignleft size-full wp-image-108\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #800000;\">Presenter:<\/span>  Andy Novick of Novick Software<br \/>\n<span style=\"color: #800000;\">Topic:<\/span> Partitioning Techniques<\/p>\n<p>&nbsp;<\/p>\n<p>Partitioning techniques in SQL Server help the developer and DBA manage large quantities of data and improve query performance in a variety of situations. This presentation demonstrates the techniques used for <\/p>\n<p>Partitioned Tables<br \/>\nPartitioned Views<br \/>\nPartition aligned Indexed Views <\/p>\n<p>Reasons for partitioning in both OLTP and data warehouse applications will be disused along with these topics: <\/p>\n<p>Partitioning Basics<br \/>\nHash Partitioning<br \/>\nAligned vs. unaligned indexes<br \/>\nIndex Views Basic<br \/>\nIndex placement in Aligned and unaligned partitioning <\/p>\n<p>The topics include features from SQL Server 2000, 2005 and new features from 2008. Come learn about these powerful schema design techniques. <\/p>\n<p><span style=\"color: #800000;\">Biography:<\/span><\/p>\n<p>Biography:Andy Novick is a SQL Server Developer in the Boston area with 25 years of database and application development experience. His consulting practice focuses on building applications, including software products that use SQL Server&#8217;s capabilities to the maximum. He has developed both OLTP and data warehouse databases with multi-terabytes scale. He has particular expertise in automating data management for such large databases. Other recent projects have included ETL, Security and SQL Injection prevention. Andy is the originator of the popular &#8220;SQL Server Load-fest&#8221; event conduced in Waltham, MA. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Presenter: Andy Novick of Novick Software Topic: Partitioning Techniques &nbsp; Partitioning techniques in SQL Server help the developer and DBA manage large quantities of data and improve query performance in a variety of situations. This presentation demonstrates the techniques used for Partitioned Tables Partitioned Views Partition aligned Indexed Views Reasons for partitioning in both [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[187],"tags":[96,6,95,93,94,12],"class_list":["post-415","post","type-post","status-publish","format-standard","hentry","category-2011-events","tag-aligned-vs-unaligned","tag-dba","tag-hash-partitioning","tag-partitioned-tables","tag-partitioned-views","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/415","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=415"}],"version-history":[{"count":4,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/415\/revisions"}],"predecessor-version":[{"id":1158,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/415\/revisions\/1158"}],"wp:attachment":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}