Articles tagged Performance

Ben Johnston in Blogs

Friendly Deletes in SQL Server

One of the first things you learn when working with SQL Server, and other transactional based SQL systems, is that set based operations perform best....

01 March 2024 24 min read

T-SQL Programming

Uwe Ricken in T-SQL Programming

Heaps in SQL Server: Part 4 PFS contention

When inserting rows into a heap, SQL Server must sometimes update the PFS page which can PFS contention and affect performance. In this article, Uwe...

05 January 2021 14 min read

Jonathan Lewis

Hacking Indexes

Indexes are expensive to maintain so we want to get the greatest benefit we can from them and make sure that Oracle uses them whenever...

03 October 2016 14 min read

Dwain Camps

Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008

Percentiles give meaning to measurements by telling you the percentage of the population being measured who get higher or lower values. They are now easier...

18 May 2015 27 min read

Dennes Torres

Optimizing Batch Process in SQL Server

SQL Server batch processes are usually run from SQL Agent in background. They can take significant time and resources, especially if they are ETL tasks....

08 May 2015 32 min read

Dennes Torres

Identifying and Solving Index Scan Problems

When you're developing database applications, it pays to check for index scans in the SQL Server query plan cache. Once you've identified the queries, what...

10 March 2015 24 min read

.NET

Jon Smith in .NET

The Compromise Between Development Time and Performance in Data-Driven ASP.NET MVC

As developers we always want to produce efficient code, but efficient in what - development time or overall performance? In this article Jon Smith describes...

03 March 2015 22 min read

Dino Esposito

RWD, Mobile-first, JavaScript and Performance

The easiest way to make a responsive web application perform well is to minimize requests and the amount of data that is downloaded. The most...

28 February 2015 11 min read

Jonathan Watts

The Promise – and the Pitfalls – of In-Memory OLTP

When SQL Server 2014 was released, it included Hekaton, Microsoft's much talked about memory-optimized engine that brings In-Memory OLTP into play. With memory-optimized tables 30...

04 February 2015 7 min read

Michael K Campbell

The Importance of Caching

Performance tuning and optimization definitely have their place in minimizing SQL Server Licensing costs - by helping keep CPU utilization low. But it's important to...

04 February 2015 15 min read

Grant Fritchey

Why Developers Need to Understand Execution Plans

As a coder, the more you know about the business, the better code you're going to write. The more you know about the language in...

12 January 2015 30 min read

Tony Davis

Optimizing Transaction Log Throughput

As a DBA, it is vital to manage transaction log growth explicitly, rather than let SQL Server auto-growth events "manage" it for you. If you...

08 May 2014 35 min read

Dwain Camps

The Performance of Traversing a SQL Hierarchy

Dwain Camps show that, depending on the size and characteristics of some hierarchical data, six different methods of traversal can each be the fastest at...

28 April 2014 16 min read

Robert Sheldon

14 SQL Server Indexing Questions You Were Too Shy To Ask

One of the first things one needs to understand well about SQL Server is indexes, but somehow many of the basic questions don't often get...

25 March 2014 22 min read

Dwain Camps

High Performance Relational Division in SQL Server

Relational division is used in SQL to select rows that conform to a number of different criteria. It is a neglected but effective technique for...

24 March 2014 28 min read

Joshua Feierman

Applying The Scientific Method to SQL Server Performance Tuning

Database administrators tend to rely more on science than intuition, and may therefore seem exasperatingly cautious to other IT people. A relational database is a...

10 March 2014 14 min read

Fabiano Amorim

Fixing Cache Bloat Problems With Guide Plans and Forced Parameterization

Imagine it. You've been asked to fix a dire performance problem with a SQL Server database. You find a severe case of 'Cache Bloat' due...

20 February 2014 10 min read

Gail Shaw

SQL Server Deadlocks by Example

When a SQL Server instance deadlocks, it can be anything from minor irritation to something far more severe. In this article, Gail Shaw looks at...

16 January 2014 54 min read

Alex Kuznetsov

Lessons Learned from Six Years of Agile Database Development

Alex Kuznetsov describes the agile principles, techniques and tools that allowed his development team to make frequent database refactoring a reality, without disrupting users. He...

19 November 2013 26 min read

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 sense to use custom performance...

29 October 2013 23 min read