Perfomance Tuning

USE HINT and DISABLE_OPTIMIZED_NESTED_LOOP

14:54 Database administation, Perfomance Tuning

One of the available algorithms to join two tables together in SQL Server is Nested Loops. The...
Read More

Optimizing Overlapping Queries Part 1: Introduction & Enhanced T-SQL Solution

13:09 Database administation, Perfomance Tuning, Statements

Databases that serve business applications should often support temporal data. For example, suppose a contract with a supplier is valid for...
Read More

Implementing SQL Server Performance Indicator for Queries, Stored Procedures and Triggers

15:49 Database administation, Perfomance Tuning

Preface Sooner or later, a DB administrator would like to have a performance indicator for SQL Server queries. As we all know, running...
Read More

XML performance tips

10:27 Database administation, Perfomance Tuning

Parsing data from XML using XQuery is a routine practice. In order to do this most effectively,...
Read More

Foreach or For – That is the Question

16:40 ASP .NET CORE, Languages & Coding, Perfomance Tuning • 2 Comments

The discussion about the preference difference between FOREACH and FOR is not new. We all know that FOREACH is slower, but not all know...
Read More

Query Performance Insight: Discovering What Consumes Resources of Your Azure SQL Database?

13:29 Azure, Cloud, Database administation, Perfomance Tuning

In this post, I’d like to take a brief look at the Query Performance Insight — SQL Azure tool which will help you to identify the most...
Read More
Close