Viewing 15 posts - 91 through 105 (of 283 total)
free_mascot (4/16/2014)
yuvipoy (4/16/2014)
What will happen when the server is restarted will index be recreated?NO. There is no relation between server restart and index.
where does these index will resides if we...
April 16, 2014 at 3:16 am
What will happen when the server is restarted will index be recreated?
April 16, 2014 at 1:37 am
Will it improve my query performance?
Say where condition is index column which is "SORT_IN_TEMPDB" option
April 16, 2014 at 12:35 am
no want to know how Tempdb is used and usage
April 16, 2014 at 12:25 am
Your question iss not clear.
Can you give samples with statements?
April 15, 2014 at 11:48 pm
ChrisM@Work (4/15/2014)
95% of the cost of the query is a key lookup of table2. The query uses index IDX_SE_CD_MEAS_FK to seek matches on column TCOL1. Since the output requires a...
April 15, 2014 at 11:25 pm
Sure will follow ANSI 92 standard and thanks for the suggestion.
How about the execution plan
April 14, 2014 at 10:29 pm
FROM
--TABLE1 M (NOLOCK), -- Use of NOLOCK is HIGHLY Suspect and can provide erronous data
--TABLE2 OM (NOLOCK) -- including missing and/or duplicated...
April 14, 2014 at 8:42 am
Estimated cost operation is 95% on a single statement in the overall execution plan.
April 14, 2014 at 6:43 am
Gail Really thanks for your patient ,but i am able to load here in my SSMS 2008
April 14, 2014 at 4:24 am
Here we go.. Run the query with ctrl+m(Include Actual Execution Plan)
April 14, 2014 at 4:12 am
attached latest query execution plan
Hope this will help me finally.
April 14, 2014 at 3:02 am
No it will run it will not return 0 rows
Table1 44 rows
Table2 500 rows
April 14, 2014 at 2:34 am
GilaMonster (4/14/2014)
So the query, when run in production, returns 0 rows?
Not everytime that is the problem.
Most of the time it is some millisecond but some time it is nearly 5...
April 14, 2014 at 2:20 am
Viewing 15 posts - 91 through 105 (of 283 total)