Show 41 - IFI

21/02/2016 26 min
Show 41 - IFI

Listen "Show 41 - IFI"

Episode Synopsis

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