Answer Posted / sreejith s t

LIKE operator performs pattern matching

Can you tell me some of the common replication dmv's and their use? : sql server replication

879

---

What part does database design plays a role in performance of an sql server-based application?

939

---

What is the purpose of data source?

967

---

Explain what is meant by replication of database?

969

---

What is de-normalization and what are some of the examples of it?

935

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1091

---

What is 2nf example?

952

---

What is the purpose of update statistics and scope_identity() function?

1056

---

what's the maximum size of a row? : Sql server database administration

1026

---

How to declare a cursor with "declare ... Cursor" in ms sql server?

988

---

which table keeps the locking information? : Sql server administration

1021

---

Does the order of columns in update statements matter?

865

---

what's sql server? : Sql server database administration

938

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1039

---

What are the different types of collation sensitivity in sql server?

1046

---