Forum Replies Created

Viewing 15 posts - 3,241 through 3,255 (of 14,953 total)

  • RE: Insight for a Developer in a Rut

    To chime in on the job postings, interviews, and even the credit check stuff:

    Job postings are almost never accurate. When I was job hunting last year, I had two...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    GilaMonster (9/28/2011)


    WayneS (9/28/2011)


    Grant Fritchey (9/28/2011)


    Jack Corbett (9/28/2011)


    Hey can an execution plan expert (Grant?) take a look at this thread, http://www.sqlservercentral.com/Forums/Topic1181619-338-1.aspx. Interesting behavior noted in execution plan properties with SET...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: ANSI_NULLS setting is ignored?

    I'm using 2008 R2 Dev Edition, and I get the correct settings per the script.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Joining tables based using a date to a date range

    Try these two versions. (Dev/Test environment, of course.) What kind of performance and execution plans do you get with them?

    UPDATE dbo.ParsedMessage

    SET p.EventGuid =...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Memory Problems?

    tfendt (9/27/2011)


    Yes, it says it is not required, but it doesn't say that it wont help keep the memory from paging out. I am aware that the AWE allows 32...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    SQL Kiwi (9/28/2011)


    WayneS (9/27/2011)


    • DBA Certification preferred in SQL Server versions 2000, 2005, and 2008.

    • ...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    GilaMonster (9/27/2011)


    Steve Jones - SSC Editor (9/27/2011)


    Not that I'm asking for more political debates here, but if it comes up, nothing wrong with a little (meaning short, for Gail's sake),...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    Sean Lange (9/27/2011)


    GSquared (9/27/2011)


    Looks like The Thread may have killed the rest of the forums.

    The Active Threads link is only showing 5 other discussions.

    (Probably my fault for going political in...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    Looks like The Thread may have killed the rest of the forums.

    The Active Threads link is only showing 5 other discussions.

    (Probably my fault for going political in here. I...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    GilaMonster (9/27/2011)


    Enough? Please?

    Sorry, I'll shut up now.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    There are already strict laws in place protecting anonymous and non-anonymous safety violation reports, in the US. A worker is more likely to never need to work again if...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Joining tables based using a date to a date range

    I seriously doubt this is doing anything useful in your query, since the Join math already enforces that rule.

    AND f.EventBegin >= (SELECT MIN(MessageDateTime) FROM dbo.ParsedMessage)

    Can you post the execution plan?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    Nope, that's not what I'm claiming. I'm stating that this is one of the responsibilities of government, inspection of workplaces for safety.

    If you ran into that kind of situation and...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (9/27/2011)


    GSquared (9/27/2011)


    Stefan Krzywicki (9/27/2011)


    Sean Lange (9/27/2011)


    GSquared (9/27/2011)


    Sean Lange (9/26/2011)


    /soapbox on

    ...

    /soapbox off

    It's a pretty fair bet that some people would assume I'm a pretty rabid conservative. On the...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Dynamic T-SQL, set the result of the query to @variable

    The problem is this part:

    EXEC @Percentage2012 =

    When you do that, you are setting the variable to the return value of the executed procedure. Not the output parameter, the return...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 15 posts - 3,241 through 3,255 (of 14,953 total)