Tag: query performance

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

18:48 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

14:31 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

12:06 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

18:01 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

10:35 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

07:00 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

01:12 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

17:23 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

19:20 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

14:54 Database development, Indexes

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