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 […]
Using Snippets in SSMS
A little know and used feature by database developers is Snippets. Database developers understandably do not use this feature because we have long been accustomed to using prebuilt […]
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 […]
DB Options: – AUTO UPDATE STATS / ASYNC
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 […]