Lab 01 - Introduction to SQL Server Management Studio

Last updated Mar 17, 2023

Lab01

1

SET STATISTICS IO ON

Causes SQL Server to display information about the amount of physical and logical IO activity generated by Transact-SQL statements. Physical IO is related to accessing data pages on disk and logical IO is related to accessing data pages in memory (data cache).

More info here

1

SET STATISTICS TIME ON

Displays the number of milliseconds required to parse, compile, and execute each statement.

More info here