var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Optimise my query?
I was once asked in an interview how do i Optimise my query?
Whats should be main points for it??
Stored Procedure Optimization techniques?
And also if u could add the different Stored Procedure Optimization techniques?
Re: Optimise my query?
use DBBCC (3604,302,310) ,
verify join order and index selection
verify if leading column is there in composite index if it is used,
make sure statistics are up-to-date
for stored proc question check out this thread