Answer Posted / maheswar reddy s

select * from Employee e1 where 6=(select count(distinct(salary))from employee e2 where
e2.salary>=e1.salary)

Tell me the difference between clustered and non-clustered index?

920

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1123

---

Explain cursor as data base object?

1015

---

What is lock escalation? : sql server database administration

1141

---

how to use DTS package in 2000,2005,2008 in sql server

1816

---

What is db stored procedure?

854

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1058

---

What is a cursor, index in sql?

1049

---

What is the maximum size of a dimension? : sql server analysis services, ssas

1023

---

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1730

---

Explain time data type in sal server 2008?

907

---

What are the differences between user defined functions and stored procedures?

1046

---

What is difference between views and tables?

981

---

What is the difference between varchar and nvarchar?

925

---

explain databases and sql server databases architecture? : Sql server database administration

936

---