Answer Posted / kumar

Transaction is logical unit of work. It will be done all
the things must otherwise none.
It Should be Satisfy ACID Property.
A - Acit
C - Consistency
I - Isolation
D - Durability.

By
Kumar T

Explain how you can deploy an SSRS report?

150

---

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?

1326

---

Where actually sql azure database is hosted?

163

---

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1092

---

What are the differences between user defined functions and stored procedures?

1074

---

How do I find the default sql server instance?

944

---

Will count(column) include columns with null values in its count?

1094

---

What is the fastest way to permanently delete a 1 million row table named customers?

1255

---

What is precedence constraint?

983

---

Can sql servers linked to other servers like oracle?

953

---

When would you prefer to have a minimum number of indexes?

911

---

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

1020

---

Is a primary key unique?

992

---

What are subquery and its properties?

1049

---

How do I start sql server 2016?

910

---