|SQL Server Pro's Tips For Performance Tuning and T-SQL|
|Written by Ian Stirk|
|Tuesday, 13 August 2013|
Do your SQL queries run too quickly? I thought not! Many DBAs don’t know where to start performance tuning. The August issue of SQL Server Pro suggests strategies for achieving peak performance. There's also an article on T-SQL Best Practices which is freely available online.
Do your SQL queries run too quickly? I thought not! Many DBAs don’t know where to start performance tuning. Top 10 SQL Server Performance Tuning Tips in the August issue of the online subscription-based monthly magazine SQL Server Pro has strategies for achieving peak performance. I strongly recommend you read both the article and its links if you want to improve the performance of your SQL queries.
The tips covered include:
In T-SQL Best Practices Itzik Ben-Gan outlines some important practices to follow and the reasoning behind them. Both parts of this article are freely available (i.e. without needing a subscription). In Part 1 his advice is:
In Part 2 he continues:
The article is useful for both new SQL developers and also for experienced developers that want a refresher. At times it can seem a bit pedantic e.g. don’t use the term ‘NULL value’ since NULLs don’t have a value. I may not agree 100% with the suggestions, since some may not always be practical in a commercial environment, but any content from Itzik is always worth reading.
This month’s editorial considers Has Microsoft Gotten Too Far Ahead of Its Customers? Currently Microsoft is pushing cloud (or cloud hybrid) usage and has already started highlighting the next version of SQL Server (2014). Unfortunately, most customers have yet to experiment with the cloud and are stuck on SQL Server 2005 or 2008. A convincing argument is made that while customers want the tech company to be leading edge, consideration should be given to the user’s current needs.
Saurabh Dhoble provides an extensive 16-page article relating to SSIS Deployment Strategy for SQL Server 2012. SSIS is a premier ETL tool, however there are often problems with configuration settings when moving packages across environments (e.g. from development to user testing). The article details how you can ease the deployment of SSIS projects to different environments, and manage their configuration with environment variables.
In VMWare High Availability in SQL Server Denny Cherry discusses the High Availability options that are available as a bi-product of using VMWare’s vSphere on virtual machines. The advantages extend to all versions (e.g. SQL Server 2012) and editions (e.g. standard edition) of SQL Server. This should be particularly of interest for organisations that have a limited budget.
A short series on database corruption begins with SQL Server Database Corruption, Part 1: What is Corruption? The series aims to discuss what corruption is, why you can’t prevent it, and how you can deal with it to ensure availability and uptime. In this first part, corruption is defined as the improper storage of 0s and 1s on the IO subsystem. Corruption is often caused by problem with IO subsystem e.g. drive, controller, or a driver. This 3-page article felt a bit light in content, I suspect it could have been condensed into a single page without loss.
Most technologists eagerly look forward to new editions of their favourite software. There are some mouth watering features highlighted in New Features in SQL Server 2014, including
For me, this month’s magazine was much more enjoyable than recent issues. This might be because it contained some core perennial topics of interest, i.e. performance and best practices. Additionally, the forthcoming SQL Server 2014 looks ‘interesting'.
To be informed about new articles on I Programmer, install the I Programmer Toolbar, subscribe to the RSS feed, follow us on, Twitter, Facebook, Google+ or Linkedin, or sign up for our weekly newsletter.
or email your comment to: email@example.com
|Last Updated ( Tuesday, 13 August 2013 )|