There are a number of dials and knobs in SQL Server that allow the DBA to fine tune almost every aspect of the server. In this post I […]
Tuning SQL Server using Fill Factor to control page splits
Is it better to take a hit on performance due to Fill Factor or Page Splits? That is the question being answered in this video. As with most […]
Why you should continue to defrag your indexes:-What are page splits 1/4
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
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 database […]
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://www.youtube.com/watch?v=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 […]