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 |
Describe how to use linked server?
What is data compression?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is plan freezing?
How to get a list of all tables with "sys.tables" view in ms sql server?
Do you know what are the reporting services components?
How to bind a view to the schema of the underlying tables?
Is it possible to replicate data from sql server to oracle? : sql server replication
What is a result set object returned by mssql_query()?
What are extended events in sql server?
What is the largest component inside a field?
What is user defined datatypes and when you should go for them?