What is tablesample?

0 Answers  

---

Who developed sql server?

0 Answers  

---

How to insert a new row into a table with "insert into" statements in ms sql server?

0 Answers  

---

Describe and explain about SQL native client?

0 Answers  

---

what information is maintained within the msdb database? : Sql server administration

0 Answers  

---

---

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.

0 Answers  

---

Differentiate between delete and truncate.

0 Answers  

---

What is difference between inner join and full join?

0 Answers  

---

Explain transaction server isolation?

0 Answers  

---

what is the maximum size of a row in sql server 2000 and 2005

2 Answers  

---

Which index created when Create Index on table(col), Why

2 Answers   CGI,

---

What is the difference between a stored procedure and a user defined function in sql server?

2 Answers   Millennium,

---