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

Do you know what are acid properties of transaction?

0 Answers  

---

Why we need a group by clause?

4 Answers  

---

What is the usage of sign function?

0 Answers  

---

Why do we use stored procedures in sql server?

0 Answers  

---

What is “asynchronous” communication in sql server service broker?

0 Answers  

---

---

What are the different ways you can create databases in sql server?

0 Answers  

---

What are distributed partitioned views?

0 Answers  

---

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

0 Answers  

---

What action plan is preferred if sql server is not responding?

0 Answers  

---

How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 Answers  

---

Write a SQL Query to find first Week Day of month?

2 Answers  

---

What is Primary key and foreign key? Give an example

4 Answers   TCS,

---