SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video

SQL Server management Studio 2012 is wonderful tool and has many different features. Many times, an average user does not use them as they are not aware about these features. Today, we will learn one such feature. SSMS comes with many inbuilt performance and activity reports, but we do not use it to the full potential.

Connect to SQL Server Node >> Right Click on it >> Go to Reports >> Click on Standard Reports >> Pick Any Report.

Please note that some of the reports can be IO intensive and not suggested to run during business hours!

More on Standard Reports:

SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS
SQL SERVER – Generate Report for Index Physical Statistics – SSMS
SQL SERVER – Configure Management Data Collection in Quick Steps

I encourage you to submit your ideas for SQL in Sixty Seconds. We will try to accommodate as many as we can.

If we like your idea we promise to share with you educational material.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio
Previous Post
SQL SERVER – SmallDateTime and Precision – A Continuous Confusion
Next Post
SQL SERVER – A Puzzle – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value

Related Posts

5 Comments. Leave new

  • Hi Pinal,
    Can you please specify 1 line use of each of these standard reports?

  • We know we can generate report using standard reports option on sql server
    but it would be good if you could eloborate on each and every report in detail

  • how does one edit the standard reports? I am wanting to look at “Shema Changes History” for more than 3 months


Leave a ReplyCancel reply

Exit mobile version