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}

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

2 Answers   ADP,

---

What is the difference between Normalization and De-normalization?

0 Answers   TCS,

---

what is the difference between count(*) and count(1) ?

0 Answers   MCN Solutions,

---

How to count groups returned with the group by clause in ms sql server?

0 Answers  

---

How would we use distinct statement? What is its use?

0 Answers  

---

How can you list all the columns in a database?

0 Answers  

---

What is the Control Flow in SSIS

0 Answers   HCL,

---

What is dbcc command in sql server?

0 Answers  

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---

What is Cross Join and in which scenario do we use Cross Join?

0 Answers   QuestPond,

---

Is sql server is free?

0 Answers  

---

Can I delete event logs?

0 Answers  

---