Answer Posted / elumalai.k

select salary from employee aa
where 4=(select count(*)from employee bb
where aa.salary<=bb.salary)

When you should use a low fill factor?

957

---

Explain an incremental backup?

953

---

What is the maximum rows in sql server table?

877

---

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1006

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1016

---

How to use copy and concatenate commands in SQL?

1088

---

How many levels of sp nesting are possible?

977

---

what is database replicaion? : Sql server database administration

1130

---

What is an indice?

1002

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

971

---

Mention the command used to rename the database.

967

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2898

---

What is the difference between push and pull subscription? : sql server replication

1175

---

What is a collation?

1055

---

How to get the definition of a user defined function back?

1017

---