Forum Replies Created

Viewing 15 posts - 14,491 through 14,505 (of 26,486 total)

  • RE: Would you use sql_variant?

    andersg98 (7/21/2011)


    I don't understand the reason for avoiding normalized design?

    The suggested design violates first normal form and should not be considered seriously in a relational database system. ...

  • RE: Are the posted questions getting worse?

    WayneS (7/20/2011)


    Anyone here have experience with Oracle? I'm looking for some data that demonstrates a need to use the RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW part of the OVER...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (7/20/2011)


    Jannie-186227 (7/20/2011)


    ahem.

    How do you reply to a thread with 23 thousand replies?

    Is there any more value to be added in this thread?

    Cheers

    Jannie

    In this space, say whatever needs saying....

  • RE: Are the posted questions getting worse?

    Jannie-186227 (7/20/2011)


    ahem.

    How do you reply to a thread with 23 thousand replies?

    Is there any more value to be added in this thread?

    Cheers

    Jannie

    Jannie,

    Welcome to The Thread. This thread has turned...

  • RE: Date passed into function changing length of time to execute

    I also recall you mentioning HIPPA, so I want to make sure you understand that when we ask for sample data we aren't looking for real data but made up...

  • RE: Are the posted questions getting worse?

    Jeff Moden (7/19/2011)


    But a late congrats to Lynn as well.

    Dang it. I haven't been keeping up and I've obviously missed something good.

    Lynn... what did you do?

    My oldest daughter, the...

  • RE: Are the posted questions getting worse?

    Jeff Moden (7/19/2011)


    Lynn Pettis (7/19/2011)


    Should be no surprise who I voted for as Exceptional DBA. I have learned a lot about SQL Server from Jeff, things I don't think...

  • RE: Date passed into function changing length of time to execute

    Besides the NOLOCK hint, my concern is the SELECT * FROM ... GROUP BY ... in the derived table.

    It would help if you would provide the actual code for the...

  • RE: Are the posted questions getting worse?

    Should be no surprise who I voted for as Exceptional DBA. I have learned a lot about SQL Server from Jeff, things I don't think I would have figured...

  • RE: Date passed into function changing length of time to execute

    I agree, we need to see the DDL for the function. In addition we also need the DDL of the tables used on the function.

  • RE: Outsourced = Laid Off?

    bopeavy (7/15/2011)


    Why dont we break it down on an average:

    1200rent

    400groceries

    300gas car

    100ins car

    200eletric

    100gas

    300health ins

    300car payment

    2900total monthly cost

    34800total year cost

    44544with tax cost tossed in

    So on an Average to live in america you...

  • RE: Outsourced = Laid Off?

    J Thaddeus Klopcic (7/15/2011)


    $50k - $75k plus nice benefits isn't enough? Sorry -- our systems can't spin gold from straw.

    Answer me this, why would I apply for a job...

  • RE: Are the posted questions getting worse?

    Chad Crawford (7/15/2011)


    Craig Farrell (7/14/2011)


    Hey guys, does anyone know of boot camp training session(s) for SQL Server for practical skills (not certifications). I'm talking real basics here. ...

  • RE: Date Parameters

    Have to agree I do. Please read the first article I reference below in my signature block below regarding asking for help. Then post the entire query you...

  • RE: SQL 2008 SP2

    Looks to me like you tried to apply th x86 version of SP2 to an x64 instance.

Viewing 15 posts - 14,491 through 14,505 (of 26,486 total)