What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,

---

Can two tables share the same primary key?

0 Answers  

---

Can sql servers link to other servers like oracle?

0 Answers  

---

How to download and install sql server 2005 books online?

0 Answers  

---

What is the difference between Drop and Truncate

20 Answers   GT Nexus, IBM,

---

What is the difference between deallocate cursor and close cursor?

0 Answers  

---

Do you know what is bit data type and whats the information that can be stored inside a bit column?

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  

---

Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

1 Answers   Covansys,

---

How can you check the level of fragmentation on a table?

0 Answers  

---

How many types of Joins in SQL Server 2005?

9 Answers   CarrizalSoft Technologies, HCL,

---

Explain what are page splits? : SQL Server Architecture

0 Answers  

---