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}

what are user defined datatypes? : Sql server database administration

960

---

How to see the event list of an existing trigger using sys.trigger_events?

1065

---

what is denormalization and when would you go for it? : Sql server database administration

1168

---

How do I start sql server 2016?

896

---

What is indexing a document?

1030

---

do you know how to configure db2 side of the application? : Sql server database administration

1039

---

Can you move the resources after pausing the node? : sql server database administration

1093

---

How to get a list of columns in a view using the "sp_help" stored procedure?

1030

---

What does indexation mean?

969

---

What to perform pattern match with the like operator?

875

---

How to return the date part only from a sql server datetime datatype?

1095

---

What are the advantages of stored procedure in sql server?

887

---

What does dml stand for?

942

---

How to declare and use cursor variables?

1158

---

How to change the ownership of a schema in ms sql server?

1178

---