Forum Replies Created

Viewing 15 posts - 5,881 through 5,895 (of 7,616 total)

  • RE: Bad Query Plan

    My first choice would be to use RECOMPILE and just force SQL to rebuild a plan every time.

    But, if a HASH join is the "good" plan, forcing a HASH join...

    August 8, 2014 at 8:34 am

    #1736441

  • RE: Bad Query Plan

    Robert klimes (8/7/2014)

    Roger Sabin (8/7/2014)

    I tried what you suggest and it does force the "bad" plan when I use 40 and a "good" plan when I use 17. Thanks.

    So now...

    August 7, 2014 at 4:07 pm

    #1736230

  • RE: Index creation

    GilaMonster (8/7/2014)

    New Born DBA (8/7/2014)

    GilaMonster (8/7/2014)

    What does "Creating an index within the application" even mean?

    No Idea. I wanted to ask him the same thing

    Then do so.

    Seems to me it would...

    August 7, 2014 at 3:30 pm

    #1736222

  • RE: Index creation

    Unfortunately, you really can't accurately look at one index recommendation in isolation. You really have to consider indexes in toto, including a minimum of missing index and existing index...

    August 7, 2014 at 3:19 pm

    #1736216

  • RE: Different result for one query

    A longshot, but, in the interests of being thorough ...

    Are there possibly different "table1" tables under different schemas? Could one session be reading from a different schema.table1 than the...

    August 7, 2014 at 10:11 am

    #1736072

  • RE: simple division

    select 18 * 1.0/94

    August 7, 2014 at 10:08 am

    #1736066

  • RE: SELECT clause

    GilaMonster (8/7/2014)

    ScottPletcher (8/7/2014)

    Which is why I don't quite understand the "definitely not!" 🙂

    You may have missed the word before that phrase.

    "The average of those isn't 'definitely not'"

    Yep, sure did :blush:

    August 7, 2014 at 9:37 am

    #1736051

  • RE: INSERT Table into ITSELF???? WHY???

    Would it "ever not do that"?

    The INSERT could fail if it ran out of physical file space to hold the new rows.

    August 7, 2014 at 9:29 am

    #1736045

  • RE: SELECT clause

    ChrisM@Work (8/7/2014)

    ScottPletcher (8/7/2014)

    ChrisM@Work (8/7/2014)

    gstarsaini (8/7/2014)

    Thanks for the reply.

    This means there is no effect on the queries?

    Each reply posted to your question implies "maybe", "probably" or "definitely". The average of these...

    August 7, 2014 at 9:26 am

    #1736042

  • RE: SELECT clause

    ChrisM@Work (8/7/2014)

    gstarsaini (8/7/2014)

    Thanks for the reply.

    This means there is no effect on the queries?

    Each reply posted to your question implies "maybe", "probably" or "definitely". The average of these isn't "definitely...

    August 7, 2014 at 9:10 am

    #1736030

  • RE: SELECT clause

    gstarsaini (8/7/2014)

    Do multiple SELECT queries on the same table but different condition in WHERE clause block or affect each other in any way?

    They definitely could. The WHERE conditions determine...

    August 7, 2014 at 8:08 am

    #1735984

  • RE: Stupid Stored Procedure Question Nbr 1

    Bill Talada (8/6/2014)

    To be chosen as a deadlock victim, two threads must be inside transactions. If thread one updates tableA then tableB while thread two updates tableB then tableA...

    August 6, 2014 at 5:23 pm

    #1735815

  • RE: Difference In Query Plans while Executing Same Query Independently and Within Stored Proc

    For best performance overall, I strongly suspect you need to change the clustered indexes on the tables. We would have to look at least at missing index and index...

    August 6, 2014 at 5:09 pm

    #1735813

  • RE: Table size is Huge!!!

    LutzM (8/6/2014)

    Here are a few options to make that single table "smaller":

    If the table contains a rather large number of columns (e.g. 50 or more) you might consider "vertical partitioning",...

    August 6, 2014 at 5:00 pm

    #1735809

  • RE: Remotely called job returns success even if it's not finished

    Basically, I want to wait for the job to complete and then send either a success or failure email based on the outcome of the job.

    Again, I urge you to...

    August 5, 2014 at 9:45 am

    #1735289

Viewing 15 posts - 5,881 through 5,895 (of 7,616 total)