Answer Posted / guest

You can set SQL Server to display information regarding the
amount of disk activity generated by T-SQL statements. This
option displays the number of scans, the number of logical
reads (pages accessed), and the number of physical reads
(disk accesses) for each table referenced in the statement.
This option also displays the number of pages written for
each statement. When STATISTICS IO is ON, statistical
information is displayed. When OFF, the information is not
displayed. After this option is set ON, all subsequent T-
SQL statements return the statistical information until the
option is set to OFF.
Here is the syntax:

SET STATISTICS IO {ON | OFF}

Can you explain different types of locks in sql server?

992

---

Explain something about security and SQL Azure?

134

---

How sql server enhances scalability of the database system?

1313

---

What is the guest user account in sql server? What login is it mapped to it? : sql server security

1111

---

What is Command line parameters in PLSQL.?

1183

---

How do I start sql server 2016?

950

---

Which are the olap features?

1006

---

What is the chart in report?

165

---

Explain what is analysis service repository?

1046

---

Does a server store data?

953

---

What information is maintained within the msdb database?

1016

---

How you can add messages to the nt event log from within a stored procedure?

1134

---

What are sql servers used for?

1111

---

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

1021

---

Can you explain what are commit and rollback in sql?

984

---