IUIndira Unnikrishnaninlearnandlead.hashnode.dev·Aug 26, 2025 · 7 min readSQL OptimizationSQL is the language that helps us talk to databases, and like any language, it's more effective when used wisely. Imagine you're looking for a book in a giant library. Would you walk down every aisle, or would you use a catalog to go straight to it? ...00
IUIndira Unnikrishnaninlearnandlead.hashnode.dev·Aug 25, 2025 · 4 min readMastering SQL Server Window Functions – ConceptsSQL Server window functions are essential for analytics, reporting, and business intelligence. They allow you to perform calculations across sets of rows while retaining row-level detail. In this article, we’ll explore the most important window funct...00
IUIndira Unnikrishnaninlearnandlead.hashnode.dev·Jul 23, 2025 · 8 min readCommon Table Expressions (CTEs) in SQLA Deep Dive into Understanding, Writing, and Optimizing CTEs Introduction to CTEs When solving a complex math problem, we often break it into smaller steps, solve those and then combine the answers. Common Table Expressions, better known as CTE is ju...00