Download Episode (mp3)

In this show, we talk about:

* External deadlines

* The RS.EXE utility and what it is used for

* Why you shouldn't use Task Manager to check how much memory SQL Server consumes

* The Lock Pages in Memory option

* Stored procedure execution options under Transactional Replication

* Instant File Initialization checkbox in SQL Server 2016 setup

* SQL Server Agent job history

* Fixed server roles and how to correctly configure logins in SQL Server

Items mentioned in the show:

* Scott Murray - SQL Server Reporting Services RS.EXE Utility

* Gail Shaw - Stop using Task Manager to check SQL’s memory usage!

* SQLSaturday Israel

* Guy's Big Data seminar at SQLBits