Answer Posted / udhaya

Shared (S) Used for operations that do not change or update
data (read-only operations), such as a SELECT statement.
Update (U) Used on resources that can be updated. Prevents
a common form of deadlock that occurs when multiple
sessions are reading, locking, and potentially updating
resources later.
Exclusive (X) Used for data-modification operations, such
as INSERT, UPDATE, or DELETE. Ensures that multiple updates
cannot be made to the same resource at the same time.
Intent Used to establish a lock hierarchy. The types of
intent locks are: intent shared (IS), intent exclusive
(IX), and shared with intent exclusive (SIX).
Schema Used when an operation dependent on the schema of a
table is executing. The types of schema locks are: schema
modification (Sch-M) and schema stability (Sch-S).
Bulk Update (BU) Used when bulk-copying data into a table
and the TABLOCK hint is specified

What is the purpose of optimization?

953

---

Explain what are various ways to enhance the ssrs report?

992

---

Is a primary key unique?

941

---

What is bcp? When does it use?

874

---

Does transparent data encryption provide encryption when transmitting data across the network?

984

---

Explain different types of index?

988

---

What is mean by dml?

945

---

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2018

---

What is a subquery in a select query statement in ms sql server?

1069

---

What is the difference between a function and a stored procedure?

1006

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1000

---

What is row_number () and partition by in sql server?

1007

---

Can you always create a cache of a report?

156

---

What are sub reports and how to create them?

124

---

What is raid and what are different types of raid levels?

1078

---