Viewing 15 posts - 41,911 through 41,925 (of 49,571 total)
Lynn Pettis (1/7/2009)
hmmm, a question I sense here but not sure what you want.
Are you channelling Yoda again?
January 7, 2009 at 1:32 pm
IF EXISTS (SELECT 1 FROM SomeTable WHERE SomeKey = @SomeValue)
UPDATE ...
ELSE
INSERT ...
Edit: The question was (paraphrased)
If I have a table and I want to check based on a...
January 7, 2009 at 1:31 pm
RBarryYoung (12/31/2008)
[h2]If your data is important to you then Back It Up![/h2]
And to add to that.
Any backup not tested cannot be considered a valid backup. If it's worth backing...
January 7, 2009 at 12:58 pm
Steve Jones - Editor (1/7/2009)
January 7, 2009 at 9:12 am
Christopher Stobbs (1/7/2009)
Hi Gail,After the first seek is done are the other filters done on the index or resultant dataset return from the first filter(Index seek)
The latter.
The index seek results...
January 7, 2009 at 8:57 am
Since all of the filters are inequalities, SQL can only seek on one of them. The other two have to be applied as a second step after the index seek....
January 7, 2009 at 8:38 am
winston Smith (1/7/2009)
which is better and why?create index index1 on table1 (col1, col2, col3)
or create index on table1 (col1)
include(col2, col3)
Depends what you're trying to accomplish
The first fully covers and...
January 7, 2009 at 8:14 am
Use Statistics IO and Statistics Time when you're investigating the procs themselves, along with the exec plan, to see where the problem points are.
January 7, 2009 at 8:09 am
gharris_35 (1/7/2009)
HiI have uploaded the estimated plan. See Estimated Plan.zip
Did you check that before you posted? 😉
Management studio saves plans one at a time, so all that's attached is...
January 7, 2009 at 7:22 am
Grant Fritchey (1/7/2009)
Too much information in the Estimated execution plan? I don't understand.
I'm guessing too many plans.
January 7, 2009 at 7:16 am
Is there a trigger on the table?
Maybe it's just a phrasing issue, but an update statement is not going to insert anything into the database. It's going to modify an...
January 7, 2009 at 6:34 am
Run profiler and capture the SP_Completed event. That will get you the stats for every proc run.
You could run the proc with the execution plan on and see which queries...
January 7, 2009 at 6:33 am
It's created by the optimiser when running queries so that it can get info about the distribution of data in the column, to get a better execution plan.
See this post...
January 7, 2009 at 6:24 am
venkatg86 (1/7/2009)
Can i know the Exact cause of this Error. so, i may aware of this and not repeat the same error in future
No idea. The message you posted doesn't...
January 7, 2009 at 6:20 am
SQL 2005 caches the structure of frequently used temp tables. It's an optimisation to reduce the impact of frequently creating and dropping the same table. That may be what you're...
January 7, 2009 at 5:39 am
Viewing 15 posts - 41,911 through 41,925 (of 49,571 total)