Answer / sumit

An execution plan is basically a road map that graphically
or textually shows the data retrieval methods chosen by the
SQL Server query optimizer for a stored procedure or ad-hoc
query and is a very useful tool for a developer to
understand the performance characteristics of a query or
stored procedure since the plan is the one that SQL Server
will place in its cache and use to execute the stored
procedure or query. From within Query Analyzer is an option
called "Show Execution Plan" (located on the Query drop-
down menu). If this option is turned on it will display
query execution plan in separate window when query is ran
again.

Explain the dbcc pintable command when would you use it?

0 Answers  

---

what is the importence of the trigger in sqlserver2000?

1 Answers   ATI,

---

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  

---

Introduction of rollup clause using sum and group by clause?

0 Answers  

---

How do you know which index a table is using?

4 Answers  

---

What are different types of raid levels?

0 Answers  

---

Does sql server 2016 have ssms?

0 Answers  

---

What is Inner Join?

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  

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

0 Answers   HCL,

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

0 Answers  

---

After removing a table from database, what other related objects have to be dropped explicitly?

0 Answers  

---