Answer / Shripal

OLTP (Online Transaction Processing) systems are designed for handling multiple, short transactions with low latency. They often use clustered indexes and store data in a normalized form to optimize insert, update, and delete operations. OLAP (Online Analytical Processing) systems, on the other hand, focus on complex queries and analysis of large amounts of data. They typically use denormalized schema and materialized views to optimize query performance.

Can we use where clause in union?

1 Answers  

---

What is the maximum size of sql server database?

1 Answers  

---

write the query for taking database backup in sql

10 Answers   ABC, IBM, Logica CMG, MA,

---

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 Answers  

---

Explain sub-query?

1 Answers  

---

How to find the list of fixed hard drive and free space on server?

1 Answers  

---

What is service broker? : sql server database administration

1 Answers  

---

What is the recovery model?

1 Answers  

---

What is the security principal at the database level that represents your session?

1 Answers  

---

Accidentally i deleted my table. How can i get that table?

4 Answers  

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

1 Answers  

---

What is difference between after and before?

1 Answers  

---