Performance of OBJECT_NAME() & Co.

Performance Myths : Truncate Can't Be Rolled Back

Derik Hammer sets out to disprove another pervasive performance myth : TRUNCATE is faster than DELETE because it isn't logged and can't be rolled back.

Performance Myths: Table variables are always in-memory

Guest author Derik Hammer dismisses the common myth that table variables perform better than temp tables because they are always in memory.

Harmful, Pervasive SQL Server Performance Myths

Aaron Bertrand begins a new series around disproving prevalent myths regarding SQL Server performance.

Finding the Worst Performing TSQL Statement

Greg Larsen explains how you can use Dynamic Management Objects and stored procedures to return your worst performing T-SQL statements.

Performance Surprises and Assumptions : GROUP BY vs. DISTINCT

Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.

How Incorrect SQL Server Table Statistic Estimates Can Cause Slow Query Execution

Ben Snaidero explains that if you are updating your SQL Server table statistics nightly, but still seeing occasional poor performance with some of the queries being executed against my database, statistics could be the issue.

Disconnecting SQL Server connections after query execution

One way to improve SQL Server performance is to use as few resources as possible. In this post Rahul Mehta demonstrates how you can do this by disconnecting queries post-execution with a simple change in SSMS.

5 Advantages of Load Balancing For IT Companies

As an IT company, it is crucial that you maintain uptime and monitor the performance of various processes. By making database load balancing a key element, you can ensure that your processes and websites run smoothly. Tony Branson explains.

Sparse Columns in SQL Server : Impact on Time & Space

Erin Stellato (@erinstellato) looks into sparse columns in SQL Server – the changes to space requirements and the impact on the write portion of your workload.