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

How to query multiple tables jointly?

0 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

What are the differences between triggers and stored procedures?

0 Answers  

---

Explain logical operators in sql server?

0 Answers  

---

Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

1 Answers  

---

What is the difference between count () and rowcount ()?

0 Answers  

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

0 Answers  

---

What are the limitation of the Online Index Rebuild Operation?

1 Answers  

---

Explain the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 Answers  

---

What are the different types of backups that exist?

0 Answers   ADITI,

---

how to select a field with firstletter as capital and remaining are small letters

11 Answers  

---