How will u find the query which is running in some other
machine
Answer Posted / krishna thamisetty
Using SQL Profiler
You can find this tool
Start Menu\Programs\Microsoft SQL Server 2005\Performance
Tools\SQL Server Profiler
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Define model database?
What is the recommended total size of your memory optimized tables?
What happens if ntwdblib.dll is missing on your machine?
What is the difference between Stored Procedures and triggers?
Explain relational data?
How can windows applications connect to sql servers via odbc?
How to delete multiple rows with one delete statement in ms sql server?
What does dml stand for?
What is a group function explain with an example?
What are the limitations/drawbacks or ssrs 2008 r2?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What command would you use to add a column to a table in sql server?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
Does sql server use t sql?
How to use wildcard characters in like operations in ms sql server?