Answer / rohit bhosale

Sql SErver 2008 exist with a highly available concepts that
are helpful to provide data security or protection,to
improve performance while SQL Server 2005 is lack of these
concepts hence We all are preferable to use 2008.

Answer / dinesh rathod

1, XML datatype is introduced. XML datatype is used. 2, Can not encrypt the entire database.

Explain the difference between clustered and non-clustered index?

0 Answers  

---

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

---

Advantages and Disadvantages of Cursor?

15 Answers   Polytechnic, TCS, Zenith,

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

0 Answers  

---

Why I can not enter 0.001 second in date and time literals in ms sql server?

0 Answers  

---

what is a self join? Explain it with an example? : Sql server database administration

0 Answers  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

how to connect sybase to sql server 2005?.

1 Answers   ABC,

---

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,

---

How do you optimize Sql queries ?

0 Answers   Cognizant,

---

What is normalization? Explain its different types?

0 Answers   GE, Maveric,

---

Explain the steps to use transact-sql cursor?

0 Answers  

---