Answer / guest

WE CAN EVALUATE THE QUERY PERFORMANCE BY RUNNING THE
EXECUTION PLAN OF THE QUERY.IF THE QUERY NEEDS ITS
PERFORMANCE TO BE OPTIMISED THEN WE WILL BE CREATE A VIEW
FOR THE TABLE USING 'WITH SCHEMA BINDING ' OPTION ,THEN
SUBSEQUENTLY CREATE A MATERIALISED VIEW USING INDEX
DEFINITION.FINALLY CHECK FOR THE EXECUTION PLAN (THAT
PREVENTS THE EXPENSE OF I/O READS).

Explain the usage of floor function in sql server.

0 Answers  

---

Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

1 Answers   Covansys,

---

How to make a remote connection in a database?

0 Answers  

---

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

---

How to Handle the exceptions in Sqlsrver 2005??

3 Answers   Value Labs, Wipro,

---

Explain atomicity?

0 Answers  

---

How do I shrink an ldf file?

0 Answers  

---

How does using a separate hard drive for several database objects improves performance right away?

0 Answers  

---

What is user-defined multi-statement table-valued function?

0 Answers  

---

How to provide default values to stored procedure parameters?

0 Answers  

---

How to execute a sql statement using mssql_query()?

0 Answers  

---

What is Index ? Explain its Types?

2 Answers   ADP,

---