How to write a query with an inner join in ms sql server?

0 Answers  

---

Explain primary key?

0 Answers  

---

What is tempdb database? : SQL Server Architecture

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers   HCL,

---

Why I am getting this error when renaming a database in ms sql server?

0 Answers  

---

---

How to a Query to copy data from on table to another table.

6 Answers   Cap Gemini,

---

Can you explain important index characteristics?

0 Answers  

---

What is openxml in sql server?

0 Answers  

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

0 Answers  

---

Which are the new data types introduced in sql server 2008?

0 Answers  

---

Explain the purpose of indexes?

0 Answers  

---