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.

Do you know the isolation level that sql server support?

0 Answers  

---

What is Dependency Injection and provide example?

0 Answers  

---

How do I find the sql server instance name?

0 Answers  

---

What is user-defined scalar function?

0 Answers  

---

Explain temporary table vs table variable by using cursor alternative?

0 Answers  

---

---

How and why use sql server?

0 Answers  

---

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

0 Answers   CSC, IBM,

---

Explain the basic concepts of SQL server architecture?

2 Answers   College School Exams Tests,

---

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

How to check parameter value in stored procedure sql server?

0 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,

---

Explain the truncate command? : SQL Server Architecture

0 Answers  

---