Tag: query performance

Query Optimization Techniques in SQL Server: 5 Best Practices to Boost Queries Performance

Database administation, Database development, Perfomance Tuning, Statements

What is query optimization in SQL Server? It’s a big topic. Each technique or problem needs a...
Read More

9 Best Practices for Writing SQL Queries

Database administation, Database development, Perfomance Tuning, Statements

If you are reading this article, most probably, you are already familiar with SQL. You know how to write basic SQL queries. There are many...
Read More

Virtual Columns and Functional Indexes

Database development, Indexes, Tables

Much too often, we see poorly written complex SQL queries running against the database tables. Such queries may take a very short or a very...
Read More

SQL Server Indexes Management Using Index Manager for SQL Server

Database development, Indexes, Tools & technologies, Utilities & Extensions

SQL Server Index Overview When talking about SQL Server performance tuning and queries enhancement,...
Read More

3 Nasty I/O Statistics That Lag SQL Query Performance

Database administation, Perfomance Tuning • One Comment

“But it ran fine on our development server!” How many times did I hear it when SQL query performance issues occurred here and there? I...
Read More

Parameter Sniffing Primer

Database development, Stored Procedures

Introduction Developers are often told to use stored procedures in order to avoid the so-called ad hoc queries which can result in...
Read More

Auto Create Statistics and Auto Update Statistics

Languages & Coding, SSMS, T-SQL, Tools & technologies

Statistics comprises lightweight objects that are used by SQL Server Query optimizer to determine...
Read More

Advanced SQL: CROSS APPLY and OUTER APPLY

Database development, Statements

In this article, we’ll look into the “APPLY” operator and its variations – CROSS APPLY and OUTER APPLY along with examples of...
Read More

Essentials and usage of NOLOCK hint in SQL Server

Database administation, Security

The main idea of the SQL Server locking mechanism is that it controls the consistency of transactions. According to this principle, if a...
Read More

Query Store: Showing the Impact of Indexes on Inserts

Database development, Indexes

Introduction It is common knowledge in database circles that indexes improve query performance...
Read More
Close