Query Execution

Everything about Query Execution

1. 
   Article · SQL Server

   Performance Improvements in SQL Server 2025

   SQL Server 2025 boosts performance with smarter query execution, improved CPU scheduling, and reduced locking. Expect greater stability and scalability!

   Mahesh ChandJan 261,2511,000
2. 
   Article · ADO.NET

   Setting Up Your First ADO.NET Project

   ADO.NET is a set of classes that expose data access services for .NET Framework programmers. It provides a rich set of components for creating distributed, data-sharing applications. This guide will walk you through setting up your first ADO.NET project, connecting to a database, and executing simple queries.

   Chetan SanghaniJul 22, 20245,1241,000
3. 
   Article · SQL Server

   SQL: Writing Efficient Queries

   Learn how to optimize SQL queries for better performance with our guide on "SQL: Writing Efficient Queries." Discover techniques for improving query speed, such as indexing strategies, query optimization tips, and best practices.

   Vijay YadavJul 10, 20241,5251,000
4. 
   Article · SQL Server

   Temporary Tables vs Common Table Expressions in SQL Server

   Learn the differences between SQL Server temporary tables and CTEs, including scope, storage, persistence, use cases, and recursive queries.

   Ishika TiwariMar 29, 20244,2371,000
5. 
   Article · LINQ

   Leveraging Compiled Queries for Enhanced Performance in LINQ

   Learn how LINQ compiled queries create reusable delegates, reduce query-compilation overhead, and improve performance for frequently executed or complex queries.

   Alpesh ManiyaMar 9, 20244,3951,000
6. 
   Article · Visual Studio

   Creating Data Application in Visual Studio 2013 Preview

   This article defines how to create a data application in Visual Studio 2013.

   Nimit JoshiJul 17, 20139,5101,000