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 transact-sql language?

0 Answers  

---

Which tcp/ip port does sql server run on? How can it be changed?

0 Answers  

---

What is the log shipping?

0 Answers  

---

What is the purpose of object explorer and its features? : sql server management studio

0 Answers  

---

What is log in sql server?

0 Answers  

---

How can you get @@error and @@rowcount at the same time?

9 Answers  

---

Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  

---

What is user-defined inline table-valued function?

0 Answers  

---

What is the command used to recompile the stored procedure at run time?

0 Answers  

---

how can do you the system monitoring?

1 Answers  

---

Write a sql query to display the current date?

0 Answers  

---

What is the Main Difference between ACCESS and SQL SERVER?

0 Answers   MindCracker,

---