Answer Posted / pulak

select add_months(trunc(sysdate,'year'),12)-trunc(sysdate,'year') as days from dual;

How to find related tables in sql server?

871

---

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.

2879

---

What is difference between group by and having?

908

---

How to modify the underlying query of an existing view?

931

---

What is msdb database? : SQL Server Architecture

1059

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1014

---

What are the differences between substr and charindex in sql server.

1013

---

What is the difference between deallocate cursor and close cursor?

1166

---

How to grant a permission in ms sql server using "grant execute" statements?

1025

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

892

---

How to locate and take substrings with charindex() and substring() functions?

943

---

What is partitioned view?

853

---

What is difference between clustered index and non clustered index?

1027

---

what is the sql equivaent of the dataset relation object ?

1960

---

Do you know how to implement service broker?

885

---