Forum Replies Created

Viewing 15 posts - 1,036 through 1,050 (of 14,953 total)

  • RE: Double Hop problem!

    I'd be guessing.

    First two thoughts are permissions on one end or the other, or some connection option that isn't set correctly.

    - 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: Stored Proc to split data in two

    drew.allen (8/7/2012)


    Try NTILE().

    Drew

    Cool! Somehow, I missed that one in the ranking functions. Very nice.

    - 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: Double Hop problem!

    You're welcome.

    - 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: Confused about how to design a new process (third week into new role)

    On the point of "don't lose sight of the big picture", I'll just say that this is one of the biggest mistakes people make, assuming they can't do anything with...

    - 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: Anything out there better than SSRS

    J Livingston SQL (8/8/2012)


    GSquared (8/8/2012)


    If execs are looking for ad hoc reporting tools, it's hard to go wrong with pivot tables. PowerPivot and Excel have been mentioned already. ...

    - 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?

    Evil Kraig F (8/8/2012)


    -- Ignore this, bad joke that's not going to work as planned... I'm not going to get it wordy enough without copy/pasting a phone book or...

    - 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: Anything out there better than SSRS

    If execs are looking for ad hoc reporting tools, it's hard to go wrong with pivot tables. PowerPivot and Excel have been mentioned already. I haven't used PowerPivot,...

    - 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: Confused about how to design a new process (third week into new role)

    I agree with Craig.

    Break the process down into smaller pieces first. Conquer each piece, one at a time.

    In this kind of confusing situation, don't try to get a grasp...

    - 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 (8/8/2012)


    Jan Van der Eecken (8/8/2012)


    Jan Van der Eecken (8/8/2012)


    SQLRNNR (8/8/2012)


    Lynn Pettis (8/8/2012)


    SQLRNNR (8/8/2012)


    D.Oc (8/8/2012)


    SQLRNNR (8/7/2012)


    Editor: Image removed.

    LOL, made me laugh 🙂 Although it is not appropriate for...

    - 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: Double Hop problem!

    Have you tried the solutions proposed here: http://ssas-olap.blogspot.com/2011/07/linked-server-for-analysis-services.html

    - 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: Wiggle Room

    Coming in from the re-post of the editorial today.

    I used to know a manager who insisted that "consult" was just a phonetic contraction of "con" plus "insult".

    I've worked with a...

    - 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: How can I attract Senior Database Administrator candidates?

    bsclyde (8/7/2012)


    Evil Kraig F (8/2/2012)


    Would you be willing to post your current version here? As I mentioned, I'm unable to see the site it's currently posted on and would...

    - 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: Date Format Problem

    Jeff Moden (8/7/2012)


    GSquared (8/7/2012)


    Date formatting is done in the front-end application, not in the database. What application are you using? That's the point I'm making.

    There is no formatting...

    - 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: Tempdb log file location and Filegroup optimizations

    Robert Davis (8/7/2012)


    GSquared (8/6/2012)


    The whole idea is to maximize bandwidth that can be used to read/write in tempdb.

    ....

    Same for multiple files. It will often create zero advantage to...

    - 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: Crazy Interviews

    Weirdest interview I ever had was 4 hours long. They flew me out to their city, put me up in the local Hilton, rented a car for me for...

    - 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 - 1,036 through 1,050 (of 14,953 total)