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}

Explain full-text indexing?

0 Answers  

---

What is executereader?

0 Answers  

---

How reterive duplicate value in SQL?

6 Answers  

---

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

0 Answers   Value Labs,

---

Can a table have 2 primary keys?

0 Answers  

---

Why are you getting errors when creating a new odbc dsn?

0 Answers  

---

What is the largest component inside a field?

0 Answers  

---

How to transfer data from a cursor to variables with a "fetch" statement?

0 Answers  

---

what is the Ticketing tool used in Wipro technologies at Bangalore...???

0 Answers   Liquid Hub,

---

What is the maximum size of column in sql server?

0 Answers  

---

How to stop log file growing too big?

0 Answers  

---

How to change the password of a login name in ms sql server?

0 Answers  

---