Internals blogs

Unit of data in Buffer Pool

August 8, 2017 Internals 1002 Views


SQL Server updates 8KB of data when you update one single bit of data.

Read More

Why does SQL Server consume so much memory?

August 8, 2017 Internals 1442 Views


There is a reason why SQL Server consumes so much memory; It does not leak memory, and there is a reason behind that.

Read More


Some SQL functions are constants. They get evaluated once at the beginning of the query and remain the same all over the execution time. One good example is the GETDATE() function.

Read More