When do you use SQL Profiler?
Answers were Sorted based on User's Feedback
Answer / guest
SQL Profiler utility allows us to basically track
connections to the SQL Server and also determine activities
such as which SQL Scripts are running, failed jobs etc..
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / vj tan
SQL Server Profiler shows how SQL Server resolves queries
internally. This allows administrators to see exactly what
Transact-SQL statements or Multi-Dimensional Expressions
are submitted to the server and how the server accesses the
database or cube to return result sets.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / seyed riswan
Profiler help us to view the changes happened in the back
end process.
| Is This Answer Correct ? | 1 Yes | 3 No |
Explain ms sql server reporting services vs crystal reports?
How data can be copied from one table to another table?
How to create new tables with "select ... Into" statements in ms sql server?
What are SQL Jobs, please mention the use of it and how to create them.
What is cross join in sql server joins?
What is the use of stored procedure?
How to make a column nullable?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
What is attribute? : sql server analysis services, ssas
What is the difference between Drop and Truncate
What is model database? : SQL Server Architecture
What is the purpose of self join?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)