What is a join in sql? What are the types of joins?

0 Answers  

---

How can sql server instances be hidden? : sql server security

0 Answers  

---

Define left outer join in sql server joins?

0 Answers  

---

What is named calculation? : sql server analysis services, ssas

0 Answers  

---

Explain the different types of joins?

0 Answers  

---

What is mean by "fill factor" ? and what is mean by "Index "in sql?

1 Answers   iGate, Logica CMG,

---

What is the recovery model?

0 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

What is the difference between rank and dense_rank?

0 Answers  

---

Can you please differentiate between a primary key and a unique key?

0 Answers  

---

What is the difference between local table and global table

1 Answers   CarrizalSoft Technologies, Polaris,

---

How to view existing indexes on an given table using sys.indexes?

0 Answers  

---