Browse by Tags

• Administration
• AlwaysOn
• Automation
• Best Practices
• Conferences
• Database Design
• DBA
• Developer
• Hardware
• Infrastructure
• Internals
• IO
• On-line Resources
• PASS
• Performance
• Releases
• Speaking
• SQL Programming
• SQL Saturday
• SQL Server 2012
• SQL Server 2014
• SQLMag
• Tips
• Tools
• Troubleshooting
• Video

• ICYMI - Predicate Logic, Four Things I Wish I'd Known Sooner, Transact-SQL Bad Habits, Rewriting Queries to Improve Performance

  Some of my favorite articles originally appearing at SQLPerformance.com . Why Not Seek Predicate Paul White ( b | t ) proves, once again, why he is the best in the business when it comes to debugging a SQL Server query. In this post, Paul gives you a Read More... Posted Tuesday, August 4, 2015 8:05 AM by KKline | 1 Comments Filed under: Performance, Transact-SQL Programming, SQL Server 2014

• ICYMI - Recommended Intel Processors For SQL '14, Should Indexes Be In The Key Or Included, Comparing Windows Azure VM Performance

  Some of my favorite articles originally appearing at SQLPerformance.com . Grouped Concatenation in SQL Server and Grouped Concatenation: Ordering and Removing Duplicates In these two related blog posts, Aaron Bertrand ( b | t ) of SQL Sentry takes on Read More... Posted Tuesday, July 28, 2015 8:05 AM by KKline | 1 Comments Filed under: Performance, Transact-SQL Programming, SQL Server 2014

• ICYMI - Adding Filtered Indexes, Wait Statistics, Comparing Windows Azure Performance

  Some of my favorite articles originally appearing at SQLPerformance.com . Dirty Secrets of the CASE Expression Aaron Bertrand ( b | t ) of SQL Sentry takes a look at some unexpected behavior with the CASE expression and some of its derivatives. Did you Read More... Posted Tuesday, July 21, 2015 8:05 AM by KKline | 4 Comments Filed under: Performance, Transact-SQL Programming, SQL Server 2014

• ICYMI - Read Committed Snapshot Isolation, How Automatic Updates to Statistics Can Affect Query Performance, #temp table

  Some of my favorite articles originally appearing at SQLPerformance.com . Read Committed Snapshot Isolation Paul White ( b | t ) has been doing a phenomenal series on SQL Server behavior under each of the major isolation levels. This particular post details Read More... Posted Tuesday, July 14, 2015 8:05 AM by KKline | 3 Comments Filed under: Performance, Transact-SQL Programming, SQL Server 2014

• ICYMI - Avoiding Performance Tuning, Wait Statistics, Incremental Statistics

  Some of my favorite articles originally appearing at SQLPerformance.com . Avoiding Knee-Jerk Performance Tuning Paul Randal of SQLskills.com starts a new series on knee-jerk troubleshooting, discussing many areas where SQL Server folks jump to conclusions Read More... Posted Tuesday, July 7, 2015 8:00 AM by KKline | 1 Comments Filed under: Performance, Transact-SQL Programming, SQL Server 2014

• ICYMI: Partitioning Advice, Purging Data Bloat, and an example of TVF Misbehavior - SQL Server Performance

  Here are some oldies, but goodies that I recommend you read: Two Partitioning Peculiarities and Aggregates and Partitioning Most of us know that partitions are one of the best ways to scale very large databases or very large IO workloads. However, there Read More... Posted Monday, March 30, 2015 10:24 AM by KKline | 11 Comments Filed under: SQL Programming, Internals, Troubleshooting, PASS, Database Design, Developer, DBA, Transact-SQL Programming

• ICYMI: Query Optimization Phases, Observer Overhead, and Secrets of SP_Updatestats - SQL Server Performance

  Do you do a bit of query tuning? Then check out this treasure trove of performance tuning advice! Optimization Phases and Missed Opportunities and Working Around Missed Optimizations Paul White ( b | t ) writes two fascinating blog posts that go hand-in-hand Read More... Posted Monday, March 23, 2015 10:20 AM by KKline | 1 Comments Filed under: Performance, SQL Programming, Developer, Transact-SQL Programming

• ICYMI: Troubleshooting CPU, Logging Myths, Missing Indexes, and Query Tuning Examples

  Great Articles at SQLPerformance.com There are so many good articles from SQLPerformance.com this ICYMI article that it’s hard to know which are best to highlight in the limited space. So, I’ll be arbitrary and simply choose a few of my favorite entries Read More... Posted Monday, March 16, 2015 10:08 PM by KKline | 1 Comments Filed under: Performance, SQL Programming, Troubleshooting, Database Design, Developer, Transact-SQL Programming

• ICYMI: Troubleshooting Availability Groups and the Schema Switcharoo - SQL Server Performance

  Cool and informative articles about SQL Server performance relating to Troubleshooting Availability Groups and the Schema Switcharoo. Read More... Posted Monday, March 9, 2015 11:08 AM by KKline | 1 Comments Filed under: Internals, Troubleshooting, DBA, Transact-SQL Programming, AlwaysOn

• ICYMI: the Halloween Problem and DBCC CheckConstraints - SQL Server Performance

  Cool and informative articles about SQL Server performance relating to IO caused by the DBCC CheckConstraints command and exploring the infamous Halloween Problem. Read More... Posted Monday, March 2, 2015 10:02 AM by KKline | 6 Comments Filed under: Internals, DBA, Transact-SQL Programming, IO

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

  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 Read More... Posted Friday, February 27, 2015 10:44 AM by KKline | 5 Comments Filed under: Developer, DBA, Transact-SQL Programming, Video

• The SQL Sentry forum for SQL Statement Tuning

  Check out this community website dedicated to helping SQL programmers tune their most difficult and problematic queries. Read More... Posted Wednesday, February 25, 2015 11:48 AM by KKline | 7 Comments Filed under: Performance, SQL Programming, Developer, Transact-SQL Programming

• ICYMI: Sequences, CPUs, and Trimming T-Logs

  Cool and informative articles about SQL Server numeric sequences, choosing CPUs, and trimming the T-Log. Read More... Posted Monday, February 23, 2015 10:38 AM by KKline | 1 Comments Filed under: DBA, Transact-SQL Programming, Hardware

• Join Me at the Ft. Lauderdale SQL Saturday on June 14, 2014!

  If you're in South Florida, read the details about the upcoming SQL Saturday and Kevin's full day pre-conference seminar on Friday, June 13. Read More... Posted Wednesday, May 21, 2014 10:01 AM by KKline | 1 Comments Filed under: Speaking, PASS, Conferences, Transact-SQL Programming, SQL Saturday

• Amazingly Useful SQL Server Articles on SQLPerformance.com

  Ever wonder which specific T-SQL pattern is best for splitting strings? There are lots of ways to calculate running totals, but which is optimal? What CPUs are best for SQL Server 2012? For SQL Server 2014? Find out more in this post from Kevin Kline. Read More... Posted Monday, March 3, 2014 11:50 AM by KKline | 3 Comments Filed under: Developer, DBA, Transact-SQL Programming, Hardware, On-line Resources, SQL Server 2012, SQL Server 2014