1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,

---

What is a stored procedure?

3 Answers  

---

What is a transaction and what are ACID properties?

3 Answers  

---

what is a live lock? : Sql server database administration

0 Answers  

---

Can you create a logon trigger in sql server 2005 express edition?

0 Answers  

---

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

0 Answers  

---

What are the steps you can take to avoid “deadlocks”?

0 Answers  

---

How to declare and use cursor variables?

0 Answers  

---

What is difference between rownum and row_number?

0 Answers  

---

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  

---

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

1 Answers  

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---