How can we remove orphan records from a table?

0 Answers  

---

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

0 Answers  

---

What is mscorsvw.exe - process - microsoft .net framework ngen?

0 Answers  

---

When we can say that is in BCNF?

3 Answers   BitWise,

---

What is forward - only cursors / read only cursor?

0 Answers  

---

---

What is a trigger? Why we need it?

0 Answers   Accenture,

---

Explain following error properties?

0 Answers  

---

Indexes are updated automatically is the full-text index also updated automatically?

0 Answers  

---

What are types of scd? : sql server analysis services, ssas

0 Answers  

---

Does table partitioning improve performance?

0 Answers  

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---

How to select an exiting database using mssql_select_db()?

0 Answers  

---