Resources   No resource found

• PostgreSQL Table Partitioning GuideJul 22, 2026. Master PostgreSQL table partitioning for efficient data management. Learn range, list, and hash strategies to boost query performance and scalability.
• How to Implement Database Partitioning in SQL Server Step by Step?Apr 17, 2026. Boost SQL Server performance! Learn database partitioning step-by-step: filegroups, functions, schemes, and tables. Handle large datasets efficiently and scale easily.
• How to Improve PostgreSQL Performance Using Table Partitioning in CQRS SystemsMar 23, 2026. Improve PostgreSQL performance by partitioning large tables! This guide covers range partitioning with pg_partman, addressing common pitfalls and maintenance.
• What is database partitioning and when should developers use it?Mar 09, 2026. Database partitioning boosts performance by dividing large tables into smaller, manageable partitions. Learn when and how to use this technique for scalability.
• Efficient Data Partitioning in SQL Server: A Practical Guide for Tables with Millions of RecordsNov 15, 2025. Master SQL Server data partitioning! This guide provides a step-by-step approach to efficiently manage large tables, boost query speed, and simplify maintenance.
• Boundary Value Analysis vs Equivalence Partitioning - Software TestingSep 12, 2025. This guide explores these black-box techniques, highlighting their differences, real-world applications in e-commerce, banking, and more. Learn how BVA focuses on edge cases, while EP groups inputs for comprehensive coverage, ensuring robust and reliable software across global markets. Boost your testing skills now!
• Horizontal vs Vertical Partitioning in SQLJun 04, 2025. Horizontal and vertical partitioning are techniques in SQL to improve performance and manage large datasets. Learn how each method works, their use cases, and how they impact database design.
• Understanding Table Partitioning in SQLJul 24, 2024. Table partitioning is a technique in database design that divides large tables into smaller, manageable pieces called partitions. This approach improves query performance, enhances manageability, and optimizes data storage.
• LINQ Partitioning Operators - Take, TakeWhile, Skip & SkipWhileSep 13, 2022. Take, TakeWhile, Skip and SkipWhile are called Partitioning Operators and we’ll discuss and investigate them. Not only that we’ll also see an equivalent loop construct to appreciate where these operators derived.
• Understanding Partitioning And Partition Key In Azure Cosmos DBJul 25, 2019. In this article, you will learn about partitioning and Partition Keys in Azure Cosmos DB.
• LINQ Extension Methods - Partitioning Operator - Part FourAug 16, 2018. This article is continuation of Linq extension methods. In this article I am going to demostrate partitionaning operators like skip, skipWhile, take and TakeWhile.
• How To Use Data Partitioning Operations With Database Using LINQAug 05, 2018. In this article, I will demonstrate how we can use skip, SkipWhile, take, TakeWhile operator of Language-Integrated Query (LINQ). Skip, SkipWhile, take, TakeWhile operators are part of partitioning data in Language-Integrated Query (LINQ).
• Table Partitioning In SQL ServerJun 01, 2016. In this article you will learn about table partitioning in SQL Server.
• LINQ - Partitioning OperatorsApr 04, 2016. In this article you will learn about Partitioning Operators in LINQ. We will learn about LINQ Partitioning Operators: Skip, SkipWhile and Take, TakeWhile.
• Partitioning Operators and Paging Using Partitioning Operators in LINQMar 12, 2015. In this article we will learn about partitioning operators and paging using partitioning operators in LINQ.
• Partitioning in Virtualization: Optimizing Resources and Enhancing SecurityJul 12, 2024. Partitioning in virtualization optimizes resource use by dividing physical servers into multiple virtual machines (VMs). It allocates CPU, memory, storage, and network resources efficiently, enhancing security and operational flexibility.
• SQL Table Partitioning: Horizontal RANGE vs Vertical RANGEMay 29, 2024. Explore the nuances of SQL table partitioning with this comprehensive guide. Delve into the differences between horizontal RANGE and vertical RANGE partitioning strategies.
• Partitioning in PostgreSQL: What, Why, and HowJan 11, 2024. PostgreSQL partitioning enhances database management by dividing large tables into smaller, manageable partitions. Learn the benefits and types (range, list, hash, composite) for efficient data organization and querying.
• Overview Of Cosmos DB PartitioningOct 23, 2018. In this article, we will see how Cosmos DB partitions can be created and used in order to achieve the scaling.
• Partitioning In Azure Cosmos DBDec 18, 2017. This article gives an overview of partitioning in Azure Cosmos DB. The partition key is the JSON property (or path) within your documents that can be used by Cosmos DB to distribute data among multiple partitions.
• Upload Large Files To MVC / WebAPI Using PartitioningDec 13, 2016. A solution to uploading large files in C# MVC. The article shows how to send files to an MVC Server from both a webpage using JavaScript, and a Web-form httpClient, and can be implemented using either MVC or Web API.
• Oracle PartitioningDec 12, 2013. In Oracle Partition is just like “Divide and conquer” approach, it is way or ability of database which allows a DBA to physically Split/ braked up all the very large tables, indexes and index organized tables in to smaller and manageable pieces/segments.
• SQL Server 2005: PartitioningNov 20, 2006. In this brief article, we will go through the concepts of Partitioning in SQL Server 2005.
• Demystifying Apache Kafka Partitions: The Engine Behind Scalable Event StreamingAug 04, 2026. Unlock Kafka's power! Learn how partitions enable scalable event streaming, parallelism, fault tolerance, and strict message ordering.
• Split Array into Minimum SubsetsJul 29, 2026. Split an array into minimum subsets of consecutive numbers. Count starting points efficiently using a HashSet for O(n) time complexity.
• Partitions with Given DifferenceApr 27, 2026. Solve partition problems by transforming them into subset sum problems! This DP approach efficiently counts subsets with a specific difference. Learn the key formula!
• What is CAP Theorem in Distributed Systems with ExampleApr 14, 2026. Understand the CAP Theorem: Consistency, Availability, Partition Tolerance. Learn trade-offs in distributed systems with real-world examples. Essential for system design.
• What Is CAP Theorem in Distributed Systems and How Does It Work?Mar 17, 2026. Explore CAP Theorem: Consistency, Availability, Partition Tolerance. Understand trade-offs in distributed systems for scalable cloud & high-performance apps.
• 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
• What Is Database Sharding and When Should Developers Use It?Mar 16, 2026. Explore database sharding: a powerful technique for scaling databases by distributing data across multiple servers. Improve performance and handle high traffic efficiently.
• What Practices Help Design Efficient Data Pipelines for Streaming Data?Mar 13, 2026. Discover best practices for designing efficient streaming data pipelines. Learn how to handle high volumes, ensure data integrity, and maintain system stability.
• How can developers design efficient data storage strategies for large datasets?Mar 11, 2026. Explore efficient data storage strategies for large datasets. Learn about partitioning, compression, indexing, and distributed systems for optimal performance.
• What Are the Best Practices for Designing Scalable Database Schemas?Mar 06, 2026. Master scalable database schema design! Learn best practices for normalization, indexing, partitioning, and relationships to build high-performance applications.
• What Is Database Sharding and When Should You Use It?Mar 03, 2026. Database sharding horizontally scales databases, improving performance and availability. Learn when and how to use it for high-traffic systems. A must-read!
• Archive Partition Sliding Window StrategyDec 02, 2025. Master data lifecycle with the Archive Partition Sliding Window Strategy. Improve performance, reduce storage costs, and ensure compliance. Includes Angular integration.
• 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!
• Partition-wise Parallelism Optimization for Very Large TablesNov 27, 2025. Unlock peak SQL Server performance! Learn partition-wise parallelism for massive tables: design, tuning, and real-world examples for faster queries and ETL.
• How Do I Implement Quicksort in Python with Recursion?Oct 06, 2025. Learn how to implement the Quicksort algorithm in Python with recursion. This guide explains partitioning methods, pivot selection, complexity analysis, and practical examples to help you master one of the fastest sorting algorithms in Python.
• Coalesce vs Repartition in Apache SparkJun 24, 2025. Understand the key differences between coalesce() and repartition() in Apache Spark. Learn when to use each for optimizing performance, managing partitions, and reducing shuffle operations.
• Best Practices for Azure Table StorageMar 30, 2025. Learn the best practices for optimizing Azure Table Storage, from partitioning strategies to query performance enhancements, ensuring scalable and cost-effective data management in the cloud.
• Extending Volume Group and Creating SWAP PartitionFeb 27, 2025. This article provides a step-by-step guide on how to check existing disks, extend a volume group, and configure a SWAP partition in a VMware-based Linux environment. It includes essential commands and best practices to ensure proper system resource management.
• How to Set Up DynamoDB in AWS?Jan 02, 2025. Amazon DynamoDB is a fully managed, serverless NoSQL database service offering fast performance, scalability, and flexibility. It supports key-value and document data models, with global availability and seamless integration with AWS services.
• Understanding Database Sharding in ProgrammingSep 24, 2024. Learn how sharding improves scalability and performance in distributed databases, key strategies for partitioning data, best practices for shard key selection, and techniques to optimize data management.
• Kafka Terminologies and Client APIsSep 13, 2024. Explore key Kafka terminologies like brokers, topics, partitions, and offsets, along with an overview of its core client APIs. Learn how the Producer, Consumer, Streams, and Connect APIs enable powerful event streaming, data integration, and real-time processing in Apache Kafka.
• Understanding the NTILE Window Function in SQLAug 07, 2024. Understanding the NTILE Window Function in SQL" delves into the NTILE function, a powerful SQL tool used to divide result sets into a specified number of roughly equal groups.
• SQL Essentials: GROUP BY vs. PARTITION BY ExplainedJul 26, 2024. Discover how GROUP BY aggregates data into summary rows, while PARTITION BY divides data into partitions for window functions. Master these techniques to enhance your SQL querying skills.
• Data Skew Problem and Solution in PySparkJun 26, 2024. Explore the nuances of handling data skew issues in PySpark with effective strategies and solutions. Discover how to optimize performance through smart partitioning, efficient shuffle operations, and leveraging Spark's capabilities.
• Handling Millions of Records with PostgreSQLJun 07, 2024. Handling millions of records with PostgreSQL requires effective strategies and best practices. Key techniques include query optimization, indexing, partitioning, and data sharding. Implementing bulk loading, parallel processing, and regular vacuuming ensures high performance, scalability, and efficient data management.
• Difference between CAP and ACIDMay 30, 2024. Discover the key differences between CAP Theorem and ACID Properties in our comprehensive guide. Understand how CAP's focus on Consistency, Availability, and Partition Tolerance contrasts with ACID's principles of Atomicity, Consistency, Isolation, and Durability.
• pairwise and partition Operator in AngularMay 17, 2024. In Angular's RxJS library, the pairwise operator groups consecutive emitted values into pairs, while the partition operator splits the source observable into two based on a predicate function.
• Exploring Logical and Physical Partitions in Azure Cosmos DBDec 03, 2023. Azure Cosmos DB, Microsoft's globally distributed, multi-model database service, operates on the foundation of logical and physical partitions. Let's delve into their nuances, accompanied by code snippets and examples, to elucidate their functionalities.
• KAFKA for Mere Mortals: Topic replication factorOct 04, 2023. The article will in detail explain why we need a replicas of Partition in KAFKA
• KAFKA for Mere Mortals : Topics and partitions in PracticeSep 21, 2023. The main focus in this article is to create, list, describe and delete topics and partitions in KAFKA
• KAFKA for Mere Mortals : Topics and PartitionsSep 19, 2023. This article describes what is topic and partition and how partitions are split across the brokers
• Calculate Running Total in SQLAug 27, 2023. In this article, we learn about how to calculate running totals in SQL.
• Working with Big Data in SQL ServerApr 25, 2023. Working with Big Data in SQL Server
• Decoding Database Sharding: A Comprehensive OverviewFeb 06, 2023. Database sharding is a technique used to horizontally partition large databases into smaller, more manageable pieces called "shards." Each shard contains a subset of the data, and together they form the complete dataset. Sharding is employed to distribute the database load across multiple servers, allowing for improved performance and scalability. This overview provides insights into the concept of database sharding and its significance in handling massive amounts of data efficiently.
• Memory ManagementApr 25, 2022. Memory management in the operating system is a kind of method or kind of functionality to manage the various kinds of memories. This means in the system there are a lot of different types of memory available like RAM, hard disk, CD, registers, etc., how to manage all the memory resources in a more efficient method. Memory management primarily manages the “primary memory”. Primary memory is the priority of memory management, which means memory management manages the primary memory as the top priority and a very large amount.
• Installing Puppy Linux To A Dedicated PartitionFeb 23, 2022. Describes Puppy Linux distributions and how to install a FossaPup64 Puppy Linux distribution.
• How To Use Data Flow Partitions To Optimize Spark Performance In Data FactoryFeb 15, 2022. In this article, you will learn how to configure the five partition options in Mapping Data Flow. This allows developers to optimize the Spark performance in Azure Data Factory.
• How To Design And Query Data In Cosmos DBJul 02, 2020. In this article, we will discuss document design and structure in Cosmos DB. We also discuss the different query types that can be required to retrieve data from Cosmos DB.
• Converting the Disk Partition From MBR to GPT Using the Command PromptMay 12, 2020. In this article, we will discuss converting the disk partition from MBR to GPT using the Command Prompt.
• How To Format Hard Disk Partition In Windows 10Mar 02, 2020. In this tutorial, I have described how to format a hard disk partition in Windows 10
• How To Create Or Remove A Hard Drive Partition In Windows 10Jan 03, 2020. In this article, I have described how to add or remove a hard Drive Partition or Volume in Windows 10.
• How To Shrink The Hard Disk Partition In Windows 10Dec 30, 2019. In this article, I have described how to shrink the hard disk partition or volume in Windows 10.
• How To Hide Or Unhide Any Drive In Windows 10Dec 30, 2019. In this article, we will learn how to effortlessly hide or unhide drives on Windows 10. Safeguard sensitive data or customize your system's appearance by following our simple step-by-step guide. Master the Disk Management tool and regain control over your drive visibility with ease.
• How To Create A Partitioned View In SQL ServerNov 22, 2019. Learn about creating and utilizing partitioned views in SQL Server for efficient data retrieval and performance optimization. Understand the concept, steps for implementation, check constraint usage, filtering data, and inserting values using partitioned views.
• Introduction To AWS Elastic Block Store - Part ThreeOct 04, 2019. In this article, we are going to learn about mounting a directory to a partition, Disk Formatting Utility, creating partition in a hard disk, and printing the partitions.
• Azure Service Fabric - Understanding Cluster, Replicas, Instances And Partitions - Part ThreeApr 08, 2019. This article explains basic Azure Service Fabric Concepts like Cluster, Replicas, Instances and Partitions. These concepts provide necessary context on how Service Fabric Applications are structured.
• Azure Table Storage Design Manage And Scale Table PartitionsMar 23, 2018. In this tutorial, we will discuss the designing, managing, and scaling of Azure table storage partitions.
• Using SWITCH On A Single PartitionMar 12, 2018. Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding how to move a large amount of data around quickly. The solution was related to an aspect of table partitioning that I was not aware of. If you aren’t familiar with partitions in SQL Server, you can “divide” up a table into different segments or partitions. Often this is found in large tables (think millions/billions of rows) in order to quickly and efficiently move data around. Moving partitions around is a meta-data operation which is what makes it so efficient.
• Azure Cosmos DB - Part Three - Getting Started With Azure Document DBJun 08, 2017. Azure Cosmos DB, Part Three, introduces Azure DocumentDB, a NoSQL database for scalable, globally distributed applications. Explore its multi-model support, including SQL, MongoDB, Cassandra, Gremlin, and Table APIs.
• Creating Azure Search Service And Scaling Replicas And PartitionsNov 30, 2016. In this article, we will discuss how to create Azure Search Service and how to scale replicas and partitions.
• Partition In OracleApr 11, 2016. In this article you will learn about Partition in Oracle.
• Difference Between ROW_NUMBER () OVER () & PARTITION BY ClauseJul 29, 2015. In this article you will learn the difference between ROW_NUMBER(), OVER() and PARTITION BY clauses in SQL Server.
• Creating A Hard Disk Partition Using C#Apr 29, 2015. ICreating a hard disk partition using C# involves interacting with the Windows Disk Management API to programmatically manage disk partitions. This process typically requires administrative privileges as it involves low-level operations on the system's storage devices. Here are the high-level steps to create a hard disk partition using C#.
• NTile Function in SQL ServerJun 25, 2014. The NTile function in SQL Server divides a result set into a specified number of groups, assigning ranks to records within each group. Unlike Dense_Rank, NTile focuses on groups rather than individual ranking.
• NTILE() Function in OracleNov 28, 2013. In this article you will learn about the Oracle NTILE function.
• Install Windows 8 OS by Using a PendriveMar 28, 2013. Install Windows 8 OS using a pendrive by creating a bootable USB with tools like Rufus. Obtain a Windows 8 ISO file, configure BIOS to boot from USB, and follow on-screen prompts for installation. Partition disks as needed and ensure system requirements are met.
• Resize a Partition For Free in Windows 8Jan 05, 2013. In this article we are going to explain how to resize a partition for free in Windows 8.
• How to Shrink Hard Disk Partition in Windows 8Aug 29, 2012. This article describes how to shrink a hard disk volume in Windows 8.
• Create a New Hard Drive Partition in Windows 8Apr 09, 2012. In this article we will explain whole process to create new partition in hard drive and format it through the front end.
• How to assign the Subscriptions to the Partitioned User Profile Service Application Proxy in SharePoint 2010Feb 04, 2011. How to assign the subscriptions to the partitioned user profile service application proxy in SharePoint 2010.
• How to configure User Profile Service application in partition modeFeb 03, 2011. Here we see how to configure User Profile Service application in partition mode.
• Testing Techniques Sep 23, 2010. Software Testing Techniques is divide into 3 parts