Answer / tap_ks

SQl Profiler is a tool provided by SQL Server, which can
capture the queries, procedures executed on the database.
It also capture all the details like user, m/c, input
parameters, time of execution etc. This is very helpful
while bebugging any query / procedure.

Answer / rathi

SQL profiler is a graphical tool that allows system
administrator to monitor in an instance of the SQL Server.

Use of SQL Profiler:
• Monitor the performance of an instance of SQL
Server.
• Debug Transact-SQL statements and stored procedures.
• Identify slow-executing queries.
• Test SQL statements and stored procedures in the
development phase of a project by single-stepping through
statements to confirm that the code works as expected.
• Troubleshoot problems in SQL Server by capturing
events on a production system and replaying them on a test
system. This is useful for testing or debugging purposes
and allows users to continue using the production system
without interference.
• Audit and review activity that occurred on an
instance of SQL Server. This allows a security
administrator to review any of the auditing events
including the success and failure of a login attempt and
the success and failure of permissions in accessing
statements and objects.

What is use of except clause? How does it differ from not in clause?

0 Answers  

---

what is difference between view and Dip.

0 Answers   IBM, L&T,

---

How to get number of days in a given year?

4 Answers   ADP,

---

How many databases instances are there in sql server 2000?

0 Answers  

---

What are different types of statement?

0 Answers  

---

How to run sql server 2005 books online on your local system?

0 Answers  

---

What will be the maximum number of indexes per table?

0 Answers  

---

Write a sql query to get zero records from a table having n number of records?

0 Answers   TCS,

---

What are logical/boolean operations in ms sql server?

0 Answers  

---

hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 Answers   Google, TCS, Unisys,

---

how can you move the master database

1 Answers   IBM,

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

---