How to make remote connection in database?

0 Answers  

---

What are the differences between left join and inner join in sql server?

0 Answers  

---

What is difference between oltp and olap?

0 Answers  

---

How to generate create view script on an existing view?

0 Answers  

---

What is query optimization process?

0 Answers  

---

How to verify a user name with sqlcmd tool?

0 Answers  

---

What is a derived table?

0 Answers  

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

What different steps will a sql server developer take to secure sql server?

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  

---

How to download and install sql server 2005 books online?

0 Answers  

---

How do I clean up sql server transaction log?

0 Answers  

---