Answer Posted / sql developer

Hi,

Here is the difference between SQL Server 2005 and SQL
Server 2008.

Its contains difference between various versions of SQL
Server:

http://learnsqltips.blogspot.in/2012/01/introduction-to-sql-
server.html

What is autocommit mode in sql server?

1078

---

Does sql server use java?

995

---

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

914

---

Differentiate between ms sql server reporting services vs crystal reports?

853

---

Do you know data definition language, data control language and data manipulation language?

982

---

between cast and convert which function would you prefer and why?

916

---

What is a matrix in ssrs?

135

---

What is the most common type of join?

913

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1011

---

What are the 7 disadvantages to a manual system?

907

---

how can u get last observation in an unknown dataset ?

2387

---

What is the New in SQL server 2008?

917

---

What is the difference between online clustering and Offline clustering?

2356

---

Write an sql query for deleting duplicate rows?

952

---

What are character string data types in ms sql server?

1140

---