Archives for February 2015

ICYMI: Ten Query Techniques Every SQL Programmer Should Know (Video)

February 26, 2015 by 6 Comments

Update 09-Mar-2015: The original PASS links I provided were behind a firewall. Thanks reader MMcDonald, we have a working link on YouTube. One of the benefits of joining PASS is that you get access to their expansive library of conference videos. (Membership is free. So join now. What'dya want, a hand-written invitation?!?) I want to take a moment to point out a good one that I think anybody who writes SQL code on SQL Server should watch. If you know anything about the staff here at SQL Sentry, then you’re probably expecting me and my colleague Microsoft MVP Aaron Bertrand (b | t) to be … [Read more...]

Filed Under: Performance, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Transact-SQL Programming Tagged With: , ,

The SQL Sentry forum for SQL Statement Tuning

February 25, 2015 by Leave a Comment

The SQL Sentry forum for SQL Statement Tuning Have you ever looked at our community site specifically dedicated to helping users tune their SQL queries, http://answers.SQLPerformance.com? You can easily upload an execution plan directly from our free Plan Explorer tool or from good ol' SQL Server Management Studio to the discussion forum.  Once uploaded, our internal team and forum members will provide plenty of tips and input on how to improve the plan and/or explain what the plan is actually doing.  The renown SQL execution plan expert, Paul White (b|t), is the moderator of the site. But … [Read more...]

Filed Under: On-Line Resources, Performance, SQL Server, SQLMag, Tips & Tricks, Transact-SQL Programming Tagged With: , ,

Troubleshooting full-day workshop in Richmond (March) and Configuration full-day workshop in Huntington Beach (April)

February 24, 2015 by 2 Comments

Want to learn more about SQL Server? Now's a good time to get a full day of inexpensive high-quality training on both the east and west coast, in March and April, respectively. I hope you'll join me for a full-day troubleshooting and performance tuning workshop on the Friday preceding the Richmond, VA SQL Saturday in March. And in April, I'll be on the west coast presenting a full-day high-performance configuration tuning workshop preceding the Huntington Beach, CA SQL Saturday. Here are the other events where I'll be speaking: Mar 04, 2015 - Mar 07, 2015, SQLBits XIV - London, … [Read more...]

Filed Under: Conferences, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: ,

ICYMI: Sequences, CPUs, and Trimming T-Logs – SQL Server Performance Topics

February 23, 2015 by 2 Comments

Have you read any of the great articles on SQLPerformance.com? The deep-dive technical info about SQL Server performance issues authored by the SQL Server industry’s top experts. Here are a few great articles from the early days of the website, January 2013:   Generate a set or sequence without loops Aaron Bertrand (b|t) provides detailed performance information about a variety of methods used to generate sets and sequences in this first in a three part series. Selecting a Processor for SQL Server 2012 Glenn Berry (b|t) of SQLskills.com sheds light on the best CPU to select … [Read more...]

Filed Under: Hardware, IO, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Transact-SQL Programming Tagged With: , , , ,