In a previous post we’ve discussed the importance of statistics, its underlying structure and explored how SQL Server uses them to come up with execution plans. We’ve saw that the query optimizer computes a histogram on the column values in… Read More ›
Month: Agosto 2020
The Deceiving N
In this post, we’ll briefly look into a common misconception about nchar and nvarchar data types. We begin by setting the breakfast table: Later, someone spots our mistake creating the breakfast menu and tries to apply the only logical correction… Read More ›
Wait Stats#1: SOS_SCHEDULER_YIELD
In order for you to have a happy life as someone responsible for a database, you need to ensure that it follows a strict diet consisting of well-designed queries and indexes, plenty of CPU, memory and disk capacity. Neglecting any… Read More ›