Answer Posted / hari

Transcation is a sequene of operations performaed a single
logical unit of work .it must be excuted acid properties.
Atomicity : set of t-sql statements act as a batch
constitancy : ---
isolation : to reduce the concurrency
durabality : once chages are commied database permentaly
saved

What is auditing in sql server?

928

---

What is merge?

1020

---

how you can configure a running aggregate in SSRS?

190

---

Which are new data types introduced in sql server 2008?

1050

---

Explain different types of locks in sql server.

1080

---

What is trace flag in sql server?

1026

---

How is sql used in sql server?

1011

---

Can we deploy SSRS reports on our personal website?

168

---

How optimize sql query with multiple joins in sql server?

905

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

965

---

Explain what are magic tables in sql server?

998

---

How do you make a trace?

1025

---

Where are stored procedures in sql server?

1066

---

Describe in brief sql server monitoring ways.

1052

---

How are the exceptions handled in sql server programming?

1065

---