Answer Posted / rajiv rohilla

In Access We USE 'Select Date()'
In Sql server 2000 'Select getdate()'
In Oracle 'Select SysDate() from dual'

What is sql server schema compare? How we can compare two database schemas?

1018

---

Name the different type of indexes in sql?

950

---

Mention the differences between sql server and mysql.

1005

---

What is data source view or dsv? : sql server analysis services, ssas

995

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2921

---

What are data resources?

901

---

What is data block and how to define data block size?

1016

---

What are out-of-range errors with date and time literals?

1024

---

Explain the difference between HTTP and HTTPS in database?

1022

---

What are basics of policy management?

1090

---

How many types of the database links?

1062

---

What is the difference between seek predicate and predicate?

1047

---

Does sql server use t sql?

1008

---

What are the steps to take to improve performance of a poor performing query? : sql server database administration

1027

---

What is the use of commit?

992

---