How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

10 Answers   Cognizant, Infosys,

---

what are the advanced features in sql 2008?

2 Answers   Wipro,

---

What are the results of running this script?

0 Answers  

---

How to Rebuild Master database in sql server 2005.

2 Answers   Wipro,

---

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

4 Answers   CarrizalSoft Technologies, L&T,

---

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers   Satyam,

---

how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.

1 Answers  

---

Where are full-text indexes stored?

0 Answers  

---

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  

---

What is Data model and how to prepare a data model.?

1 Answers   TCS,

---

Explain how to maintain a fill factor in existing indexes?

0 Answers  

---