Explanation: Index optimization can reduce this problem. 6. Which of the following stored procedure reports snapshot information about current SQL Server user ?
A. sp_lock
B. sp_who
C. sp_monitor
D. sp_user
Answer:A
Explanation: Index optimization can reduce this problem. 6. Which of the following stored procedure reports snapshot information about current SQL Server user ?
A. sp_lock B. sp_who C. sp_monitor D. sp_user
Explanation:sp_who reports snapshot information about current SQL Server users and processes, including the currently executing statement and whether the statement is blocked. 7. _____________ displays an estimate of the current amount of disk space used by a table.