{"id":8513,"date":"2017-12-09T22:30:00","date_gmt":"2017-12-09T22:30:00","guid":{"rendered":"http:\/\/craftydba.com\/?p=8513"},"modified":"2024-12-26T21:05:41","modified_gmt":"2024-12-26T21:05:41","slug":"providence-sql-saturday-694","status":"publish","type":"post","link":"https:\/\/craftydba.com\/?p=8513","title":{"rendered":"PROVIDENCE \u2013 SQL SATURDAY #694"},"content":{"rendered":"

I am traveling to the North Smithfield to present at SQL Saturday #588<\/a> at Bryant University<\/a>. It will be a good time to meet old friends, make new ones and learn something new.<\/p>\n

I hope you have time to attend this awesome free event on December 9, 2017. Here are the details behind the two presentations that I gave that day.<\/p>\n

\n \n<\/p>\n

First Presentation<\/span><\/strong><\/p>\n

Topic:<\/span><\/p>\n

Effective Data Warehouse Storage Patterns<\/p>\n

Abstract:<\/span><\/p>\n

Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).<\/p>\n

Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.<\/p>\n

How do you reduce the size of your data mart and speed up data retrieval?<\/p>\n

This presentation <\/a>will review the following techniques to fix your woes.<\/p>\n

Coverage:<\/span><\/p>\n

1 \u2013 What is horizontal partitioning?
\n2 \u2013 Database sharding for daily information.
\n3 \u2013 Working with files and file groups.
\n3 \u2013 Partitioned views for performance.
\n4 \u2013 Table and Index partitions.
\n5 \u2013 Row Data Compression.
\n6 \u2013 Page Data Compression.
\n7 \u2013 Programming a sliding window.
\n8 \u2013 What is different in Azure SQL database?<\/p>\n

Details:<\/span><\/p>\n

presentation bundle<\/a><\/p>\n

\n \n<\/p>\n

Second Presentation<\/span><\/strong><\/p>\n

Topic:<\/span><\/p>\n

Full Text Indexing Basics<\/p>\n

Abstract:<\/span><\/p>\n

Today’s large data fields (LDF) are full of unstructured information stored in varchar, text, varbinary or xml data types. How do you write an application to search the column for patterns? Traditional SQL techniques using a column INDEX and LIKE operator result in a query plan that contains a full table scan.<\/p>\n

In this presentation<\/a>, I will be introducing the brother’s grimm database that has the full text of each fairy tale. I will create a full text catalog \/ index, select a change tracking strategy, define optional stop list \/ thesaurus file, and then populate the index. I will use CONTAINS and FREETEXT operators in SELECT queries to leverage the FTI. This resulting query plan performs index seek.<\/p>\n

Coverage:<\/span><\/p>\n

\n1 – Creating a database from scratch.
\n2 – Creating a table with LOB field.
\n3 – Loading files via BULK INSERT.
\n4 – Performance via traditional techniques.
\n5 – Creating a full text index.
\n6 – Performance with the full text index.<\/p>\n

Details:<\/span><\/p>\n

presentation bundle<\/a><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

I am traveling to the North Smithfield to present at SQL Saturday #588 at Bryant University. It will be a good time to meet old friends, make new ones and learn something new. I hope you have time to attend this awesome free event on December 9, 2017. Here are the details behind the two presentations that I gave that day.   First Presentation Topic: Effective Data Warehouse Storage Patterns Abstract: Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on…<\/p>\n","protected":false},"author":1,"featured_media":8359,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[600],"tags":[1118],"class_list":["post-8513","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pres","tag-john-f-miner-iii--pass--presentation--providence--rhode-island--sql-saturday--full-text-indexing--data-warehouse--storage-patte"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/8513","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=8513"}],"version-history":[{"count":1,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/8513\/revisions"}],"predecessor-version":[{"id":10336,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/8513\/revisions\/10336"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/media\/8359"}],"wp:attachment":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8513"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8513"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}