Recently I came across a video in which it was suggested the Page Splits/sec counter was not useful in identifying Page splits and that using fill factor to […]
Script showing how partitioning improves performance – With Video
In this post I have provided the link and script for the video demonstrating how Partitioning improves performance. Video on how to use the script The Script
DB options: – Recovery intervals and Checkpoint
In this video we talk about recovery intervals. Specifically how checkpoint allows recovery intervals to be maintained. Checkpoint is a feature that allows SQL server to recover faster […]
Database Options: – Filestream
Filestream is a great feature for databases that have to handle a large volume of BLOB data. It allows the DBA to store data in Filesystem folders rather […]
DB Options: – Parameterization
In this video we cover the two options available under parameterization in MSSQL database properties. Ad hoc queries are queries that aren’t stored procedures. Since the code is […]
DB Options: Page Verify
https://youtu.be/eXLELsEVAP0 It’s become significantly rarer for database corruption to occur nowadays because of hardware and software improvements. In older version of SQL Server it was fairly common for […]
DB Options – ANSI WARNINGS | ANSI PADDING and more
In this video we cover multiple database options most of which are fairly easy to understand and don’t really require significant research before being set. Often these settings […]
DB Options: – ANSI NULL DEFAULT ON
https://youtu.be/SAzmOEqVoIQ Another one of the database options which doesn’t serve any real purpose. As shown in this video the setting is overridden by session level settings so it […]
DB Options: – ANSI NULL DEFAULT ON
https://youtu.be/SAzmOEqVoIQ Another one of the database options which doesn’t serve any real purpose. As shown in this video the setting is overridden by session level settings so it […]
DB options: – Auto Shrink = OFF
The use of AUTO SHRINK I think needs no explanation. Almost anybody who has worked on SQL Server understands the way databases can quickly grow. In these cases […]