Answer / sam

statistics in SQL Server refers specifically to information
that the server collects about the distribution of data in
columns and indexes. This data in turn is used by the query
optimizer to determine the plan of attack for returning
results when you run a query. While in the majority of
cases SQL Server takes care of this statistical
recordkeeping for you automatically, it's useful to have
some understanding of what's going on, and to know when you
might need to intervene.

What is the use of stored procedure?

0 Answers  

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

0 Answers  

---

What is the difference between TRUNCATE and DROP?

0 Answers  

---

What is sql server transaction log file?

0 Answers  

---

Is sql server 2016 free?

0 Answers  

---

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

---

Explain transaction isolation levels in sql server?

0 Answers  

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

---

Please illustrate physical database architecture? : SQL Server Architecture

0 Answers  

---

What is the use of CASCADE CONSTRAINTS?

3 Answers  

---

can any one please send sql quries most used in applications.

2 Answers  

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

---