Answer / Bijay Kumar

The UPDATE STATISTICS command in SQL Server is used to maintain the statistical information about data distribution in a table or index. This helps improve the performance of queries by providing better optimization.

What is Check point? Explain in Brief what it will do?

1 Answers   Wipro,

---

How extra digits are handled with numeric data type literals?

1 Answers  

---

1 01 101 01010

1 Answers  

---

What is the default fill factor value?

1 Answers  

---

What is the use of @@spid?

1 Answers  

---

How many types of Cursor in SQL SERVER?

1 Answers  

---

State a few properties of relational databases?

1 Answers  

---

How can we rewrite sub-queries into simple select statements or with joins?

1 Answers  

---

Can you create a logon trigger in sql server 2005 express edition?

1 Answers  

---

can you any body tell me suppose database is suspect mode. how can take to normal?

2 Answers   Teledata,

---

Explain optimistic and pessimistic concurrency?

1 Answers  

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---