Explain the dirty pages?

0 Answers  

---

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

---

what's the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

---

Write a code to select distinct records without using the DISTINCT keyword.

0 Answers   Aspiring Minds,

---

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.

0 Answers  

---

Can we drop user if user mapped to any logins

1 Answers  

---

What is merge replication?

0 Answers  

---

Tell me about Triggers?

3 Answers   Cap Gemini,

---

How to generate create table script on an existing table in ms sql server?

0 Answers  

---

What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,

---

What is the datatype returned by count(*)

22 Answers   247Customer, Asian CERC,

---

How do I make a resultset scrollable?

0 Answers  

---