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}

How many columns can exist together per table?

1 Answers   Cap Gemini,

---

What is the recursive stored procedure in sql server?

1 Answers  

---

What are different types of table joins?

1 Answers  

---

What is user-defined function?

1 Answers  

---

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 Answers  

---

Can you give an example of Stored Procedure?

4 Answers   Wipro,

---

i want table name basis on column name.

5 Answers  

---

What is inner join? Explain with an example?

1 Answers  

---

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

---

What is the difference between HAVING clause and the WHERE clause?

7 Answers  

---

Do you know what is openxml in sql server?

1 Answers  

---

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

---