Answer / Sapna

The Query Optimizer in SQL Server is a component that determines the most efficient execution plan for a given SQL query. It considers various factors, such as indexes, statistics, and join orders, to create an optimal plan.

What is side by side migration in sql server?

1 Answers  

---

What is the largest component inside a field?

1 Answers  

---

What is trigger in salesforce?

1 Answers  

---

What is transact-sql ddl trigger?

1 Answers  

---

what is Constraint? How many types of constraints in SQL ?

38 Answers   HCL, IBM, NIIT, Wipro,

---

What xml support does the sql server extend?

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,

---

What is the system function to get the current user's user id?

3 Answers   TCS,

---

How are the exceptions handled in sql server programming?

1 Answers  

---

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

---

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

1 Answers  

---