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}

how to create a scrollable cursor with the scroll option? : Sql server database administration

1025

---

What is the exact numeric data type in sql?

960

---

What do you mean by cardinality?

848

---

Where to find ntwdblib.dll version 2000.80.194.0?

920

---

How can you set the threshold at which sql server will generate keysets asynchronously?

938

---

Which is the latest version of sql server and when it is released?

1027

---

What is a select query statement in ms sql server?

1007

---

What is logon trigger?

1028

---

What is a subquery in a select query statement in ms sql server?

1065

---

What is the purpose of linked server configuration in sql server?

992

---

What is spid in sql server profiler?

1026

---

List out a number of the wants to setup a SQL Server failover cluster?

1007

---

Will the writetext statement activate a trigger?

999

---

What is postgresql server?

941

---

Do you know concepts and capabilities of sql server?

1005

---