Internals blogs

Unit of data in Buffer Pool

August 8, 2017 Internals 1002 Views

/_include/blog-images/article-images/buffer-pool-unit-of-data.jpg

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

/_include/blog-images/article-images/ram-memory2.jpg

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


/_include/blog-images/article-images/runtime-constants.png

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