inTune • ISSUE 05 | March 2012
inTune • ISSUE 05 | March 2012
In this Issue
- Want to Win an iPad 3?
- Featured Article: The Hidden Menace of CREATE INDEX
- Events: SQL Server MVP Ami Levin to Speak at 24 Hours of PASS
- Success Story: SmartFreightWare Delivers Top Application Performance With Qure Optimizer
- News: SQL Server Tuning Blog Now Hosted on DBSophic Website
Want to Win an iPad 3?
A big thank-you to the thousands of SQL Server professionals that have downloaded Qure Profiler, our free tool for analyzing and comparing trace files. Every day we hear of really cool Qure Profiler success stories. But we’d love to hear more – and we’re giving away a brand new iPad3 (yes, THREE) in the process!
So tell us how Qure Profiler has helped you, and you’ll be entered into the March 31st raffle.
Featured Article: The Hidden Menace of CREATE INDEX
By SQL Server MVP Ami Levin
Adding indexes to a table to improve data access paths is one of the most effective ways to optimize workload performance. I’m sure you’ve all witnessed first-hand how a carefully crafted index is capable of dropping the duration of a query from hours to just a few seconds. This technique is extremely effective, and relatively low-risk, compared to the alternatives of rewriting the query, redesigning the process, making schema changes or even upgrading the hardware and software. It is so effective, that sometimes we overlook the risks involved with it... Read more >>
Events: SQL Server MVP Ami Levin to Speak at 24 Hours of PASS
“24 Hours of PASS” is organized by the Professional Association for SQL Server and features 24 hours of back-to-back SQL Server related expert sessions. Levin's session, titled "Where are my (primary) keys?", will revisit some of the fundamental design principals of relational databases and the controversies associated with these issues. Levin will discuss the benefits and challenges of using different types of keys from multiple perspectives including data consistency, application development, maintenance, portability, and performance.
For more information about this free event, and to register to Levin's talk, visit the 24 Hours of PASS website.
Success Story: SmartFreightWare Delivers Top Application Performance With Qure Optimizer
Provider of web-based transportation management software uses DBSophic’s Qure Optimizer to tune performance of SQL Server based application.
With the increased adoption of SmartFreightWare’s SmartTMS®, the company has focused on maintaining the highest levels of application performance. “We found that the performance of the underlying SQL Server database was becoming a major bottleneck,” recalls Kurt Hadermann, SmartFreightWare’s CIO. “Timeouts and long-running queries were becoming a concern and adversely impacting system performance”. Read more >>
News: SQL Server Tuning Blog Now Hosted on DBSophic Website
The blog of SQL Server MVP Ami Levin has been migrated to the DBSophic website. The blog covers a range of SQL Server related topics, as Levin explains: “Naturally many of the blog posts deal with performance tuning, database optimization, query tuning, the impact of database design on performance, and similar items. However, I also cover a wider range of topics, including SQL Server 2012, availability, database engine internals and more.” Read more >>