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}

Using the customer, and order table in northwind database, please write a query to produce xml?

0 Answers  

---

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

0 Answers  

---

What is the difference between createstatement and preparedstatement?

0 Answers  

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

0 Answers  

---

Why SQL Agent is used?

0 Answers   Abacus,

---

Explain concepts of analysis services?

0 Answers  

---

Can we update data in a view?

0 Answers  

---

What are pessimistic lock and optimistic lock?

0 Answers  

---

What is the sql profiler?

0 Answers  

---

What does this statement do @@rowcount?

0 Answers  

---

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

How to get @@error and @@rowcount at the same time?

0 Answers  

---