David Berry Building Performance Metrics into ASP.NET MVC Applications When you're instrumenting an ASP.NET MVC or Web API application to monitor its performance while it is running, it makes... 29 October 2013 23 min read
Nigel Rivett The ETL from Hell – Diagnosing Batch System Performance Issues Too often, the batch systems that underlie a lot of database processing just grow without conscious design. When runs start... 15 October 2013 17 min read
Seth Delconte Introduction to SQL Server Filtered Indexes SQL Server filtered indexes can save space and improve performance if they are used properly. Under what circumstances can they... 19 April 2013 13 min read
Erin Stellato Managing SQL Server Statistics Accurate statistics about the data held in tables are used to provide the best execution strategy for SQL queries. but... 03 April 2013 31 min read
Fabiano Amorim Join Reordering and Bushy Plans Normally, the query Optimiser won't consider 'bushy' plans, where both operands to a join operator could be intermediate results from... 05 March 2013 17 min read
Eugene Philipov Comparing multiple rows insert vs single row insert with three data load methods The performance of 'extract, transform, load' (ETL) processes for large quantities of data can always be improved by objective testing... 21 February 2013 15 min read
Grant Fritchey SQL Server Statistics Questions We Were Too Shy to Ask If you need to optimise SQL Server performance, it pays to understand SQL Server Statistics. Grant Fritchey answers the 18... 12 February 2013 17 min read
Feodor Georgiev How come the Hourglass? Why database applications slow down It is frustrating when you hit 'submit' and you get the hourglass big-time. Is it the database to blame? It... 28 November 2012 12 min read
Louis Davidson Tim Ford Tune Your Indexing Strategy with SQL Server DMVs SQL Server Indexes need to be effective. It is wrong to have too few or too many. The ones you... 11 October 2012 42 min read
Grant Fritchey Why is that SQL Server Instance under stress? There are several reliable indications, using SQL Queries, of the what is causing SQL Server performance problems. Some of these... 11 September 2012 14 min read
Grant Fritchey The Seven Sins against TSQL Performance There are seven common antipatterns in TSQL coding that make code perform badly, and three good habits which will generally... 31 July 2012 15 min read
Alex Kuznetsov Developing Low-Maintenance Databases Alex's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take... 12 June 2012 21 min read
Fabiano Amorim SQL Server Prefetch and Query Performance Prefetching can make a surprising difference to SQL Server query execution times where there is a high incidence of waiting... 21 May 2012 11 min read
Jonathan Kehayias Troubleshooting SQL Server: A Guide for the Accidental DBA Three SQL Server MVPs, and stalwarts of the SQLServerCentral and MSDN community forums, provide fascinating insight into the most common... 29 September 2011 2 min read
Performance Jonathan Kehayias in Performance A Performance Troubleshooting Methodology for SQL Server When healing a sick SQL Server, you must forget the idea that there could ever be a simple correspondence between... 28 September 2011 33 min read
Chris Farrell The Top 5 WPF and Silverlight Gotchas As WPF and Silverlight sit on the .NET framework, they're subject to the rules of the Garbage Collector. That means... 10 August 2011 13 min read
Clive Tong The Top 5 .NET Memory Management Misconceptions .NET Memory management is an impressive and comprehensive system, but it's not flawless, and it's occasionally a little anti-intuitive. As... 27 July 2011 26 min read
Joe Celko Improving Comparison Operators and Window Functions It is dangerous to assume that your data is sound. SQL already has intrinsic ways to cope with missing, or... 01 April 2011 12 min read
Feodor Georgiev The default trace in SQL Server – the power of performance and security auditing Since the introduction of SQL Server 2005, there is a simple lightweight trace that is left running by default on... 14 March 2011 17 min read
Fabiano Amorim Lipoaspiration in your SQL Server Database Once, when disk space was at a premium, DBAs fought hard to keep the size of their database down. Now... 03 March 2011 13 min read
