Answer Posted / deepak rohilla

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

How can sql server instances be hidden?

943

---

Does partitioning improve performance sql server?

971

---

What are the different type of replication in sql server?

974

---

How to count groups returned with the group by clause in ms sql server?

1054

---

What is merge join?

1191

---

How do I get to sql server configuration manager?

1001

---

What do you understand by mirroring and mention the advantages of the mirroring?

1057

---

Explain what is scheduled job and how to create it?

947

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

954

---

How to check table values in sql server?

951

---

How many databases instances are there in sql server 2000?

1091

---

What are the main differences between #temp tables and @table variables and which one is preferred?

1074

---

What will be the maximum number of indexes per table?

950

---

Explain differentiate between a having clause and a where clause?

903

---

How many types of cursor type are there?

1080

---