Tags » SQL Performance

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

jOOQ Tuesdays: Thorben Janssen Shares his Hibernate Performance Secrets

Welcome to the jOOQ Tuesdays series. In this series, we’ll publish an article on the third Tuesday every other month where we interview someone we find exciting in our industry from a… 1,164 more words

Sql

SQL Cursors

I see SQL cursor as a loop on the table. It is highly inefficient, and can result in infinite loops if not used properly. I highly recommend trying other alternatives (like Common table Expressions – CTE’s) if it is possible. 59 more words

How to monitor your instances and SQL Server databases

Monitor instances and SQL Server database provides information needed to diagnose and resolve SQL Server performance, as well as optimize SQL Server. Optimal performance is not easy to set up and configure, since there is usually an exchange between multiple software and hardware factors, also it depends on your environment, business requirements and company policies. 150 more words

Database Backup

Management Data Warehouse

Management Data Warehouse is a very powerful tool for monitoring the SQL Server (CPU, Memory, Disk) on the server, database, and query level.

Configure the Management Data warehouse: 465 more words

SQL Administration