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 onf in normalization form?

0 Answers  

---

What is bcnf normalization form?

0 Answers  

---

How to view existing indexes on an given table using sys.indexes?

0 Answers  

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

0 Answers  

---

Working with TLogs

0 Answers  

---

---

What is blocking and how would you troubleshoot it?

2 Answers  

---

How will you collect the date from current date to last older 6 days date in sql server 2005

4 Answers  

---

What are the differences between local and global temporary tables?

0 Answers  

---

Why do you want to join software field as you have done your BE in Electronics?

0 Answers   Cap Gemini, HCL,

---

How to recreate an existing index in ms sql server?

0 Answers  

---

What is a print index?

0 Answers  

---

What is 1nf normalization form?

0 Answers  

---