Answer Posted / 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}

can an automatic recovery be initiated by a user? : Sql server administration

911

---

What does the on delete cascade option do?

971

---

Explain what is cte (common table expression)?

1075

---

What are the different normalization forms?

1054

---

What are partitioned views?

946

---

Describe the functionalities that views support.

1066

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1099

---

Is sql server 2016 free?

888

---

What is the downside of using udf?

1055

---

What is the difference between row_number and dense_rank?

839

---

Can we do dml on views?

921

---

How to download microsoft sql server 2005 express edition?

986

---

what is the system function to get the current user's user id? : Sql server database administration

967

---

What is store procedure? How do they work?

962

---

how many type of indexing in database?

943

---