Forum Replies Created

Viewing 15 posts - 1,171 through 1,185 (of 1,240 total)

  • RE: Stored Proc And View Giving Different Results

    GilaMonster (2/3/2014)


    BWFC (2/3/2014)


    I'm personally surprised not one of the auditors has said something like 'about these nolocks...'

    No, they won't. Most aren't technical and won't have any idea of the implications....

  • RE: Stored Proc And View Giving Different Results

    GilaMonster (2/3/2014)


    BWFC (2/3/2014)


    I don't think we have much in the way of blocking problems, although it's not something that would necessarily come to my attention if we did.

    If you have...

  • RE: Stored Proc And View Giving Different Results

    I don't think we have much in the way of blocking problems, although it's not something that would necessarily come to my attention if we did. My boss or...

  • RE: Stored Proc And View Giving Different Results

    Jeffrey Williams 3188 (1/31/2014)


    Remove the Distinct in the view definition - that is going to eliminate rows from the grouping that are actually included in the procedure.

    The distinct will only...

  • RE: Stored Proc And View Giving Different Results

    ChrisM@Work (1/31/2014)


    That's okay, it was always going to be a long shot with no sample data blah blah.

    I hope you can take away a few ideas from it though,...

  • RE: Stored Proc And View Giving Different Results

    ChrisM@Work (1/31/2014)


    You might get some performance lift by jigging around with your filters. If you're going down this route then do take on board Gail's comments about DISTINCT. You might...

  • RE: Today's Random Word!

    Ed Wagner (1/31/2014)


    Jeff Moden (1/30/2014)


    Ed Wagner (1/30/2014)


    Luis Cazares (1/30/2014)


    Jeff Moden (1/30/2014)


    "JOCC BOOSTR" (pronounced "jock booster")

    Definition:

    Justification Of Crap Code Based Only On Small Table Requirements

    🙂

    Everywhere

    Pervasive

    Infectious

    Pandamic

    Endemic

  • RE: Stored Proc And View Giving Different Results

    No, I mean the difference in row counts between the procedure and view, the problem that we're trying to solve.

    Of course you did, sorry, conference call brain fry.

    There is no...

  • RE: Stored Proc And View Giving Different Results

    GilaMonster (1/31/2014)


    Can't see anything obvious (other than multiple unnecessary DISTINCTs)

    Is the difference in rowcount consistent?

    If you mean 'is the difference in ServiceDays and AverageServiceDays the same every time' then yes....

  • RE: Stored Proc And View Giving Different Results

    Fair enough, although I'm a little hurt you don't trust me.... 🙂

    The code to create the dashboard with the proc

    set transaction isolation level read uncommitted

    set dateformat ymd

    select distinct

    OrderType =

    case...

  • RE: Stored Proc And View Giving Different Results

    I've attached the code now. I've had to do a bit of obfuscation, which I hope doesn't hide the logic. The organisation I work for is quite high...

  • RE: Today's Random Word!

    Kurt W. Zimmerman (1/28/2014)


    Ed Wagner (1/28/2014)


    L' Eomot Inversé (1/28/2014)


    crookj (1/28/2014)


    Ed Wagner (1/28/2014)


    BWFC (1/28/2014)


    Drink

    Restaurant

    Jocko's Steak House

    Rib Eye Steak

    Medium rare

    à point

    Blue

  • RE: Today's Random Word!

    Drink

  • RE: Today's Random Word!

    L' Eomot Inversé (1/24/2014)


    Ed Wagner (1/23/2014)


    BWFC (1/23/2014)


    JAZZ Master (1/22/2014)


    Revenant (1/22/2014)


    Ed Wagner (1/22/2014)


    SQLRNNR (1/22/2014)


    sim

    City

    bestseller

    novel

    New

    Clean

    Sterile

    Aseptic

  • RE: Concatenate? Coalesce? IsNull?

    Hi Sean

    I've had a tinker with my proc and using the CTE approach works just as quickly as temp tables when using my method to create the combined column. ...

Viewing 15 posts - 1,171 through 1,185 (of 1,240 total)