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 about local stored procedure?

0 Answers  

---

what information is maintained within the msdb database? : Sql server administration

0 Answers  

---

What is Pointer ?

3 Answers   Cap Gemini, CarrizalSoft Technologies,

---

Explain the microsoft sql server delete command?

0 Answers  

---

What are distributed partitioned views?

0 Answers  

---

I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,

2 Answers  

---

How do I view views in sql server?

0 Answers  

---

Do you know what are the ways available in sql server to execute sql statements?

0 Answers  

---

What is usually the first word in a sql query?

0 Answers  

---

What is the Main Difference between ACCESS and SQL SERVER?

0 Answers   MindCracker,

---

How will u test the stroded procedures and functions? difference between SP and Triggers

2 Answers   TCS,

---

What is use of except clause? How does it differ from not in clause?

0 Answers  

---