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}

What is 1nf 2nf and 3nf?

891

---

SQL Server Architecture ?

2456

---

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

---

What is the return type of executeupdate ()?

906

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2221

---

What are the different authentication modes in sql server? How can it be changed?

1087

---

What is store procedure? When do you use?

933

---

Is mysql better than sql server?

1059

---

Can you create a logon trigger in sql server 2005 express edition?

1079

---

What is user defined datatypes and when you should go for them?

1014

---

What is join and name different type of joins?

1051

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1119

---

What is default constraint in ms sql server?

1034

---

Explain the difference between functions and stored procedures in sql server?

976

---

What are the different sql server versions?

980

---