Tags » SQL Performance

SQL Server 2016: The Coolest New Feature – Live Query Stats

This is the first in a series of blog posts about how great SQL Server 2016 is, and why you should all want to upgrade your applications to this platform. 1,331 more words

SQL General

Tối ưu hiệu năng SQL (phần ): Update hay Merge?

Bỏ bê cái series này xem ra cũng đã được 1 thời gian lâu lâu rồi, nay nhân dịp kỉ niệm ngày hậu lễ Va lên thai, 1,028 more words

Sql Server

Exercise in Database Performance Modelling

I have spent the past year doing performance modelling of a new product that is being rolled progressively to clients. The most frustrating thing has the lack of meaningful feedback from the product support group. 411 more words

General

Don't Even use COUNT(*) For Primary Key Existence Checks

In a recent blog post, I’ve advocated against the use of COUNT(*) in SQL, when a simple EXISTS() would suffice. This is important stuff. I keep tuning productive queries where a customer runs a COUNT(*) query like so: 890 more words

Sql

jOOQ Tuesdays: Chris Saxon Explains the 3 Things Every Developer Should Know About SQL

Welcome to the jOOQ Tuesdays series. In this series, we’ll publish an article on the third Tuesday every other month (today, exceptionally on a Wednesday because of technical issues) where we interview someone we find exciting in our industry from a… 2,094 more words

Sql

Why Most Programmers Get Pagination Wrong

Pagination is one of those things that almost everyone gets wrong for two reasons:

  • User experience
  • Database performance

Here’s why.

What’s wrong with pagination?

Most applications blindly produce pagination like this: 1,621 more words

Sql

How to improve business intelligence report and query performance

I have blogged previously about this topic. It is often the most common but most overlooked aspect of building better performing reports using SQL. Reports will perform better if filtering, aggregation and sorting are pushed to data sources as much as possible.

Query