Answer / neeladhar.n

sp_helpdb.
it will give the name & size of all the Databases.

What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  

---

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?

0 Answers  

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

0 Answers  

---

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

3 Answers  

---

SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

1 Answers   CarrizalSoft Technologies,

---

Write down the syntax and an example for create, rename and delete index?

0 Answers  

---

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 different types of locks in the database?

0 Answers  

---

Tell me what is de-normalization and what are some of the examples of it?

0 Answers  

---

select names starts with a,b,c

8 Answers   Scope International,

---

What is exporting utility?

0 Answers  

---

What is query optimizer in sql server?

0 Answers  

---