Explain indexed views?

0 Answers  

---

What will you do If the low Performance occurs?

2 Answers  

---

What are the various editions of sql server 2017 that are available in the market?

0 Answers  

---

What is a scheduled job or what is a scheduled task?

0 Answers  

---

Explain primary key, foreign key and unique key?

0 Answers  

---

---

what is difference between view and Dip.

0 Answers   IBM, L&T,

---

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

0 Answers   Accenture,

---

Does sql server use t sql?

0 Answers  

---

How can you see what type of locks used?

1 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,

---

How can I check that whether automatic statistic update is enabled or not?

0 Answers  

---

What are the different index configurations a table can have?

0 Answers  

---