Answer Posted / sd

Adding to what POO said

Automicity : Group of T-SQL stmts act in a batch .

Consistency : All or none concept.

Isolation: Visibility of resources used in one transaction
to concurrent transactions
Durability : Once changes are commited to database they are
permanent .

Define primary key?

1079

---

How to view existing indexes on an given table using sp_help?

1056

---

Explain full-text query in sql server?

953

---

What is normalization and what are the advantages of it?

924

---

Why do we need different type of parameter?

999

---

What is the impact on other user sessions when creating indexes?

876

---

What do we need queues in sql service broker?

1005

---

How to list all tables in the database using odbc_tables()?

983

---

What is instead of dml trigger?

953

---

List out a number of the wants to setup a SQL Server failover cluster?

1010

---

How to enter unicode character string literals in ms sql server?

1019

---

Define right outer join in sql server joins?

983

---

Tell me about the approaches which you used to counter the DI problems.

1269

---

What is parameterized reports in ssrs ?

141

---

what is blocking? : Sql server database administration

983

---