Table with the most records in the database. | Database me sabse zyada records wali table

Singh Sachina — Fri, 12 Dec 2025 06:49:39 +0000

SELECT TOP 1
s.name AS SchemaName,
t.name AS TableName,
SUM(p.rows) AS TotalRows
FROM sys.tables t
JOIN sys.schemas s ON t.schema_id = s.schema_id
JOIN sys.partitions p ON t.object_id = p.object_id
WHERE p.index_id IN (0, 1)
GROUP BY s.name, t.name
ORDER BY TotalRows DESC;

Making SQL Queries 100x Faster with One Index

Singh Sachina — Thu, 13 Nov 2025 10:03:33 +0000

CREATE INDEX IX___NULL
ON ()
WHERE IS NULL;

🔧 Where to put your actual names?
Replace with your table name
Replace with the column you want to select
Replace with the column that contains NULL values

Creating a filtered index on only the rows where a large column is NULL helps the database avoid a full table scan and makes the query 10x–100x faster.

Forem: Singh Sachina

Table with the most records in the database. | Database me sabse zyada records wali table

Making SQL Queries 100x Faster with One Index