Answer / flora

The SQL Server query optimizer uses distribution statistics when creating a query plan. The statistics provide information about the distribution of column values across participating rows, helping the optimizer better estimate the number of rows, or cardinality, of the query results

Differentiate between sql temp table vs table variable?

0 Answers  

---

Do you know what is sql injection?

0 Answers  

---

Can we add our custom code in ssis?

0 Answers  

---

what is a join? : Sql server database administration

0 Answers  

---

How do you use a subquery to find records that exist in one table and do not exist in another?

0 Answers  

---

---

Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 Answers  

---

is it important for a database administrator to understand the operating system and file access? : Sql server administration

0 Answers  

---

Write a SQL command to insert and update only a particular field?

0 Answers   ADITI,

---

What is the difference between distinct clause and group by clause?

2 Answers   HHH, Value Labs,

---

What is multi-statement table-value user-defined function?

0 Answers  

---

Explain what is log shipping?

0 Answers  

---

How to connect ms access to sql servers through odbc?

0 Answers  

---