what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

0 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

Tell me what is difference between clustered and non clustered index?

0 Answers  

---

What is the difference between local table and global table

1 Answers   CarrizalSoft Technologies, Polaris,

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

0 Answers  

---

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  

---

What are the new security features added in sql server 2012? : sql server security

0 Answers  

---

Can you explain different types of joins?

0 Answers  

---

What is the order in which the sql query is executed?

0 Answers  

---

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

---

Explain sub-query?

0 Answers  

---