Answer Posted / sathish

The 10 tables can be joined as,

select table1.columnname,table2.columnname,.....
from table1,table2,.......

It displays 10 fields from 10 different tables.

What is analysis service repository?

968

---

What does null mean?

937

---

Does table partitioning improve performance?

902

---

What is dirty read?

1041

---

What is difference between delete and truncate commands?

995

---

How do you create a data source?

864

---

Does sql server 2016 have ssms?

911

---

Give an example of SQL injection attack ?

928

---

How do indexes help, types?

909

---

What is correlated subquery in sql server?

1016

---

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

---

Introduction of rollup clause using sum and group by clause?

899

---

Can an automatic recovery be initiated by a user?

941

---

What is the difference between drop table and truncate table?

873

---

What is molap and its advantage? : sql server analysis services, ssas

929

---