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 |
How do triggers work?
How to declare a cursor with "declare ... Cursor" in ms sql server?
What is join and name different type of joins?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What is an indexing strategy?
What is 'Join' and explain its various types.
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
Can we return Data from 4(more than 1) tables in stored procedure?
Which are the new data types introduced in sql server 2008?
Name few of the dcl commands in sql?
What are the different types of sub-queries?
How to Check Whether a Global Temporary Exists in a SQL Database or not?
Oracle (3259)
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)