What is SQL Profiler and the use of it?
Answers were Sorted based on User's Feedback
Answer / anilreddy
To check how much time a query is going to execute.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / pradeep
Sqlprofiler is a tool to debug, troubleshoot,monitor and measure your applications and sqlstatements and stored procedures.The tool enables you to select which events you want to monitor .......
Is This Answer Correct ? | 4 Yes | 1 No |
Characterize join and name diverse sorts of joins?
How can you ensure that the database and sql server based application perform well?
What is the difference between composite index and covering index?
Explain difference between cross join and full outer join?
what operator performs pattern matching?
How to provide default values to stored procedure parameters?
What is an execution plan? When would you use it? How would you view the execution plan?
How to use union to merge outputs from two queries together in ms sql server?
Does index speed up select statements?
Is it important for a database administrator to understand the operating system and file access?
What is raid and what are different types of raid levels?
How to change server name in sql server?