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.

How to create a new schema in a database?

0 Answers  

---

Give an example of SQL injection attack ?

0 Answers   HAL,

---

Explain isolation levels that sql server supports?

0 Answers  

---

What is normalization?

9 Answers  

---

How many types of Outer Joins?What are they?

1 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

In the primary key have a multiple field or not?

8 Answers   TCS,

---

how to determine the service pack currently installed on sql server? : Sql server database administration

0 Answers  

---

How to enable/disable indexes?

0 Answers  

---

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

7 Answers   ADP, Satyam, Tech Mahindra,

---

What is Left Outer Join?

2 Answers  

---

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  

---