Answer / Garib Nath Yadav

The optimal disk configuration for a database server depends on various factors like I/O requirements, read/write ratio, and storage capacity. A common setup includes using RAID 10 (also known as RAID 1+0) or RAID 5 for the data disks to provide both redundancy and performance. For the log files, a dedicated RAID 1 mirror is recommended for improved durability. If budget is not a constraint, consider using SSDs (Solid State Drives) for faster read/write speeds and RAID 6 or RAID 50 for higher storage capacity with redundancy.

How to handle error or exception in sql?

1 Answers  

---

How to create a ddl trigger using "create trigger" statements?

1 Answers  

---

What is for xml in sql server?

1 Answers  

---

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

6 Answers   Broadridge,

---

What all db objects can be found in MSDB database of a SQL Server instance?

2 Answers   Accenture,

---

Explain left outer join and right outer join?

1 Answers  

---

What is WITH CHECK OPTION

3 Answers   Karur Vysya Bank KVB,

---

What is meant by indexing files?

1 Answers  

---

How to include text values in sql statements?

1 Answers  

---

Can a function call a stored procedure in sql server?

1 Answers  

---

What are the properties of the transactions?

1 Answers  

---

what is differece between union and union all

6 Answers  

---