Answer / Km.nicky

A live lock, also known as deadlock, occurs in SQL Server when two or more processes are waiting for resources held by each other, leading to no progress.

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

---

How to create a user name in a database?

1 Answers  

---

Why is sql server log file full?

1 Answers  

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---

Which data type columns are the best candidates for full-text indexing?

1 Answers  

---

Name three of the features managed by the surface area configuration tool? : sql server security

1 Answers  

---

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  

---

Can you please differentiate between a primary key and a unique key?

1 Answers  

---

how will u create "n" possible tables in sql...

1 Answers   Oracle,

---

What is the purpose of indexing?

1 Answers  

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

2 Answers  

---

What method is used by the Command classes to execute SQL statements that return single values?

1 Answers   B-Ways TecnoSoft,

---