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 are isolation levels? : Sql server database administration

0 Answers  

---

hi... this is charan.I persued btech in 2010 looking for a job on database/back-end as freehser. can any seggest me which course or back-end tool i have to learn

0 Answers  

---

Explain left outer join and right outer join?

0 Answers  

---

is it important for a database administrator to understand the operating system and file access? : Sql server administration

0 Answers  

---

Give an example of SQL injection attack ?

0 Answers   HAL,

---

Can we insert data into a view?

0 Answers  

---

How to optimize stored procedures in sql server?

0 Answers  

---

What number aggregate functions are accessible there in sql?

0 Answers  

---

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,

---

How to find the service pack installed? : sql server database administration

0 Answers  

---

What is sql server schema compare? How we can compare two database schemas?

0 Answers  

---

Can we execute a stored procedure inside a trigger?

6 Answers   BirlaSoft, CarrizalSoft Technologies, United Healthcare,

---