Forum Replies Created

Viewing 15 posts - 3,601 through 3,615 (of 9,399 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (3/15/2016)

    Brandie Tarvin (3/15/2016)

    In a change of subject, anyone else find it odd that someone would claim that the proper way of doing a SQL thing is a workaround and...

    March 15, 2016 at 5:06 am

    #1865165

  • RE: Today's Random Word!

    BL0B_EATER (3/15/2016)

    ThomasRushton (3/15/2016)

    Ed Wagner (3/14/2016)

    djj (3/14/2016)

    Ed Wagner (3/14/2016)

    djj (3/14/2016)

    Grumpy DBA (3/14/2016)

    Ed Wagner (3/14/2016)

    DonlSimpson (3/14/2016)

    crookj (3/14/2016)

    Happy Pi Day!

    Archimedes

    Screw

    Driver

    Track

    Race

    Horse

    Bet

    Fix

    corrupt

    Government

    March 15, 2016 at 5:02 am

    #1865163

  • RE: Today's Random Word!

    djj (3/14/2016)

    Ed Wagner (3/14/2016)

    djj (3/14/2016)

    Grumpy DBA (3/14/2016)

    Ed Wagner (3/14/2016)

    DonlSimpson (3/14/2016)

    crookj (3/14/2016)

    Happy Pi Day!

    Archimedes

    Screw

    Driver

    Track

    Race

    Horse

    Bet

    March 14, 2016 at 1:25 pm

    #1865042

  • RE: Today's Random Word!

    djj (3/14/2016)

    Grumpy DBA (3/14/2016)

    Ed Wagner (3/14/2016)

    DonlSimpson (3/14/2016)

    crookj (3/14/2016)

    Happy Pi Day!

    Archimedes

    Screw

    Driver

    Track

    Race

    March 14, 2016 at 11:59 am

    #1865029

  • RE: Today's Random Word!

    DonlSimpson (3/14/2016)

    crookj (3/14/2016)

    Happy Pi Day!

    Archimedes

    Screw

    March 14, 2016 at 10:47 am

    #1865003

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    spaghettidba (3/14/2016)

    Solomon Rutzky (3/14/2016)

    Jeff Moden (3/14/2016)

    I'll have to agree to strongly disagree with most everything you've said and the reasons you've said them.

    Well, for reasons heretofore stated and unstated, whether...

    March 14, 2016 at 10:47 am

    #1865002

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/14/2016)

    Brandie Tarvin (3/14/2016)

    Lynn Pettis (3/14/2016)

    Shouldn't this have been your first stop before going online?

    someop (3/13/2016)

    Thanks for your response. Actually, I got solution from my manager. Thanks for your...

    March 14, 2016 at 10:45 am

    #1865000

  • RE: Today's Random Word!

    ZZartin (3/14/2016)

    whereisSQL? (3/14/2016)

    Ed Wagner (3/14/2016)

    crookj (3/14/2016)

    Ed Wagner (3/14/2016)

    ThomasRushton (3/14/2016)

    Grumpy DBA (3/14/2016)

    Ed Wagner (3/11/2016)

    djj (3/11/2016)

    Bunny

    Easter Egg

    Hunt

    Saboteur

    Fired

    Terminated

    Arnold

    Sylvester

    Tweety

    Despicable

    March 14, 2016 at 8:52 am

    #1864955

  • RE: Today's Random Word!

    crookj (3/14/2016)

    Ed Wagner (3/14/2016)

    ThomasRushton (3/14/2016)

    Grumpy DBA (3/14/2016)

    Ed Wagner (3/11/2016)

    djj (3/11/2016)

    Bunny

    Easter Egg

    Hunt

    Saboteur

    Fired

    Terminated

    Arnold

    March 14, 2016 at 6:28 am

    #1864883

  • RE: LIKE with 2 searches

    planetmatt (3/14/2016)

    Alan.B (3/11/2016)

    Try

    WHERE Item LIKE '%S' OR Item LIKE '%B'

    WHERE Item like '%[S,B]'

    That leading wildcard in the search will force a scan of the column, so the query will...

    March 14, 2016 at 6:24 am

    #1864880

  • RE: Today's Random Word!

    ThomasRushton (3/14/2016)

    Grumpy DBA (3/14/2016)

    Ed Wagner (3/11/2016)

    djj (3/11/2016)

    Bunny

    Easter Egg

    Hunt

    Saboteur

    Fired

    March 14, 2016 at 5:41 am

    #1864875

  • RE: Finding the database collation

    Mauricio_ (3/14/2016)

    Stewart "Arturius" Campbell (3/14/2016)

    Mauricio_ (3/14/2016)

    1) and 4) are both right.

    SERVERPROPERTY('Collation') will return the server instance's collation, which may (and frequently does) differ from the database collation.

    Ahh, thanks...

    March 14, 2016 at 5:40 am

    #1864874

  • RE: Multiple Entris in Night Shift in SQL

    Jeff Moden (3/12/2016)

    hardik-1087613 (3/12/2016)

    Also there will missing punch entries there like from above 10-03-2016 22:04:00 Entry will be missing.

    Ok... so what needs to happen in such an instance?

    That's where that...

    March 12, 2016 at 10:55 am

    #1864750

  • RE: Shrink data file even though it is a bad practice....

    Jeff Moden (3/12/2016)

    Ed Wagner (3/11/2016)

    I hope you're planning on doing some serious index maintenance after all this shrinking. Shrinking data files tends to fragment indexes to 99%, so it...

    March 12, 2016 at 10:27 am

    #1864747

  • RE: SQL code to check IFEXISTS in db

    Since this is your first time posting here, welcome to SSC.

    I think your logic could be simplified a bit by using this:

    IF (SELECT COUNT(*) FROM dbo.Clock WHERE ClockIn = '12/03/2015'...

    March 12, 2016 at 7:55 am

    #1864738

Viewing 15 posts - 3,601 through 3,615 (of 9,399 total)