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 primary key index?

0 Answers  

---

Explain sql server authentication modes?

0 Answers  

---

What is an execution plan? How would you view the execution plan?

0 Answers  

---

Do you know spatial data types - geometry and geography in sql server 2008?

0 Answers  

---

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 Answers  

---

Which command displays the SQL command in the SQL buffer, and then executes it?

3 Answers   TCS,

---

logshipping is Any difference 2000 and 2005?

2 Answers  

---

Is it possible in sql table to have more than one foreign key?

0 Answers  

---

Define tempdb database?

0 Answers  

---

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  

---

How to create an inline table-valued function?

0 Answers  

---

What is query processing?

0 Answers  

---