Tag: query optimization

Different types of LINQ queries: Query Syntax and Method Syntax

Languages & Coding

The current article continues the series about LINQ. The previous part introduced the LINQ...
Read More

How to Write Complex Queries in SQL

Database development, Statements

Typical queries in the SELECT * FROM table format are sometimes not enough. When the data for a query is not in one table, but in several,...
Read More

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

Database administration, Database development, Performance Tuning, Statements

What is query optimization in SQL Server? It’s a big topic. Each technique or problem needs a separate article to cover the bases....
Read More