Answer Posted / rohti nanda

Three type of indexes in sql

1.Clustered
2.Non-clustered
3.Unique

What is sql server transaction log file?

991

---

Which tcp/ip port does the sql server run on? How can it be changed?

990

---

Tell me what is use of except clause? How it differs from not in clause?

898

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

941

---

what is the difference between openrowset and openquery?

1021

---

How do you manipulate data?

848

---

What is the purpose of a table?

905

---

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.

2879

---

What are the system database in sql server 2005?

982

---

How to send email from database?

945

---

How do you create a clustered index?

997

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

890

---

How to create nested stored procedure?

946

---

What is trigger explain with program?

928

---

Explain differences between web edition and business edition?

119

---