Answer / Ajit Kumar Pandey

SQL Server 2000 introduced several new features like Service Broker, XML support, Analysis Services, Integration Services (SSIS), Full-Text Search, and ActiveX Data Objects (ADO) for .NET. Compared to SQL Server 7.0, it also featured improved performance, increased storage capacity, better scalability, and enhanced security.

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1 Answers  

---

Explain the ways to controlling cursor behavior?

1 Answers  

---

what is a deadlock? : Sql server database administration

1 Answers  

---

What is sql server transaction log file?

1 Answers  

---

Explain about link server in sql server?

1 Answers  

---

What is bit data type?

1 Answers  

---

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,

---

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,

---

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.

1 Answers  

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

1 Answers  

---

Define self join?

1 Answers  

---

How can we remove orphan records from a table?

1 Answers  

---