Queries

Content
People

Sort By Search Results

Construct List Using XOR Queries – Efficient Reverse Processing ApproachJun 16, 2026. Efficiently construct a list using XOR queries by processing in reverse. Avoids costly array updates with bit manipulation.
How to Handle Duplicate Records in SQL Queries EfficientlyApr 20, 2026. Master SQL duplicate record handling! Learn to identify, remove, and prevent duplicates for improved data integrity and performance. Essential for robust database management.
How to Optimize LINQ Queries in Entity Framework Core to Avoid the N+1 ProblemApr 08, 2026. Boost EF Core performance! Learn to optimize LINQ queries, avoid the N+1 problem with eager loading, projections, and more. Build faster, scalable apps now!
How to Use Raw SQL Queries Safely in Entity Framework CoreApr 08, 2026. Safely use raw SQL in Entity Framework Core! Learn how to prevent SQL injection with parameterized queries, FromSqlInterpolated, and input validation for secure .NET apps.
How to Optimize SQL Queries for Better PerformanceMar 25, 2026. Boost database performance! Learn SQL query optimization techniques: indexing, efficient joins, filtering, caching, and execution plans. Speed up your applications!
How to Optimize Slow Queries Using EXPLAIN in PostgreSQLMar 24, 2026. Optimize PostgreSQL query performance using EXPLAIN! Learn to analyze execution plans, identify bottlenecks, and apply indexing for faster, scalable databases.
How to Optimize MongoDB Queries for High-Performance ApplicationsMar 17, 2026. Boost MongoDB performance! Learn query optimization techniques: indexing, data modeling, explain method, caching, and aggregation for scalable apps. #MongoDB
How to Optimize PostgreSQL Queries for Large Datasets?Mar 16, 2026. Optimize PostgreSQL queries for large datasets! Learn indexing, EXPLAIN analysis, partitioning, caching, and more to boost speed and efficiency. #PostgreSQL
How to Identify and Fix Slow SQL Queries in Production Systems?Mar 16, 2026. Boost application speed! Learn to identify & fix slow SQL queries in production. Master indexing, query optimization, and monitoring for peak database performance.
How to optimize database queries for high-performance applications?Mar 09, 2026. Boost app speed! Learn to optimize database queries with indexing, caching, and schema design. Reduce server load and enhance user experience. Essential tips inside!
How to analyze and fix slow database queries in production environments?Mar 09, 2026. Troubleshoot slow database queries in production. Learn to analyze execution plans, optimize indexes, and implement caching for peak performance. Keep your app fast!
How to Optimize Database Queries for Large-Scale Applications?Mar 05, 2026. Optimize database queries for large-scale apps! Learn indexing, caching, and more to boost performance, reduce server load, and ensure scalability.
How to Optimize PostgreSQL Queries for High-Traffic Applications?Mar 03, 2026. Boost PostgreSQL performance in high-traffic apps! Learn query optimization: indexing, EXPLAIN ANALYZE, connection pooling, caching, and configuration tuning.
How to Optimize Entity Framework Core Queries for Large Datasets?Feb 26, 2026. Optimize EF Core queries for large datasets in ASP.NET Core! Improve performance with techniques like AsNoTracking, projection, pagination, and proper indexing.
How to Optimize SQL Queries for High Performance in .NET Applications?Feb 25, 2026. Boost .NET app performance! Master SQL query optimization: indexing, EF best practices, execution plans, and more. Build scalable, responsive systems.
How to Fix Slow Database Queries in Production Environment?Feb 25, 2026. Boost app performance! This guide provides a structured approach to identify, analyze, and fix slow SQL queries in production. Optimize your database now!
How to Optimize SQL Queries in .NET Applications?Feb 23, 2026. Boost .NET app performance! Learn SQL query optimization techniques: indexing, pagination, caching, EF Core best practices, and more. Build scalable, reliable backends.
Merging and Appending Queries in Power BIFeb 23, 2026. Learn the difference between merging and appending queries in Power BI! Combine tables effectively by adding columns (merge) or rows (append). Master Power Query!
How to Optimize SQL Queries for Large Databases EffectivelyFeb 20, 2026. Boost database performance! This guide covers SQL query optimization techniques for large databases, including indexing, joins, and execution plan analysis.
How to Optimize Entity Framework Core Queries for High PerformanceFeb 13, 2026. Boost .NET app performance! Learn to optimize Entity Framework Core queries: select data wisely, use no-tracking, paginate, and avoid extra calls. Essential tips!
How to Fix Slow Database Queries After Recent Data MigrationFeb 06, 2026. Database slow after migration? This guide provides a step-by-step approach to diagnose and fix performance issues. Optimize indexes, queries, and configurations!
MongoDB Geospatial Queries Explained with ExamplesFeb 05, 2026. Unlock location-based search with MongoDB! Learn geospatial queries, indexing, and data types for building location-aware apps. Includes real-world examples.
Why PostgreSQL Uses High CPU Even When Queries Look SimpleJan 23, 2026. Unravel PostgreSQL high CPU mysteries! Learn why seemingly simple queries cause performance bottlenecks due to data growth, visibility checks, and connection overhead.
Why PostgreSQL Queries Get Slower as Data Grows (Even With Indexes)Jan 22, 2026. PostgreSQL query slowdowns with data growth? This article explains why indexes aren't always enough. Learn about bloat, statistics, cache misses, and more!
How to Optimize SQL Queries for Large DatasetsJan 15, 2026. Boost SQL query speed on large datasets! Learn indexing, efficient queries, and optimization techniques for MySQL & PostgreSQL. Improve performance now!
Optimize MySQL queries in Java applications for better performance?Jan 02, 2026. Learn simple and effective ways to optimize MySQL queries in Java applications. Understand indexing, query design, JDBC best practices, connection pooling, and real-world performance tips.
Split Queries in EF Core : When and How to Use ThemDec 16, 2025. Split Queries in EF Core : When and How to Use Them
Optimize MySQL Queries in Java for Better PerformanceDec 09, 2025. Learn how to optimize MySQL queries in Java applications using indexing, prepared statements, connection pooling, batch processing, and query tuning techniques. This guide explains everything in simple words with practical examples.
Optimizing Audit Queries by Time-Keyed ClusteringDec 02, 2025. Optimize audit queries with Time-Keyed Clustering! Learn how to improve performance, reduce I/O, and efficiently manage large audit datasets. Boost Angular app speed!
Refactoring N+1 Queries in Transactional SystemsNov 26, 2025. Eliminate N+1 query problems in transactional systems! Learn to detect, refactor, and prevent performance bottlenecks with SQL, ORM tuning, and architectural changes.
Beginner Guide to Writing SQL Queries for Full-Stack ProjectsNov 27, 2025. Master SQL for full-stack development! This guide covers essential SQL queries, database operations, joins, and best practices for building robust applications.
How to Optimize Slow SQL Queries | Beginner-Friendly Techniques with Practical Developer Case StudyNov 25, 2025. Boost SQL query speed! Learn indexing, filtering, and execution plan analysis. Fix slow queries with our beginner-friendly guide and developer case study.
How to Write SQL Queries Every Beginner Should KnowNov 24, 2025. Master SQL querying! Learn SELECT, JOIN, GROUP BY, and more with real-world examples. Perfect for beginners to build practical database skills and boost efficiency.
How ASP.NET Core MVC Performs CRUD Without SQL Queries | Beginner-Friendly EF Core Nov 22, 2025. Master ASP.NET Core MVC CRUD operations without writing SQL queries! Learn EF Core, DbContext, DbSet, and Models for efficient data management. Beginner-friendly tutorial.
Performance Tuning Case Study: Optimizing 10 Slow SQL Server Queries Step-by-StepNov 17, 2025. Boost SQL Server performance! This case study provides 10 step-by-step solutions to common slow query problems, complete with root causes and optimized code.
Optimizing EF Core Queries for Large Data Applications | ASP.NET CORENov 10, 2025. Boost ASP.NET Core performance! Master EF Core query optimization techniques for large data applications. Learn to handle millions of records efficiently and build scalable APIs.
Common Mistakes Developers Make in SQL Queries (and How to Fix Them)Oct 31, 2025. Master SQL! Avoid common mistakes like SELECT *, missing indexes, and subqueries. Learn to write efficient, safe, and accurate queries with these simple fixes.
Using CTEs and Recursive Queries for Complex Data Relationships (SQL Server)Oct 31, 2025. Master complex SQL Server data relationships with CTEs and recursive queries! Simplify hierarchies, improve readability, and boost performance. Learn how now! #SQL
Tell, Don't Ask: Write Code That Commands, Not Queries in C#Oct 26, 2025. Master the Tell, Don't Ask principle in C# for cleaner, more maintainable object-oriented code. Refactor from queries to commands for SOLID design!
🎯 Top SQL Server Queries Asked in Interviews (With Examples)Oct 25, 2025. Ace your SQL Server interview! Master 30 essential queries with examples, covering everything from basic SELECT statements to advanced window functions and optimization.
Understanding orientation in CSS Media Queries for Responsive DesignOct 24, 2025. Learn how to use CSS media queries to adapt your website's design based on device orientation (portrait or landscape). This guide covers the basics of the orientation media feature, provides practical examples for adjusting layouts and styles, and offers tips for creating a more responsive and user-friendly experience across various devices.
How LINQ Turns Your C# Code into SQL Queries (With Real Examples)Oct 21, 2025. Unlock the power of LINQ! This article provides a comprehensive guide on how LINQ translates your C# code into efficient SQL queries. Learn with practical examples demonstrating filtering, joining, ordering, and grouping. Understand deferred execution and the difference between LINQ to Entities and LINQ to Objects. Master LINQ and optimize your database interactions in .NET!
How to Optimize SQL Queries for Faster Execution in Large DatabasesSep 23, 2025. This article reveals practical techniques like indexing, efficient joins, and smart WHERE clauses to dramatically reduce execution time. Learn how to analyze execution plans, leverage partitioning and caching, and optimize subqueries for peak performance.
Find High-Usage Queries and Stored Procedures in SQL ServerSep 05, 2025. Identify the SQL statements and stored procedures that burn the most CPU, IO, and time using SQL Server DMVs—plus quick scripts, filters, and tips to fix them.
Basic SQL Queries for Database TestingJun 23, 2025. Learn essential SQL queries used in database testing. This guide covers SELECT, JOIN, WHERE, and more—ideal for QA testers and beginners ensuring data accuracy and integrity in applications.
Execution Process of SQL Queries vs Stored Procedures Apr 21, 2025. Dive deep into the internal execution process of SQL Server queries with this one-of-a-kind article comparing normal SQL queries and stored procedures.
Running Azure Resource Graph Queries in an Azure Logic AppMar 12, 2025. Learn how to run Azure Resource Graph queries within an Azure Logic App to automate resource management and gain insights into your Azure environment.
Simplify Your Queries With “AutoInclude” In EntityFramework CoreDec 30, 2024. In this article, we will discover how the "AutoInclude" feature in EntityFramework Core simplifies query writing by automatically including related navigation properties.
Recursive CTE: Simplifying Complex Queries with SQLAug 16, 2024. Recursive CTEs in SQL simplify querying hierarchical or recursive data by breaking down queries into anchor and recursive members. They are ideal for traversing structures like organizational charts or file directories, offering improved readability and performance.
Optimizing LINQ Performance with Compiled Queries in .NETJul 22, 2024. Compiled queries in LINQ (Language Integrated Query) are a powerful feature that can significantly improve the performance of your data access code, especially when dealing with repetitive queries.
Optimizing LINQ Queries in C# and .NET Core Web APIsJun 21, 2024. LINQ in C# optimizes data querying with readable syntax, but inefficient use can impact .NET Core Web API performance. Strategies like early filtering and selective projections enhance efficiency. Deferred execution via IQueryable delays query execution, optimizing database interactions.
Master GeoSpatial Queries in MongoDBMay 29, 2024. Mastering geospatial queries in MongoDB empowers efficient handling of location-based data. Leveraging features like GeoJSON, GeoNear, and GeoWithin, developers can perform precise searches, analyze spatial relationships, and optimize queries using indexes, facilitating robust geospatial data management and analysis.
SQL Joins: Optimizing SQL Queries for EfficiencyMay 06, 2024. Explore the art of optimizing SQL queries through effective join strategies. Learn essential techniques such as proper column selection, indexing, and join types, alongside real-time project examples. Delve into advanced concepts like self-joins and cross-joins for comprehensive understanding.
SQL Server Fundamentals: Design, Queries & OptimizationApr 29, 2024. This article serves as a comprehensive guide to SQL Server fundamentals, database design principles, querying with Transact-SQL, stored procedures, and optimization techniques. Through real-time examples and SQL query snippets, developers gain practical insights into building robust.
MySQL Queries Cheat SheetApr 18, 2024. In this article, we will learn about MySQL querying essentials, covering basic SQL commands, data manipulation functions, constraints, and frequently asked questions, providing valuable insights for both novice and experienced developers.
Enhance SQL Server Queries with OPTION(RECOMPILE) HintApr 11, 2024. This article provides an in-depth exploration of the OPTION(RECOMPILE) hint in SQL Server, offering developers and database administrators a thorough understanding of its functionality, practical applications, and best practices.
Leveraging Compiled Queries for Enhanced Performance in LINQMar 09, 2024. Compiled queries in LINQ allow developers to pre-compile LINQ queries into executable delegates, reducing the overhead of query compilation and optimization. By caching the compiled query execution plan, compiled queries improve the performance of frequently executed or complex queries in C# applications.
Azure Stream Analytics Queries for Processing JSON DataAug 21, 2023. Exploring Azure Stream Analytics Queries for Processing JSON Data
Handling Complex API Filter Queries in ASP.NET CoreAug 07, 2023. From this blog, you will learn how to integrate my composite filter solution into your ASP.NET Core web applications.
Recursive Queries in SQLJul 13, 2023. In this article we learn about recursive queries in sql.
Optimization Of Queries In SQL Server - HEAP TABLESMar 08, 2023. This article will help you to understand how to start to think on optimization of sql queries and why use indexes in tables
Optimizing Queries For Faster Performance In SQL Server - A Step-By-Step Guide With ExamplesFeb 14, 2023. In this article, you will learn about Query Optimization in SQL Server.
The Most Important SQL Queries For BeginnersNov 30, 2022. How do you get the data from the table? How do you create or drop the table? How do you display the different records? Do you want to? You can easily do all of this by writing a simple SQL query.
Handling SQL Queries Using XAMPP ServerJun 14, 2022. XAMPP is a Free full-fledged development environment that lets you install the Apache web server, MariaDB database, Perl, and PHP scripting languages in one installation. It is a free solution stack for website developers that includes a web server, database server, and scripting engines. production environments.
Database Backup Using SQL Queries And Its TypeMay 17, 2022. How to make a backup of database using SQL queries in compressed and uncompressed condition or restoring database from backup using SQL queries and Difference between Compressed and Uncompressed Backup.
Advanced Entity Framework Core - Output EF SQL Queries To The Console And Tips To Setup Dbcontext With The Development In MindJan 10, 2022. When you work with abstractions over SQL Database you may be wondering what does Entity Framework constructs from your Linq queries. To get a clue on it here are 3 options. Tips to setup DbContext with the development in mind for development purposes, you may sometimes decide to use an in-memory database for all environments including production, you may set up HealthChecks, below shows how to add health checks for the DbContext also for the development environment good to have set o.EnableDetailedErrors(); and o.EnableSensitiveDataLogging(); ?to manipulate with all these options you may consider adding configuration options
No Likes And Range Queries In CassandraDec 24, 2021. Cassandra's design philosophy emphasizes efficient distributed data storage and retrieval using partition keys and clustering columns. While it may not support arbitrary substring matching (No Likes queries) and requires careful consideration for efficient range queries, understanding and designing your data model accordingly can help you make the most of Cassandra's capabilities
Important Queries In MySQLSep 23, 2020. A list of Important Queries In MySQL. These queries are very useful whenever we face any difficulty in MySQL.
Optimizing LINQ Queries In C#.NET For MS SQL Server Aug 13, 2020. Learn how to optimize LINQ queries for SQL Server performance using Entity Framework. Understand the importance of generating efficient SQL queries and avoid common pitfalls. Explore techniques like JOIN and UNION for improving query efficiency. Utilize tools like SQL Complete for query history and formatting.
Delta Queries In Microsoft Graph API Using C#Aug 09, 2020. This article discusses Delta Queries in Microsoft Graph using C#.
Use Append Queries Feature In Power BIJul 31, 2020. In this article, you will learn how to use the append queries feature in Power BI.
Executing SQL Queries And SQL Stored Procedure With ODBCOct 04, 2019. In this article, you will learn how to execute SQL queries and SQL Stored procedure with ODBC.
Top 5 Tricky/Important SQL Queries And Their AnswersSep 05, 2019. In this article, you will learn about SQL Server Top 5 tricky/ important SQL Query with their answers.
Spatial Queries In Entity Framework CoreJun 03, 2019. In this article, you will learn about spatial queries in Entity Framework Core.
Top 30 Important SQL Queries For DevelopersApr 01, 2019. In this SQL article, I will introduce you to some important SQL queries and technical points. This article is a guide for you to learn the concepts related to SQL. It starts with the basic SQL queries and later, continues to the advanced ones.
Sub Queries In SQL ServerJan 23, 2019. In this write-up, we will learn about subqueries in SQL Server. Subqueries are also termed as Nested queries.
Most Asked SQL Queries In InterviewsSep 19, 2017. Do you wonder what the most frequently asked SQL queries are in interviews? Here is a list of most asked SQL queries interview questions.
Cross Database Queries In Azure SQLMay 06, 2017. In this article, you will learn about cross database queries in Azure SQL.
Accessing SQL From Entity Framework Core Queries In ASP.NET CoreFeb 03, 2017. In this article, you will learn how to access SQL from Entity Framework Core Queries in ASP.NET Core.
Compile Queries And Execute SQL Queries Using LINQ To SQLJan 08, 2017. In this article, you will learn how to compile queries and execute SQL queries, using LINQ to SQL.
How To View LINQ To SQL Generated SQL Queries And Using Stored Procedures With LINQ To SQL Jan 02, 2017. In this article, you will learn how to view LINQ to SQL generated SQL queries and use stored procedures with LINQ to SQL.
How To Run Interactive Spark SQL Queries On Apache Spark Hdinsight Linux ClusterDec 31, 2016. In this article, you will learn how to run Interactive Spark SQL queries on Apache Spark HDinsight Linux cluster.
SharePoint 2013 - Important SQL Queries On SharePoint Content Databases - Part TwoDec 12, 2016. This second part of this article presents you with some more of the important queries that you can use to query SharePoint content databases.
SharePoint 2013 - Important SQL Queries On SharePoint Content Databases - Part OneDec 08, 2016. This article presents you with some of the important queries that you can use to query SharePoint content databases.
Learn MySQL Queries With ExamplesJun 23, 2016. In this article, you will learn select, update and delete statements in MySQL queries with examples.
50 Important Queries in SQL ServerApr 23, 2016. In this article, you will learn about 50 Important Queries in SQL Server. EXEC sp_helpdb, exec sp_helptext, EXEC sp_updatestats, EXEC sp_MSforeachtable, SQL query for version name of SQL Server, Enable a SQL Trigger, Disable a SQL Trigger, EXEC sp_recompile, sql query for First Date of Current Month, Swap two column values in SQL, Remove all stored procedures, Remove all views from database, Drop all tables.
SharePoint 2013: Execute SharePoint Search Queries Using CSOMApr 13, 2016. In this article you will learn how to execute SharePoint Search Queries using CSOM in SharePoint 2013.
Useful SQL Queries For SharePoint PractitionersMar 11, 2016. In this article you will learn useful SQL Queries for SharePoint practitioners.
Detect Poor Performing Queries In Entity Framework 6.xFeb 23, 2016. In this article you will learn how to detect poor performing queries in Entity Framework 6.x.
Important Queries in SQLJun 07, 2015. In this article we learn some interesting and useful SQL queries.
Basic SQL Queries For BeginnersFeb 23, 2015. In this article you will learn Basic SQL Queries for Beginners.
Create Dynamic PIVOT Queries in SQL ServerMay 15, 2014. This article shows how to create a dynamic PIVOT query in SQL Server.
Some Practical Useful SQL Queries For SharePoint AdminstratorFeb 26, 2014. In this article, I will share some very practical and useful SQL queries that a SharePoint administrator will require.
Compiled Queries in LINQFeb 11, 2014. This article explains the use of compiled queries to improve performance when a query is fired many times.
Important SQL Queries Every Developer Should Know in SQL ServerJul 10, 2013. In this article i am sharing some sql queries that need to maintaining data in sql server for every developer.
Generate LINQ, SQL Queries With LINQPadJul 02, 2013. In this article I am sharing how to generate a LINQ query with a very facilitative tool, LINQPad.
Complex SQL Queries With Split() Function in SQLMay 23, 2013. In this article, you will learn about Complex SQL queries with the split() function in SQL.
Co-related Queries and Self Join Using LINQNov 17, 2012. Today, in this article let’s play around with one of the interesting and most useful concepts in LINQ.
Interrogating your Printer Queries with WMINov 08, 2012. In response to a newsgroup query here is the code needed to view the printer queues on your system. Once again this is achieved using Windows Management Instrumentation or WMI. Note this code will display all printer queues if there are documents waiting to be printed. To test this open up a printer queue and pause the printer then use notepad or word etc and print to the paused printer.
Perform queries using LINQ in VB.NETNov 08, 2012. In this article I will show you how to extract data from SQL Server using LINQ.

1 - 100 of 156

OUR TRAINING