Results for "ROW_NUMBER()"
6 / 14 posts
Filter by Category
Window Aggregate Functions in SQL
What is window function: Imagine you have a dataset with many rows, and you want to perform some calculations on each row based on a group of rows related …
SQL Server Pagination
What is Pagination? Pagination means fetching data in small chunks (pages) instead of loading thousands of rows at once. Think of Google Search — you don't s...
Dynamic Date Series in SQL Server (Financial Year + Calendar Year Handling)
When working with reports, analytics, or dashboards in SQL Server, one common requirement is generating a continuous date series between two dates — especial...
SQL Server User-Defined Functions (UDF)
SQL Server ke saare User-Defined Functions — Scalar, Inline TVF, MSTVF — ko ek jagah samjho. Real examples, performance tips, aur interview questions ke saath.
Index Rebuilding vs. Reorganization in SQL Server
As a database grows, maintaining optimal performance becomes crucial. One of the key contributors to performance degradation over time is index fragmentation...
How to one series with comma separate(any Delimiter) value split into in rows
If we have one series with comma separate(any Delimiter) value and we want split into in rows, I have create function for that: CREATE OR ALTER FUNCTION [dbo...