Just Learned - SQL Server - SET STATISTICS commands can be combined more than one in a single line by separating them with commas

Getting Started with Adobe After Effects - Part 6: Motion Blur

A collection of quick technology learning tips from what people around you learn every day

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

SQL Server - SET STATISTICS commands can be combined more than one in a single line by separating them with commas

Dec 7 2011 10:11PM by Mahadevan N

We might have used below commands while working on Tuning to identify the CPU time, Elapse Time and ,No.of Reads.

SET STATISTICS IO ON SET STATISTICS TIME ON

We can combine this two commands on a single line by separating them with commas as below SET STATISTICS IO, TIME ON

Read More.. [0 clicks]

Published under: SQL Server Tips · · · ·

Mahadevan N

94 · 2% · 589

Liked

Knew

Learned

Incorrect

Interesting

Forgotten


Post this to my facebook wall
Tweet this
Like This
I knew this before
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
I knew it but i have forgotten it

Thank you for sharing tip...

Though i know this for some time, I am not using in practise. Often i put individual commands. Needs to start to utilize this..

commented on Dec 7 2011 10:13PM

Ramireddy

2 · 41% · 12972

Sign Up or Login to post a comment.