Answer Posted / deepak rohilla

Timestamp is used typically as a mechanism for version-
stamping table rows.

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1213

---

Explain the types of indexes.

1216

---

What is the difference function and stored procedure?

1057

---

How to convert character strings into numeric values?

1096

---

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1198

---

Why do we use trigger?

972

---

What are the benefits of filtered indexes?

1040

---

What is sql or structured query language?

1150

---

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

940

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

990

---

What is meant by Active-Passive and Active-Active clustering setup?

1176

---

what is memory-optimized nonclustered indexes

1016

---

what's the difference between a primary key and a unique key? : Sql server database administration

951

---

How would you choose between a clustered and a non-clustered index?

975

---

What are the new security features added in sql server 2012? : sql server security

1023

---