inTune • ISSUE 07 | July 2012

inTune • ISSUE 07 | July 2012


www.dbsophic.com

In this Issue


Article: Every Question has Many Answers.. But Only One Default

By SQL Server MVP Ami Levin

Recently, a user on the Hebrew SQL Server MSDN Forum posted a deisgn question. Here it is, litterally translated from Hebrew:

ERD"Hi,

  • Every Question can have a few Answers
  • For every Answer there is a field (IsDefault) indicating whether or not this is the Default Answer
  • I want to make sure there is no more than one default answer per question

My question is whether this can be enforced only when inserting a value, or is it possible to enforce this rule via the schema definition. Thanks..."

A few people replied and suggested various solutions. First, I would like to say that all solutions for enforcing the requirement to have only one default answer per question that are based on adding business logic rules as DML in the form of triggers, UDF in check constraints, filtered indexes, indexed views and the likes may work very well. However, in my humble opinion, using such solutions is essentially covering up the root issue here which is the data model. Read more >>


Qure Profiler v1.5 is Generally Available

We are proud to announce that Qure Profiler version 1.5 is now generally available. The release delivers many new features and improvements. These include full SQL Server 2012 support, the ability to handle very large workloads, integration with SQL Sentry Performance Advisor, improved management of analyzed workloads, advanced filtering and sorting capabilities and much more.

We'd like to thank all of the many beta participants who contributed valuable testing and feedback for the Qure Profiler v1.5 beta.

To download the new version (free as always), please visit the Qure Profiler download page.


The DBA, the Needle and the Haystack

A new 2-minute video about workload tuning with Qure Optimizer - sure to make you smile!

Download your FREE trial of Qure Optimizer!


Tip: Using SQL Sentry's Free Plan Explorer to Find Nagging Query Issues

By Aaron Bertrand, SQL Server MVP

In 2010, SQL Sentry introduced to the SQL Server community a free tool called Plan Explorer. This tool is designed to make it much easier to interpret execution plans than you can do with the native functionality found in SQL Server Management Studio. While some of the features are instantly obvious, such as color highlighting of expensive nodes, some others are a little more obscure. And it is not necessarily automatic to correlate those details with the actual problem they're highlighting. So I thought I would take a few moments and point out a couple of nagging query issues that Plan Explorer calls out for you. Read More >>