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}

Define self join in sql server joins?

0 Answers  

---

How to delete the duplicate rows from a table in SQL Server ??

3 Answers  

---

I have to display ten columns values from diffrent ten tables. how many joins are require?

10 Answers   CarrizalSoft Technologies, HCL,

---

Is it ok to shrink transaction log?

0 Answers  

---

What are the basic features of a trigger in ms sql server?

0 Answers  

---

Tell me what is normalization? Explain different forms of normalization?

0 Answers  

---

How many types of Cursor in SQL SERVER?

1 Answers  

---

What is BLOCK statements in SQL?

0 Answers   HCL,

---

What authentication modes does sql server support?

0 Answers  

---

How do you fine the performance tunning?

2 Answers   Accenture,

---

What is the difference between a primary key and a unique key? Are they the same?

0 Answers  

---

How to download and install microsoft sql server management studio express?

0 Answers  

---