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 security principal at the server level that represents your session?

0 Answers  

---

Is it important for a database administrator to understand the operating system and file access?

0 Answers  

---

Can we move Resource database from one path to another? If yes,How can we?

1 Answers   Wipro,

---

How can we call UDF(User Define Function) using C# code in ASP.net ?

1 Answers  

---

what is bit data type? and what are the information that can be stored inside a bit column?

2 Answers  

---

Can you explain the types of Joins that we can have with Sql Server?

2 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

How m-m relationships are implemented?

2 Answers  

---

What is an entity-relationship diagram (erd)?

0 Answers  

---

What is a rollup clause?

0 Answers  

---

How to create user defined functions with parameters?

0 Answers  

---

What is bit data type?

0 Answers  

---