Will sql server 2005 allow you to reduce the size of a column?

0 Answers  

---

Does table partitioning improve performance?

0 Answers  

---

What are different types of schemas?

0 Answers  

---

Is mysql better than sql server?

0 Answers  

---

What type of locking occurs during the snapshot generation? : sql server replication

0 Answers  

---

What are binary string data types in ms sql server?

0 Answers  

---

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

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  

---

Where sql server usernames and passwords are stored in a sql server?

0 Answers  

---

What is the diff between Static Queries and Dynamic queries give me some examples

2 Answers   CSC,

---

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

---

How can you set the threshold at which sql server will generate keysets asynchronously?

0 Answers  

---