Joe Longtin

Joe Longtin

Total Posts: 14
Channel 9 Blog for Joe Longtin
page 1 of 2

Demo SQL Server Star Join Query to Excel Pivot Table

Posted By: Joe Longtin | Jul 1st @ 4:11 PM | Comments: 1
Demo SQL Server Star Join Query to Excel Pivot Table
In this screencast, Eric uses a typical DW query along with Microsoft Excel to create reports.

 

[more ]
Tags: Data Warehousing, demo series, Eric Hanson, Reporting

Demo SQL Server Manual Query Rewrites vs. Indexed View Matching

Posted By: Joe Longtin | Jul 1st @ 4:11 PM | Comments: 0
Demo SQL Server Manual Query Rewrites vs. Indexed View Matching
When should you manually rewrite queries to capitalize on aggregates rather than rely on SQL Server's Query Optimizer, to generate more efficient query plans? This screencast provides tips on how to experiment with both methods for best results.

[more ]
Tags: Data Warehousing, demo series, Eric Hanson

Demo SQL Server Aggregate Query Rewrites with Indexed Views

Posted By: Joe Longtin | Jul 1st @ 4:10 PM | Comments: 0
Demo SQL Server Aggregate Query Rewrites with Indexed Views
This technique helps you to accelerate query performance for SQL Server 2000, 2005 and 2008, by taking advantage of indexed views.

[more ]
Tags: Data Warehousing, demo series, Eric Hanson

Demo SQL Server 2008 Partition-aligned Indexed Views

Posted By: Joe Longtin | Jul 1st @ 4:10 PM | Comments: 0
Demo SQL Server 2008 Partition-aligned Indexed Views
Speed up query performance on very large fact tables. Partitioning and indexing now complement each other.  

[more ]
Tags: Data Warehousing, demo series, Eric Hanson

Demo SQL Server 2008 Grouping Sets

Posted By: Joe Longtin | Jun 30th @ 4:33 PM | Comments: 0
Demo SQL Server 2008 Grouping Sets
Simplify queries that require grouping or aggregation. Using Grouping Sets reduces repetitive scans of the same data and improves performance.

[more ]
Tags: Data Warehousing, demo series, Eric Hanson

Demo SQL Server 2000/2005 Few Outer Rows Workaround

Posted By: Joe Longtin | Jun 30th @ 4:32 PM | Comments: 0
Demo SQL Server 2000/2005 Few Outer Rows Workaround
What can I do if I am using SQL Server 2000 or 2005, and I want to do a more efficient join between a date dimension and a large fact table? Eric Hanson, principal program manager for SQL Server data warehousing, walks through creation of a workaround.

[more ]
Tags: Data Warehousing, demo series, Eric Hanson

Demo SQL Server 2008 Few Outer Row Joins

Posted By: Joe Longtin | Jun 30th @ 2:35 PM | Comments: 0
Demo SQL Server 2008 Few Outer Row Joins
Automatically leverage parallel processing when joining dimensions to the fact table.  Each outer row gets a separate thread on a nested loop join and all available cores share the workload.

[more ]
Tags: Data Warehousing, demo series, Eric Hanson

Demo SQL Server 2008 Partitioned Table Parallelism

Posted By: Joe Longtin | Jun 30th @ 2:18 PM | Comments: 1
Demo SQL Server 2008 Partitioned Table Parallelism
Make the most of your available hardware resources through intelligent parallel processing against partitioned tables. SQL Server automatically assigns queries to all available threads. All cores share the workload equally to scan qualifying partitions, process and deliver results.

[more ]
Tags: Data Warehousing, demo series, Eric Hanson

Demo SQL Server 2008 Star Join Query Optimization

Posted By: Joe Longtin | Jun 30th @ 2:17 PM | Comments: 0
Demo SQL Server 2008 Star Join Query Optimization
Get more performance out of your star schema data model. Automatic star join query optimization dramatically improves performance by efficiently filtering out non-qualifying fact table rows early in the query plan.

[more ]
Tags: Data Warehousing, demo series, Eric Hanson

Demo SQL Server 2008 Change Data Capture

Posted By: Joe Longtin | Jun 29th @ 5:30 PM | Comments: 0
Demo SQL Server 2008 Change Data Capture
Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008. Use Change Data Capture to easily capture changes from your source database and accelerate ETL to the data warehouse.[more ]
Tags: Data Warehousing, demo series, Eric Hanson
page 1 of 2
Microsoft Communities