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

What are binary string data types in ms sql server?

0 Answers  

---

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  

---

How many full-text indexes can a table have?

0 Answers  

---

How to make a column nullable?

0 Answers  

---

Explain what is the purpose of sql profiler in sql server?

0 Answers  

---

---

Introduction of rollup clause using sum and group by clause?

0 Answers  

---

What is a heap?

0 Answers  

---

What is difference between index and primary key?

0 Answers  

---

What are views in ms sql server?

0 Answers  

---

What is #table in sql server?

0 Answers  

---

What is the order in which the sql query is executed?

0 Answers  

---

What is constraints and its types?

0 Answers  

---