you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  

---

What do you mean by normalisation?

0 Answers  

---

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

---

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  

---

What are the steps you must follow to hide sql server instances?

0 Answers  

---

What are the events recorded in a transaction log?

0 Answers  

---

How to use the inserted and deleted pseudo tables?

0 Answers  

---

What is self contained scalar sub query?

0 Answers  

---

WHAT OPERATOR PERFORMS PATTERN MATCHING?

2 Answers   CarrizalSoft Technologies, CTS,

---

In which files does sql server actually store data?

0 Answers  

---

how would you troubleshoot blocking? : Sql server database administration

0 Answers  

---

How can I check if a view exists in a sql server database?

0 Answers  

---