Month: April 2020

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 ad-hoc in nature we see that the WHERE condition often has hard coded values. Each time the hard coded value changes we see a new execution plan…

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 database pages to be corrupted when written to disk especially during power failures etc. Page Verify is one of the options that SQL Server uses to identify…