Month: February 2020

https://youtu.be/8ugpVfPzvz4 In this video we are going to talk about auto update statistics. This is a feature in the database engine that automatically triggers a stat update when data has been updated beyond a threshold. In previous versions of SQL server this thresh hold was 500 rows followed by every 20% increase in the count…

In this video we cover the next database option which is AUTO CREATE INCREMENTAL STATISTICS. This option is useful when the database has partitioned tables. It allows the DBA to update stats by merging the updated stats for the partition in question with existing stats. In this way DBA are able to reduce the overhead…

Auto create stats is one of those database options that every DBA knows they should set to ON. In this video we explore what happens when you set if OFF and why having good stats is important for query optimizations. We explore the impact of not having statistics on a simple query and then cover…

Auto close is one of those features that should have been removed long back. The setting needs to stay at default of OFF for reasons that will be made obvious in this video. In this series of videos we cover each of the database options what they do and why they should be set to…

https://www.youtube.com/watch?v=SftUYP6nchk PowerBI is a robust reporting tool that has a number of easy to use and configurable options when it comes to reporting. One of the most frequently used features in PowerBI is the bookmarks capability. A bookmark as its name suggest provides way to snapshot a report page keeping in mind the filters and…