SQL Server Tips

Getting Started with Web applications development with servlets and JSP - Part 5: Filters

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Upload Image

Close it

Select File

Learned something today? Share it, or learn from what others have learned today

Tips · Submit A Tip · Members (427) · Preferences · Feedback · Most Liked · Most Learned · Most Discussed · Silver Rated

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]

Mahadevan N

111 · 2% · 408

Liked

Knew

Learned

Incorrect

Interesting

Forgotten

Move


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
This post should be moved to a more appropriate category

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

3 · 39% · 8882

Sign Up or Login to post a comment.