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: 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 02, 2015 10:02 AM by KKline | 0 Comments Filed under: DBA, Internals, IO, Transact-SQL Programming

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

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

• 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 | 0 Comments Filed under: Conferences, PASS, Speaking, SQL Saturday, Transact-SQL Programming

• 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 03, 2014 11:50 AM by KKline | 1 Comments Filed under: DBA, Developer, Hardware, On-line Resources, SQL Server 2012, SQL Server 2014, Transact-SQL Programming

• Learn More About SQL Server IO and Query Tuning in These Webcasts

  Join database expert Kevin Kline in two new webcasts for SQL Server users: Storage IO Best Practices and Query Tuning Best Practices. Read More... Posted Friday, December 14, 2012 1:50 PM by KKline | 5 Comments Filed under: Administration, DBA, Developer, Infrastructure, Internals, IO, Performance, Speaking, SQL Server 2012, Tips, Transact-SQL Programming, Troubleshooting, Video

• Help Me Update the History of SQL Server

  Find out the early history and evolution of Microsoft SQL Server in this engaging article from database expert Kevin Kline. Read More... Posted Wednesday, September 12, 2012 11:01 AM by KKline | 6 Comments Filed under: Administration, Releases, SQL Programming, Transact-SQL Programming

• Flexibility When Waiting on Locks

  An attendee at a recent performance tuning session wanted ideas to more flexibly react to locks on blocks than using the WITH (NOLOCK) hint. Read More... Posted Thursday, May 17, 2012 9:29 AM by KKline | 1 Comments Filed under: Developer, SQL Server 2012, Tips, Transact-SQL Programming

• Dev Advice: Make a Tiny Dev Database Act Like a HUGE Prod Database

  If you're struggling with doing development on a big SQL Server database, learn the ropes on cloned databases asap! Read More... Posted Friday, March 16, 2012 10:30 AM by KKline | 3 Comments Filed under: Best Practices, Developer, SQL Programming, SQLMag, Tips, Tools, Transact-SQL Programming

• Everybody Needs a Test Harness

  Here's a handy little block of T-SQL code to improve code stability. Read More... Posted Monday, October 31, 2011 10:17 AM by KKline | 3 Comments Filed under: Administration, Automation, DBA, Developer, Performance, Transact-SQL Programming, Troubleshooting