Wht is Stuff in sql ser

2 Answers  

---

Can we perform backup restore operation on tempdb? : sql server database administration

0 Answers  

---

In which format does an image save in SQL Server database ?

0 Answers   MCN Solutions,

---

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  

---

Different Types of Functions ?

2 Answers   Satyam,

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

---

Does a full backup include transaction log?

0 Answers  

---

What is the architecture of ms sql reporting service?

0 Answers  

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

How to use subqueries in the from clause in ms sql server?

0 Answers  

---

Do you know what is rank function?

0 Answers  

---