Forum Replies Created

Viewing 15 posts - 511 through 525 (of 1,195 total)

  • RE: this code works but looks ugly.

    Thanks for the data. Please can you submit it as detailed in the first link in my signature or here

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    Thanks

    November 13, 2014 at 7:38 am

    #1758232

  • RE: this code works but looks ugly.

    Not sure that you would just move forwards a month with that code (unless I am miss-understanding something). Does the table BI1_DW_Dim_CalendarDefinition contain 356 / 366 days for each year?...

    November 13, 2014 at 7:04 am

    #1758215

  • RE: is this sql is proeritary or standerd sql.

    rajemessage 14195 (11/12/2014)

    is there any place where i can search it.

    please send me link.

    yours sinclerey

    BOL (Books on line) is the standard place to start and is accessed by the F1...

    November 13, 2014 at 1:23 am

    #1758151

  • RE: TSQL "where - 101"

    SQLRNNR (11/12/2014)

    hjp (11/12/2014)

    SQLRNNR (11/12/2014)

    Impossible. There are multiple correct answers.

    JK

    Ducks and runs - snigger.:-D:-D:-D:hehe:

    Like... what?? If you don't present your case and argue why you think so, then why bother...

    November 12, 2014 at 9:27 am

    #1758023

  • RE: TSQL "where - 101"

    Dave62 (11/12/2014)

    Stuart Davies (11/12/2014)

    It was sparked by new dev here, who couldn't see the difference between any of the four possible answers :w00t:

    As the question and answer showed mixed cases,...

    November 12, 2014 at 6:24 am

    #1757954

  • RE: TSQL "where - 101"

    Ed Wagner (11/12/2014)

    vivekjamshedpur (11/12/2014)

    Both choice 3 and 4 is correct.Because author does not say duplicate names are ok.:crazy:

    No, they aren't. He even bolded the word "all" in the question....

    November 12, 2014 at 6:18 am

    #1757947

  • RE: TSQL "where - 101"

    Stewart "Arturius" Campbell (11/12/2014)

    Good question, thanks Stuart

    erwin.oosterhoorn (11/12/2014)

    None of the answers are correct when you take into account the names are with a capital and the answers are lower case,...

    November 12, 2014 at 2:32 am

    #1757855

  • RE: Today's Random Word!

    SQLRNNR (11/11/2014)

    djj (11/11/2014)

    Ed Wagner (11/11/2014)

    Stuart Davies (11/11/2014)

    SQLRNNR (11/10/2014)

    Stuart Davies (11/10/2014)

    Ed Wagner (11/10/2014)

    Stuart Davies (11/10/2014)

    crookj (11/10/2014)

    SQLRNNR (11/10/2014)

    Ed Wagner (11/8/2014)

    crookj (11/7/2014)

    SQLRNNR (11/7/2014)

    prison stripes

    Steelers SUCKY uniform (Honey Bee Stripes).

    Referee

    tree

    House

    Horror

    Film

    Buff

    Vampire Slayer

    Captain Kronos

    Syndrome

    China

    Chyna

    Arnie

    November 11, 2014 at 8:35 am

    #1757703

  • RE: Are the posted questions getting worse?

    BWFC (11/11/2014)

    One of the people whose name I've seen attached to the kitchen cabinets spam lives just down the road from me. He's a reasonably notorious local businessman who's...

    November 11, 2014 at 2:00 am

    #1757619

  • RE: Today's Random Word!

    SQLRNNR (11/10/2014)

    Stuart Davies (11/10/2014)

    Ed Wagner (11/10/2014)

    Stuart Davies (11/10/2014)

    crookj (11/10/2014)

    SQLRNNR (11/10/2014)

    Ed Wagner (11/8/2014)

    crookj (11/7/2014)

    SQLRNNR (11/7/2014)

    prison stripes

    Steelers SUCKY uniform (Honey Bee Stripes).

    Referee

    tree

    House

    Horror

    Film

    Buff

    Vampire Slayer

    Captain Kronos

    November 11, 2014 at 12:49 am

    #1757614

  • RE: Today's Random Word!

    Ed Wagner (11/10/2014)

    Stuart Davies (11/10/2014)

    Ed Wagner (11/10/2014)

    Stuart Davies (11/10/2014)

    crookj (11/10/2014)

    SQLRNNR (11/10/2014)

    Ed Wagner (11/8/2014)

    crookj (11/7/2014)

    SQLRNNR (11/7/2014)

    prison stripes

    Steelers SUCKY uniform (Honey Bee Stripes).

    Referee

    tree

    House

    Horror

    Film

    Buff

    Bum

    Hobo

    November 10, 2014 at 1:11 pm

    #1757545

  • RE: Today's Random Word!

    Ed Wagner (11/10/2014)

    Stuart Davies (11/10/2014)

    crookj (11/10/2014)

    SQLRNNR (11/10/2014)

    Ed Wagner (11/8/2014)

    crookj (11/7/2014)

    SQLRNNR (11/7/2014)

    prison stripes

    Steelers SUCKY uniform (Honey Bee Stripes).

    Referee

    tree

    House

    Horror

    Film

    Buff

    November 10, 2014 at 12:45 pm

    #1757537

  • RE: Today's Random Word!

    crookj (11/10/2014)

    SQLRNNR (11/10/2014)

    Ed Wagner (11/8/2014)

    crookj (11/7/2014)

    SQLRNNR (11/7/2014)

    prison stripes

    Steelers SUCKY uniform (Honey Bee Stripes).

    Referee

    tree

    House

    Horror

    November 10, 2014 at 8:25 am

    #1757441

  • RE: Are the posted questions getting worse?

    Sadly I'm not getting the same sort of luck all I've had is the attached

    November 10, 2014 at 3:42 am

    #1757382

  • RE: Say I have 460 indexes that need to be rebuilt.... :w00t:

    spaghettidba (11/6/2014)

    I suggest that you take a look at Ola Hallengren's index maintenance procedure.

    It takes care of rebuilding/defragmenting indexes based on fragmentation level and skips the indexes with low...

    November 7, 2014 at 3:30 am

    #1757155

Viewing 15 posts - 511 through 525 (of 1,195 total)