What is 4nf in normalization form?

0 Answers  

---

How can you tell if a database object is invalid?

0 Answers   MCN Solutions,

---

What is the use of DBCC commands?

4 Answers   NA,

---

What is data source view or dsv? : sql server analysis services, ssas

0 Answers  

---

What is difference between process and thread? Explain lazy writer funcationality.

2 Answers   Microsoft,

---

Can we join two tables without primary key?

0 Answers  

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

0 Answers  

---

How can a user-defined datatype be created?

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,

---

How many types of objects are there?

0 Answers  

---

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

0 Answers   MCN Solutions,

---

What is the user of Primary key?

0 Answers  

---