What is master database? : SQL Server Architecture

0 Answers  

---

What are indexes? When do you need to create Indexes?

4 Answers   CarrizalSoft Technologies, HP,

---

What is meant by Active-Passive and Active-Active clustering setup?

0 Answers  

---

Explain features and concepts of analysis services?

0 Answers  

---

Why use stored procedures in sql server?

0 Answers  

---

Explain nested trigger in sql?

0 Answers  

---

What are the common performance issues in sql server?

0 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

what is the system function to get the current user's user id? : Sql server database administration

0 Answers  

---

What are sql dirty pages?

0 Answers  

---

Does union all remove duplicates?

0 Answers  

---

What is the difference between temp table and table variable?

8 Answers   Microsoft,

---