Answer / 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 is simple indexing method?

0 Answers  

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

---

What is the difference between Clustered and Non-Clustered Index?

0 Answers  

---

What is query optimizer in sql server?

0 Answers  

---

What is data source document?

0 Answers  

---

What is sorting and what is the difference between sorting and clustered indexes?

1 Answers  

---

How to create a scrollable cursor with the scroll option?

0 Answers  

---

What is difference statement and preparedstatement?

0 Answers  

---

Explain linked server in sql?

0 Answers  

---

What is SQL Profiler what is the use of it?

2 Answers   247Customer, Steria,

---

When is update_statistics command used?

0 Answers  

---

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

0 Answers   IBM,

---