What is Files and Filegroups in SQL Server & it's implementation.

1 Answers   Zenith,

---

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---

Difference between writing SQL query and stored procedure ?

15 Answers   Cognizant, Infosys, TCS, Veritas,

---

What will happen when a Rollback statement is executed inside a trigger?

1 Answers   Flextronics, Hexaware,

---

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 Answers  

---

What is a file group?

0 Answers  

---

explain query execution plan

1 Answers  

---

Can we add a cpu to sql server?

0 Answers  

---

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

0 Answers   IBM,

---

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

0 Answers  

---

what is the disadvantage of SQL Loder?

1 Answers   TCS,

---

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  

---