Browse by Tags

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

• 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: Developer, DBA, Transact-SQL Programming, Hardware, On-line Resources, SQL Server 2012, SQL Server 2014

• 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: Performance, Administration, Internals, Speaking, Tips, Troubleshooting, Developer, Infrastructure, DBA, Transact-SQL Programming, SQL Server 2012, Video, IO

• 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: SQL Programming, Releases, Administration, 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: Tips, Developer, Transact-SQL Programming, SQL Server 2012

• 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: SQL Programming, Best Practices, Tips, Tools, Developer, SQLMag, 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: Performance, Administration, Troubleshooting, Developer, Automation, DBA, Transact-SQL Programming