Forum Replies Created

Viewing 15 posts - 736 through 750 (of 4,080 total)

  • RE: Are the posted questions getting worse?

    GSquared (12/13/2012)


    The Dixie Flatline (12/13/2012)


    Budget cuts are the reason the first Death Star didn't have a grate or something covering the exhaust port.

    Really? I always just assumed a Jawa...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    I think Jawas and Ewoks must be descended from common ancestry. They both have an identical IIEEEEYAAAA war cry.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Today's Random Word!

    Prester John

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Today's Random Word!

    purgatory

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    Budget cuts are the reason the first Death Star didn't have a grate or something covering the exhaust port.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Today's Random Word!

    camembert

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Today's Random Word!

    Doc

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Today's Random Word!

    Transpose

    re.re.re.res

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Case Statement for Where Clause

    Think maybe changing from [mirroring_state] to [mirroring_role] had something to do with it? Your where clause could be logically rewritten as

    WHERE (d.database_id >= 5)

    ...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Case Statement for Where Clause

    I feel compelled to add this. As a general rule, you should not test against functions like ISNULL, because that can prevent the optimizer from taking advantage...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Case Statement for Where Clause

    Select

    d.name,

    d.compatibility_level,

    m.mirroring_state,

    mirroring_role_desc

    FROM

    sys.database_mirroring M inner join SYS.DATABASES d

    on m.database_id = d.database_id

    where D.database_id >=5

    and ISNULL(mirroring_role_desc,'') like CASE WHEN M.mirroring_state is NOT NULL...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Case Statement for Where Clause

    sunshine-587009 (12/7/2012)


    Here's my updated script with correct aliases and your suggestion.

    Select

    d.name,

    d.compatibility_level

    FROM

    sys.database_mirroring M inner join SYS.DATABASES d

    on m.database_id = d.database_id

    where D.database_id >=5

    ...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Case Statement for Where Clause

    sunshine-587009 (12/7/2012)


    Good afternoon everyone!

    I'm not a regular developer so please excuse my question for being easy for what would be a good developer.

    I'm trying to create a statement that returns...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Today's Random Word!

    Bulldog

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Today's Random Word!

    pantheon

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Viewing 15 posts - 736 through 750 (of 4,080 total)