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}

How does recursive cte works in sql server?

1016

---

How to Insert multiple rows with a single insert statement?

1056

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

947

---

Comment,Datatypes are unlimited

2059

---

What is difference between joins and subqueries?

1120

---

How to create a local temporary stored procedure?

998

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1037

---

Do you know what is a with(nolock)?

1057

---

Explain SSRS Architecture?

195

---

Explain why variables called the most powerful component of ssis?

1102

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1091

---

What are the steps you should follow to start sql server in single-user mode?

905

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1064

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

944

---

Why truncate is ddl command?

1066

---