Answer Posted / vinod

its really working good

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.

2460

---

What is difference between Datepart() and Datename() in SqlServer?

709

---

What is difference between count (*) and count 1?

509

---

Explain filtered indexes?

545

---

How much space does sql server 2016 take?

565

---

---

What is merge join?

565

---

How to change the ownership of a schema in ms sql server?

548

---

what is a schema in sql server 2005? : Sql server database administration

508

---

What are the components of sql server service broker?

501

---

What is the difference between a view and a stored procedure?

544

---

We need to perform what steps in the following order to work with a cursor?

704

---

Explain Capacity planning to create a database? and how to monitor it?

3746

---

How to test a dml trigger in ms sql server?

568

---

What is unique key constraint?

626

---

What is the use of builtinadministrators group in sql server? : sql server security

525

---