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).

What are sparse columns?

0 Answers  

---

What is NOT NULL Constraint in sql server 2012?

0 Answers   CDC,

---

which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help

3 Answers  

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

0 Answers   HPCL, Hughes Systique Corporation,

---

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  

---

Where sql server user names and passwords are stored in sql server? : sql server database administration

0 Answers  

---

What is transaction server auto commit?

0 Answers  

---

What is set nocount on and what is set nocount off?

0 Answers  

---

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

---

What stored by the master? : sql server database administration

0 Answers  

---

What is the boxing and unboxing concept in .net?

0 Answers  

---

How to reaname table name without using sp_Rename in sql server..?

0 Answers   Wipro,

---