Answer / guest

backup compersion
activitymoniter
policy managment
centerlized managment
date,time datatypes

Answer / 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

Answer / guest

Hi, frnds
Main difference is 2008 intellegence is available and which
function are avalible in particular table.

What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,

---

Where the sql logs gets stored?

0 Answers  

---

What is the use of @@spid?

0 Answers  

---

Difference between group by clause and having clause in SQL?

0 Answers   Flextronics,

---

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---

Explain the properties of subqueries in sql server?

0 Answers  

---

Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

8 Answers  

---

Describe in brief databases and sql server databases architecture.

0 Answers  

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

0 Answers  

---

What is advantage data architect?

0 Answers  

---

What is the purpose of a table?

0 Answers  

---

What is the purpose of using COLLATE in a query?

1 Answers  

---