Answer / Jabir Husain

Lock escalation in SQL Server refers to a process where a single transaction that requires numerous individual locks eventually gets upgraded to a higher-level lock, such as a table lock. This can cause contention and performance issues due to the increased blocking of resources.

what is memory-optimized nonclustered indexes

1 Answers  

---

What is the difference between mysql and sql server?

1 Answers  

---

How is sql server used?

1 Answers  

---

Do you have any idea about the tcl commands?

1 Answers  

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1 Answers  

---

what is the difference between group and having give an example with query and sample output

7 Answers  

---

What is the difference between index seek vs. Index scan?

1 Answers  

---

Name the different type of indexes in sql?

1 Answers  

---

What do I need to start working with sql studio? : sql server management studio

1 Answers  

---

How can you insert null values in a column while inserting the data?

1 Answers  

---

What is a primary index?

1 Answers  

---

1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers   Perot Systems,

---