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.

After the SQL installation what are the jobs will you configure?

1 Answers   G7 CR Technologies, IBM, Satyam,

---

What is the exact numeric data type in sql?

0 Answers  

---

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 Answers  

---

What are SSL and TSL protocols?

0 Answers   Wipro,

---

how can do you the system monitoring?

1 Answers  

---

---

What are the different subsets of sql?

0 Answers  

---

How does normalization work?

0 Answers  

---

What is sub-query in sql server? Explain its properties.

0 Answers  

---

What stored procedure would you use to view lock information?

0 Answers  

---

What is raiseerror? What is raiseerror?

0 Answers  

---

What is a transaction and what are ACID properties?

3 Answers  

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

0 Answers  

---