Skip to content

Instantly share code, notes, and snippets.

@dalenewman

dalenewman/Set Statistics On and Off

Last active August 29, 2015 14:24
Show Gist options
  • Save dalenewman/fa0ebe0276b5f6a67617 to your computer and use it in GitHub Desktop.
Save dalenewman/fa0ebe0276b5f6a67617 to your computer and use it in GitHub Desktop.
Download ZIP
Checking Performance Statistics on Query - Microsoft SQL Server
Raw
Set Statistics On and Off
SET STATISTICS IO ON;
SET STATISTICS TIME ON;
SET STATISTICS XML ON;
/* your query here */
SET STATISTICS IO OFF;
SET STATISTICS TIME OFF;
SET STATISTICS XML OFF;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment