Resources   No resource found

• XOR Pairs Less Than KJun 06, 2026. Learn how to count the number of pairs in an array whose XOR is less than a given number K using Trie-based optimization. Includes concept explanation, examples, and efficient Java solution.
• Count Elements Within a Range Using Sorting and Binary SearchJun 06, 2026. Learn how to efficiently count array elements within given ranges using sorting and binary search. Includes intuition, lower bound and upper bound concepts, complexity analysis, and Java solution.
• Count Elements Less Than or Equal to x in a Sorted Rotated ArrayJun 06, 2026. Learn how to efficiently count elements less than or equal to a given value in a sorted rotated array using binary search. Includes concept, pivot detection, and Java solution with O(log n) complexity.
• Count Elements in a Given Range Using Sorting and Binary SearchJun 06, 2026. This problem involves finding the number of elements in an unsorted array that lie within a given range [a, b] for multiple queries. A naive approach would check each element for every query, resulting in high time complexity. A more efficient solution uses sorting and binary search: Sort the array to enable fast searching. For each query [a, b]: Use a lower bound search to find the first element = a. Use an upper bound search to find the first element > b. The difference between these indices gives the count of elements in the range. This approach significantly reduces time complexity to O(n log n + q log n) while keeping space usage minimal. It’s a classic example of combining sorting with binary search to handle range-based queries efficiently.
• Next Element With Greater Frequency – Java O(n) Stack SolutionJun 05, 2026. Learn how to solve the Next Element With Greater Frequency problem using HashMap and Monotonic Stack. Includes intuition, dry run, complexity analysis, and optimized Java solution.
• Count Subset With Target Sum II – Meet in the Middle Java SolutionJun 05, 2026. Learn how to solve Count Subset With Target Sum II using the Meet in the Middle technique. Includes intuition, dry run, complexity analysis, and optimized Java code.
• Count of repeating character patterns in a string using MySQLMay 13, 2026. Discover how to count repeating character patterns in strings using MySQL. This tutorial provides a step-by-step guide with code examples for text analysis and pattern recognition.
• Count Distinct Elements in Every WindowApr 27, 2026. Master the sliding window technique! Learn how to efficiently count distinct elements in every window of an array using a HashMap. Java solution and complexity analysis included.
• Count Subarrays with K Odd NumbersApr 27, 2026. Master the 'Count Subarrays with K Odd Numbers' problem using the sliding window and 'atMost(k) - atMost(k-1)' technique. Optimize your coding interview prep with this O(n) solution!
• Subarrays With At Most K Distinct IntegersApr 27, 2026. A detailed guide to solving the Subarrays With At Most K Distinct Integers problem using the sliding window technique. Learn the intuition, step-by-step approach, dry run examples, and optimized Java implementation with O(n) time complexity. Perfect for coding interviews and mastering array-based problems.
• Substrings With Exactly K Distinct CharactersApr 27, 2026. Learn how to efficiently solve the Substrings With Exactly K Distinct Characters problem using the sliding window technique. This guide explains the key insight of converting the problem into “at most K” subproblems, includes step-by-step intuition, dry run examples, and an optimized Java solution with O(n) time complexity and constant space.
• Count Increasing SubarraysApr 22, 2026. Learn how to efficiently count strictly increasing subarrays in an array using an optimized O(n) approach. This article explains the concept step-by-step by breaking the array into increasing segments and applying a mathematical formula to count valid subarrays. Includes a clear Java implementation, dry run examples, and edge case analysis—perfect for beginners and coding interview preparation.
• Number of Ways to Arrive at Destination Apr 22, 2026. Master Dijkstra's Algorithm to find the shortest path and count unique routes to a destination in a weighted graph. Includes Java code and complexity analysis.
• How to Remove Duplicate Values from a List in C#Feb 26, 2026. Learn how to efficiently remove duplicate values from lists in C# using Distinct() and HashSet. Improve data processing and performance in your applications.
• Count Occurrences of an Element in a Sorted Array (Using Binary Search)Jan 21, 2026. Master counting element occurrences in sorted arrays efficiently using Binary Search! This guide provides a step-by-step approach, code examples, and avoids common mistakes. Ace your coding interviews!
• How Many Words Are in a Recovery Phrase and Why?Dec 30, 2025. Unlock the secrets behind crypto wallet recovery phrases! Learn why 12 or 24 words are used, the security implications, and how to choose the right option for you. Discover the importance of secure storage!
• Concurrent Login Control Using Session Count in ASP.NET WebFormsDec 22, 2025. Secure your ASP.NET WebForms app! Learn to control concurrent logins using session count, database tracking, and automatic session expiration. Enhance security and prevent misuse.
• Confused About SharePoint Online File Path Limits? Here’s What You Should Really CountDec 10, 2025. SharePoint Online’s file path limits are often misunderstood. This article breaks down what actually counts toward the 400?character limit, clears up common myths, and shows practical ways to count length. Whether you’re an admin or end user, you’ll learn how to manage paths effectively and keep your files accessible.
• Count() vs Any() in C#Dec 02, 2025. Unlock C# performance! Discover the crucial difference between Count() and Any() when checking for emptiness in collections and LINQ queries. Learn when to use each for optimal speed, especially with EF Core and large datasets. Avoid performance pitfalls!
• Understanding Any() vs Count()Nov 16, 2025. Unlock C# performance! Discover when to use Any() vs. Count() for checking collection emptiness. Learn the O(1) vs. O(n) complexities and crucial exceptions for Lists & arrays.
• Count vowels and consonants in a stringOct 29, 2025. Learn how to count vowels and consonants in a string using C# and ASP.NET! This real-time example provides a step-by-step guide with code and explanations.
• Count words in a sentenceOct 29, 2025. Learn how to count words in a sentence using ASP.NET WebForms with this real-time example. Includes code snippets and a step-by-step explanation for easy implementation.
• Find the frequency of each character in a stringOct 29, 2025. Learn how to find the frequency of each character in a string using C# and ASP.NET! This tutorial provides a real-time example with code and explanation.
• Count even and odd elements in an arrayOct 29, 2025. Learn how to count even and odd numbers in an array using C# with this real-time web application example. Includes code, explanation, and input/output examples.
• Count frequency of words using DictionaryOct 29, 2025. Learn how to count word frequency in C# using a Dictionary! This real-time webforms example demonstrates a practical implementation with clear steps and code.
• When Seconds Count: Designing Trigger-Centric Serverless Systems for Public Safety Using Azure FunctionOct 14, 2025. Unlock the power of Azure Functions for mission-critical systems! This article dives deep into trigger design, focusing on public safety scenarios. Learn why the 'one trigger per function' rule is crucial for scalability, resilience, and clarity. Discover best practices, architectural guidance, and a real-world example of building an emergency response system using Azure Functions, Event Grid, and more. Avoid common pitfalls and build robust, life-saving applications.
• Count Every Car: Build a Traffic-Smart Vehicle Counter with Connected Component Labeling in Pure PythonOct 10, 2025. Build a real-time vehicle counter using Connected Component Labeling (CCL) in pure Python. This guide provides a step-by-step implementation from scratch, ideal for edge devices and traffic management systems. Learn how to accurately count vehicles, even in dense traffic, without relying on external libraries like OpenCV or deep learning.
• How to Implement Connected Component Labeling for Object Counting Using PythonOct 10, 2025. Implement Connected Component Labeling (CCL) in Python from scratch using NumPy for object counting in images. This guide provides a step-by-step implementation of the two-pass algorithm with union-find, ideal for resource-constrained environments. Learn to count objects, like wildlife in remote areas, without relying on external libraries like OpenCV.
• Count vowels and consonants in a StringOct 08, 2025. Master string manipulation by counting vowels and consonants! This fundamental exercise strengthens your understanding of character operations, loops, and conditional statements, crucial for DSA success. Explore C, C++, and Java code examples with detailed explanations. Learn to handle case sensitivity and avoid common pitfalls. Build a solid foundation for tackling more complex string problems.
• How Does Python Manage Memory?Aug 08, 2025. Dive into the internal memory management system of Python. Understand how Python allocates, tracks, and frees memory using techniques like reference counting, garbage collection, and memory pools.
• Data View and LINQ in C# and VB.NETJul 07, 2025. Learn how to fetch unique values from a DataTable using DataView and LINQ in C# and VB.NET. Explore sorting, filtering, and displaying distinct book records with examples compatible with .NET Core and .NET 9.
• Vehicle Count Visualization Using ApexCharts in ASP.NET MVCJun 10, 2025. In this snippet, we are working on visualizing vehicle category counts (B and C) using a donut chart powered by ApexCharts.
• NumPy in Python: Sort, Search, and Count Arrays EfficientlyJun 04, 2025. Explore NumPy’s powerful sort, search, and count functions with real Python examples. Learn how to efficiently handle arrays, structured data, and conditions for faster, smarter numerical computations.
• Understanding Aggregate Functions in SQLMar 21, 2025. SQL aggregate functions help perform calculations on multiple rows, returning a single result. This article covers COUNT(), SUM(), AVG(), MIN(), MAX(), and advanced uses like GROUP BY, HAVING, CASE, PARTITION BY, and DISTINCT.
• Various Methods to Count Occurrences of Each Number in Array or ListFeb 17, 2025. In this article, I'll show you different ways to count how often a number appears in C#. We'll look at methods like LINQ, Dictionary, GroupBy, and Parallel.ForEach, and see which ones work best for small and large datasets.
• Be Careful Using Distinct and OrderBy in EF Core QueriesFeb 03, 2025. Combining Distinct() and OrderBy() in EF Core queries can lead to performance issues. This article explains why and offers solutions for efficient data retrieval.
• Java Program for Counting the Number of Vowels in a StringJan 28, 2025. This article explains how to count the number of vowels (a, e, i, o, u) in a given string using Java. It covers two approaches: a simple method using loops and conditional statements, and a more optimized approach utilizing a Set for quick vowel lookups.
• Java Program to Count the Number of Even and Odd in an ArrayJan 27, 2025. The title "Java Program to Count the Number of Even and Odd Numbers in an Array" refers to a Java program that demonstrates how to count how many numbers in an array are even and how many are odd. The article explains the concept of even and odd numbers, and provides a step-by-step guide on implementing a Java solution using simple loops and conditional statements.
• How To Count Occurrence Of Each Character From The String In C#Dec 21, 2024. Learn how to count the occurrence of each character in a string using C#. This guide covers step-by-step instructions to efficiently analyze strings and determine the frequency of individual characters.
• Exploring the New T-SQL Enhancements in SQL Server 2022Oct 31, 2024. In this article we will explore the powerful new T-SQL enhancements in SQL Server 2022, including features like DATE_BUCKET, DATETRUNC, and IS DISTINCT FROM, designed to simplify data handling and optimize performance for modern data needs.
• IS [NOT] DISTINCT FROM New T-SQL Enhancements in SQL ServerOct 04, 2024. The "IS [NOT] DISTINCT FROM" operator is one of the key new T-SQL enhancements in SQL Server 2023. It simplifies SQL queries by handling NULL comparisons more efficiently, improving data integrity and performance.
• A Detailed Explanation of COUNT in SQL ServerOct 01, 2024. This article explores the differences between SQL counting methods: COUNT(*), COUNT(1), COUNT(column_name), and COUNT(DISTINCT column_name). It highlights their purposes, performance considerations, and use cases, emphasizing the importance of choosing the right COUNT function for efficient queries.
• How To Get Unique Records Without Using Distinct In SQL ServerSep 26, 2024. In this guide, you'll learn how to retrieve unique records in SQL Server without using the DISTINCT keyword. We'll explore alternative methods like GROUP BY, ROW_NUMBER(), and Common Table Expressions (CTE) to optimize performance and handle duplicates more efficiently in your queries.
• Count(*) vs Count(1) in SQLAug 01, 2024. When counting rows in SQL databases, both `COUNT(*)` and `COUNT(1)` are used, but there is no performance difference between them. Modern databases optimize both functions similarly. Prioritize code readability by using `COUNT(*)` and focus on optimizing queries through proper indexing and structure instead.
• @@ROWCOUNT in SQL ServerJul 25, 2024. @@ROWCOUNT is a SQL Server function used to retrieve the number of rows affected by the last executed statement. It provides valuable insights for data manipulation and validation processes, helping to track changes and optimize performance in SQL queries and stored procedures.
• Total Page hit count in PowerApps.Jul 16, 2024. Discover effective methods for monitoring usage statistics, generating insightful reports, and leveraging data visualization to gain actionable insights into app performance and user engagement.
• Track Views Per Item and Total Page Hits in PowerAppsJul 05, 2024. We often see in many of the sites that total page view count is shown. I have come across one of the use case where I wanted to show how many times that page was visited by any user. Another use case we will see how many views requests with details are posted means how many entries are made for any requests.
• Query to find Table Name, Row Count, Column Count and Data SizeJul 02, 2024. This guide covers techniques to query and display table names, row counts, column counts, and data sizes efficiently. Ideal for database administrators and developers seeking to optimize data management and performance analysis.
• Print * Tree Counts From 1 to 10 and 10 to 1 Using C#May 24, 2024. In C#, print tree counts from 1 to 10 and 10 to 1 using nested loops for ascending and descending order respectively. Utilize console output and loop control structures for efficient counting and display.
• Count vs. Any in Entity Framework for Efficient Querying in .NETMay 24, 2024. Entity Framework (EF) is a powerful Object-Relational Mapper (ORM) for .NET, allowing developers to interact with databases using .NET objects. When working with EF, it's crucial to write efficient queries to ensure optimal performance.
• Count UPPERCASE and lowercase Letter in Word or SentenseMay 07, 2024. This Java program efficiently counts the occurrence of uppercase and lowercase letters in a given word or sentence. It utilizes a Scanner to take user input and iterates through each character, incrementing counts accordingly.
• Why Any() Outperforms Count() in Collection ChecksMar 06, 2024. Efficiency in programming is vital, and choosing the right method for tasks is crucial. Explore why Any() often outperforms Count() in specific scenarios with illustrative examples in C#.
• Identifying the Count of Activities within a Pipeline in SynapseFeb 06, 2024. Need to count activities in Synapse pipelines? With Powershell and Azure SDK modules, effortlessly fetch pipeline details. Use commands like Get-AzSynapseActivities to list all pipelines or specify a pipeline for details.
• TwoSum Example in C#: Print and Count Pairs with Given SumJan 17, 2024. Given an array of integers and target number ‘target sum' then print all pairs and their count in the array whose sum is equal to ‘target sum’.Examples : Input : arr[] = {3, 5, 7, 1, 5, 9}, target = 10 Output : (3,7) (5,5) (1, 9)Count: 3
• Counting Cycles in Undirected Graph with DFSOct 26, 2023. This is a graph problem to count the noumber of cycles with length n using Depth First Search
• Identifying the Count of Activities within a Pipeline in an Azure Data FactoryOct 20, 2023. Counting Activities in Azure Data Factory Pipelines involves the process of determining the number of distinct activities or operations within a pipeline created in Microsoft's Azure Data Factory. This task is essential for monitoring and optimizing data workflows and ETL processes. By accurately identifying and analyzing the count of activities, data engineers and developers can assess the complexity of data pipelines, diagnose performance issues, and make informed decisions to enhance efficiency and streamline data management within the Azure environment. This knowledge contributes to more effective data processing and ensures the smooth operation of data-driven solutions.
• Calculate the Number of 1's in Binary RepresentationJul 13, 2023. Given an integer n, return an array ans of length n + 1 such that for each i (0 <= i <= n), ans[i] is the number of 1's in the binary representation of i. Example 1:Input: n = 2 Output: [0,1,1] Explanation: 0 --> 0 1 --> 1 2 --> 10 Example 2:Input: n = 5 Output: [0,1,1,2,1,2] Explanation: 0 --> 0 1 --> 1 2 --> 10 3 --> 11 4 --> 100 5 --> 101Constraints: 0 <= n <= 105
• How To Use Aggregate Functions In MySQLApr 26, 2023. Aggregate functions are functions that perform calculations on groups of rows in a database and return a single result. They are commonly used in SQL to summarize data and calculate statistics. Here are some commonly used aggregate functions in SQL:
• How to Use Aggregate Functions in SQL Server?Apr 20, 2023.
• Count Number Of Character Occurrences In A String Using JavaScriptApr 04, 2023. In this article, I am going to demonstrate various way to count number of character occurrences in a string javascript
• How To Check If An Array Is Empty In C#Feb 01, 2023. In this article, we will explore various methods to determine if an array is empty in C#. The Length property, Count() extension method of LINQ or the IsNullOrEmpty() method can be used to check if the array is empty. If any of these methods return 0 or the array is null, it can be determined that the array is empty.
• Get SubGird Record Count With Webresource In Dynamics CRMJul 21, 2022. During certain scenarios, we must acquire the total records count present in a sub grid. To achieve this functionality, explicit logic should be written using JavaScript with form controls that are available on the form. Contact forms with account sub grids are required, and the Contact record was used to explain this functionality.
• Get Status Based Distinct Count Of SharePoint List Items In Power AutomateMar 30, 2022. In this article, you will learn how to get Distinct SharePoint List items count based upon the status from Power Automate and Email the summary to user.
• Substring Functions In PythonFeb 02, 2022. The article explains the substring functions find, rfind, count, replace, slice in Python.
• Get Record Count For A List In Power AutomateJan 21, 2022. In few scenarios when working on List of records for a given entity it is needed to find out the count of total records present in that table to perform certain manipulations. Here length function in power automate can be used to get record count for a given list. As an example, contact table was considered.
• Delete Duplicate Rows In SQL Server From A TableDec 21, 2020. In SQL Server, delete duplicate rows from a table efficiently using techniques like DISTINCT, GROUP BY, or ROW_NUMBER(). Ensure data integrity by considering primary keys or unique constraints.
• Azure Data Explorer - Kusto Query - Get Categorial CountOct 09, 2020. This article will talk about how to get the count based on defined criteria.
• Operations On Dataframe - Part TwoSep 30, 2020. In this article, we will learn about various methods of combining dataframes and about Aggregation Functions like quantile(), mad(), sum(), count(), min(), and max().
• Dataframe Attributes In PANDASSep 14, 2020. In this article, we would learn about various dataframe attributes and how these attributes are used and implemented in Pandas.
• Java 8 - Stream API Jul 22, 2020. In this article, you will learn about Stream API and methods in Stream.
• EF Core - SELECT DISTINCT on a Few Columns OnlyApr 26, 2020. In this article, you will learn about implementing EF Core - SELECT DISTINCT on selected columns only.
• Finding Perfect Square Count in ASP.NET Nov 14, 2019. In this article, we will learn how to find a perfect square count in the list using C#.
• SQL Magic: How to Use Select Distinct in SQL to Get Unique Results Every TimeOct 30, 2019. Learn about the SQL SELECT DISTINCT statement and its uses for retrieving unique data in SQL. Get expert insights on how to implement select distinct SQL queries
• Aggregate Function In SQLSep 05, 2019. In this session, I will describe the Aggregate Function of SQL.
• Learn DataFrame Attributes In PythonAug 26, 2019. In this article, you will learn about various attributes of DataFrame in Python and how we can access different information about dataframes.
• Word Count Method In HDInsightJul 28, 2019. In this article, you will learn about wordcount method in HDInsight.
• List Methods In Python Jul 19, 2019. In this Python List tutorial, you will learn how to use List Methods like List.Insert, List.Pop, List.Remove, List.Clear, List.Reverse, List.Sort, and List.Count
• Display Notification Button With Count In SharePoint PageMar 22, 2019. In this article, we are going to see how to insert a notification button in our Sharepoint page using HTML and display the count of custom list item as a notification number using REST API methodology.
• Create A Simple 📈Chart By Date For The Latest C# Corner Article Count Dec 31, 2018. We will create a simple Line Chart in Blazor using Chart JS. We will show the latest C# Corner article count by date in this chart.
• Use Of Union, Intersect, Distinct And Except In LINQSep 01, 2017. Here, you will learn the uses of Union, Intersect, Except, and their differences, To get a clear picture, we will go with examples.
• Exporting RDLC Report In Excel When Record Count Is Above 65536 In Report Viewer 10.0.0.0Nov 28, 2016. In this article, you will learn how to export RDLC Report in Excel when record count is above 65536 in Report Viewer 10.0.0.0.
• SharePoint 2013 - Followed Count Webpart Stopped Working In My SiteAug 14, 2016. In this article, you will learn about the solution for the problem when followed count Webpart stopped working in my Site in SharePoint 2013.
• SharePoint 2013 Discussion Board: Likes Count is Not UpdatedMay 25, 2016. In this article you will see"Likes count is not updated" in SharePoint 2013 Discussion Board.
• Showing Blog Post Comments and Likes Count in SharePoint Feb 15, 2016. In this article you will learn how to show blog post comments and likes count in SharePoint.
• Power BI: Map Report Giving Count Of Latitude And Longitude Instead Of Geo CoordinatesJan 18, 2016. In this article you will learn about Map Report giving count of Latitude and Longitude Instead of Geo Coordinates.
• RetryPolicy Using Microsoft Practices Enterprise LibraryJan 14, 2016. RetryPolicy in Microsoft Practices Enterprise Library offers fault tolerance by automatically retrying operations upon transient faults. Configurable parameters like retry count and interval enhance application resilience, ensuring reliable performance even in unstable conditions.
• Count Items In Collection In SharePoint 2013 And Office 365 Using Nintex WorkflowsDec 15, 2015. In this article you will learn how to count items in Collection in SharePoint 2013 and Office 365 using Nintex Workflow.
• Count Items In Collection in SharePoint 2013 And Office 365 Using Nintex WorkflowsDec 12, 2015. In this article you will learn how to count Items in Collection in SharePoint 2013 and Office 365 using Nintex Workflows.
• Count Items In A Dictionary In SharePoint 2013 And Office 365 Using Nintex WorkflowsDec 11, 2015. In this article you will learn how to count Items in a Dictionary in SharePoint 2013.
• Line Counting Trickery Within Visual StudioNov 02, 2015. In this article you will learn about line counting trickery within Visual Studio.
• Insert Distinct Column Value From One Table to Another Table in SQLJul 09, 2015. This article explains how to insert a distinct column value from one SQL Server table to another SQL Server table and avoid duplicacy.
• Retrieve Count of Followed Contents From SharePoint 2013 Using RESTMar 31, 2015. This article helps the retrieval of the count of the followed contents from MySite using REST in SharePoint 2013.
• Count Duplicate Values in Excel Column DynamicallySep 23, 2014. In this article you will learn how to count the number of repeated rows in an Excel file column and show the duplicate columns in a chart control dynamically.
• How Distint Method is Used by the FrameworkAug 27, 2014. Distinct()/Contains() is not working properly?See how collection operation depends on Equals() implementation
• Count Rows In a Table In QlikViewMay 14, 2014. This article explains how to count rows in a table.
• LinQ OperationApr 21, 2014. Hi everybody, here in this article I want to raise a few basic things regarding the Distinct() extension method in “System.Linq” and we will explain how to customize our Distinct() method using IEqualityComparer.
• Get the Count or List of Columns of a Table in SQL ServerMar 20, 2014. In this article, I will show how to count the number of columns in a table that exists in your database.
• Count the Number of Tables, Stored Procedures, Triggers, Functions, Views in Your DatabaseMar 19, 2014. In this article I show how to determine how many types of entities you have in your any database.
• Aggregate Functions in F#Nov 15, 2013. In this article you will see and learn about the aggregate functions in a Windows Forms application.
• Know Popular Global Variables in SQL ServerJul 04, 2013. In this article, I explain some popular Global Variables of a SQL Server Database.