Tag Archives: 70-451

MCITP 70-451 Links Page

I have been asked a few times if there was a landing page for the 70-451 posts and figured that such a page would probably be more helpful than just the tags post.  So, without further ado, here is the … Continue reading

Posted in SQL | Tagged , | 12 Comments

70-451–MCITP–Wrap Up

Wrap Up I have been preparing for this test for some time and really the thing that I was the most concerned about was the fact that I had probably forgotten a lot of the information that I had reviewed … Continue reading

Posted in SQL | Tagged , | 6 Comments

70-451–MCITP–Designing a Database for Optimal Performance–Design a Table and Index Partitioning Strategy

Requirements Design a table and index partitioning strategy.This objective may include but is not limited to: switching partitions, merging, splitting, staging, creating, schemes and functions My Take I had to do a lot of research into partitioning for one of … Continue reading

Posted in SQL | Tagged , , | 1 Comment

70-451–MCITP–Designing a Database for Optimal Performance–Design a Table and Index Compression Strategy

Requirments Design a table and index compression strategy.This objective may include but is not limited to: row vs. page, update frequency, page compression implementation, compressing individual partitions My Take In this section we’ll take a look at the enterprise only … Continue reading

Posted in SQL | Tagged , | 1 Comment

70-451–MCITP–Designing a Database for Optimal Performance–Resolve Performance Problems by Using Plan Guides

Requirements Resolve performance problems by using plan guides.This objective may include but is not limited to: object plan guides, SQL plan guides, templates plan guides, dynamic management views My Take It seems to me that we will simply be exploring … Continue reading

Posted in SQL | Tagged , , , | 1 Comment

70-451–MCITP–Designing a Database for Optimal Performance – Design Scalable Database Solutions

Requirements Design scalable database solutions.This objective may include but is not limited to: scale up vs. scale out, federated databases, distributed partitioned views, scalable shared databases, replication, offloading read-only query (database mirroring) My Take In this section we will very … Continue reading

Posted in SQL | Tagged , , , , , | 1 Comment

70-451–MCITP–Designing a Database for Optimal Performance–Optimize Indexing Strategies

Requirements Optimize indexing strategies. This objective may include but is not limited to: table-valued function, views, filtered indexes, indexed views, clustered and non-clustered, unique My Take I feel like this section is a strange one. I’m not sure that I … Continue reading

Posted in SQL | Tagged , , | 2 Comments

70-451–MCITP–Designing Queries for Performance–Evaluate the use of Row-based Operations vs. Set-based Operations

Requirements Evaluate the use of row-based operations vs. set-based operations.This objective may include but is not limited to: row-based logic vs. set-based logic, batching, splitting implicit transactions My Take In this section we will go over some of the reasons … Continue reading

Posted in SQL | Tagged , , | 1 Comment

70-451–MCITP–Design Queries for Performance–Analyze Execution Plans

Requirements Analyze execution plans.This objective may include but is not limited to: execution order, logical and physical operators, join operators, minimize resource costs, compare query costs My Take Execution Plans are one of the best tools we have for investigating … Continue reading

Posted in SQL | Tagged , , , | 2 Comments

70-451–MCITP–Designing Queries for Performance–Optimize and Tune Queries

Requirements Optimize and tune queries. This objective may include but is not limited to: optimizer hints, common table expressions (CTEs), search conditions, temporary storage, GROUP BY [GROUPING SETS|CUBE|ROLLUP] My Take The task of optimizing and tuning queries is something which … Continue reading

Posted in SQL | Tagged , , | 4 Comments