What is SQL Profiler what is the use of it?
Answer Posted / tap_ks
SQl Profiler is a tool provided by SQL Server, which can
capture the queries, procedures executed on the database.
It also capture all the details like user, m/c, input
parameters, time of execution etc. This is very helpful
while bebugging any query / procedure.
| Is This Answer Correct ? | 21 Yes | 2 No |
Post New Answer View All Answers
what are isolation levels? : Sql server database administration
Explain filtered indexes?
What is the difference between substr and charindex in the sql server?
What is molap and its advantage? : sql server analysis services, ssas
What is dbcc? Give few examples.
What is built-in/administrator?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What is the difference between char, varchar and nvarchar?
Explain filtered indexes benefits?
What is PROJECTION Operation?
How to loop through the result set with @@fetch_status?
List some of the rules that apply to creating and using a ‘view’
What is use of except clause? How it differs from not in clause?
What is a transactions?
what is isolation level at dead lock?