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 |
What is the difference between a stored procedure and a user defined function in sql server?
How will you monitor replication latency in transactional replication? : sql server replication
How do you run a trace?
What is BCNF? How is it better than 2NF & 3NF?
What is cross join in sql server joins?
What are the database objects? : SQL Server Architecture
Can binary strings be converted into numeric or float data types?
Is foreign key a primary key?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Find columns used in stored procedure?
how would you improve etl (extract, transform, load) throughput?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
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)