How to Write Complex Queries in SQL
Typical queries in the SELECT * FROM table format are sometimes not enough. When the data for a...
Different flavors of LINQ queries
The current article continues the series about LINQ. The previous part introduced the LINQ technologies and demonstrated its usage on some...
Query Optimization Techniques in SQL Server: 5 Best Practices to Boost Queries Performance
What is query optimization in SQL Server? It’s a big topic. Each technique or problem needs a separate article to cover the bases....
