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 |
Define a cross join?
How to create a scrollable cursor with the scroll option?
What are the disadvantages of primary key and foreign key in SQL?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What are the steps you will take to improve performance of a poor performing query?
What will you do If the low Performance occurs?
What is the difference between for trigger and after trigger?
What is the datatype returned by count(*)
22 Answers 247Customer, Asian CERC,
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
what is datawarehouse?
If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
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)