Tag: query optimization

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...
Read More

Different flavors of LINQ queries

Languages & Coding

The current article continues the series about LINQ. The previous part introduced the LINQ technologies and demonstrated its usage on some...
Read More

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 separate article to cover the bases....
Read More