Monthly Archives: September 2020

A nice to have feature when working with databases is the different ways to create functions and procedures to create reusable queries. I don’t say queries used with applications, because you in the database layer for applications you should avoid putting too much logic and filtering in the database and instead add it to the… Read More »

Index fragmentation is bad and makes you queries runs slower than expected, and requires additional space on you hard drive. SQL Server stores data in 8KB pages. These 8KB pages are stored sequentially in heap tables, that is tables without any clustered index. In tables with clustered indexes (or non-clustered covered indexes) data is stored… Read More »