Answer Posted / 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 instead of trigger sql server?

502

---

Explain filtered indexes benefits?

596

---

Mention what are the different types of ssrs reports?

98

---

What is tempdb in sql server?

520

---

What is db stored procedure?

469

---

---

How do I find the query plan in sql server?

547

---

Explain ms sql server reporting services vs crystal reports?

500

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

516

---

Explain the stored procedure?

640

---

please differentiate between delete and truncate?

560

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

589

---

What do you mean by an execution plan?

568

---

What is the main difference between ‘between’ and ‘in’ condition operators?

591

---

Explain triggers?

563

---

Why the trigger fires multiple times in single login?

726

---