Forum Replies Created

Viewing 15 posts - 31 through 45 (of 1,220 total)

  • RE: Accept Failure

    Among many places, you can find it here.

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Beginning a CTE

    GSquared (6/3/2016)


    RedGate SQL Prompt does the same thing. It'll add semicolons, expand wildcards, etc., for you.

    SQL Prompt is pretty spiffy, but it's also 10x more expensive. And not...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Beginning a CTE

    drew.allen (6/3/2016)


    Wayne West (6/3/2016)


    I don't always drink beer, but when I do, I put a semi-colon in front of it. 😀

    This is why I like Mladen Prajdic's SSMS Tools[/url]: Ctrl-A,...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Accept Failure

    A previous place that I worked at wanted to "get rid of the mainframe". That was the objective. Ignore the fact that it had 99% uptime and balanced...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Beginning a CTE

    I don't always drink beer, but when I do, I put a semi-colon in front of it. 😀

    This is why I like Mladen Prajdic's SSMS Tools[/url]: Ctrl-A, Ctrl-K, Ctrl-G: all...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: The Coffee Routine

    At the observatory that my wife is at, one of her co-workers bought a beans-to-cup espresso machine. The astronomers love it. But the day staff? Give 'em...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Pergormance tuning for idiots (me)

    Then I think the PDF on the Redgate site is first edition.

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Pergormance tuning for idiots (me)

    Grant, how do you know which edition you have? The latest one says 'First published ... Sept 2011' but doesn't say if it's first or second edition.

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: How to reduce the database size of the User DB's

    aahkam (5/25/2016)


    ... More appropriately, you need to identify what are the unused index and what are the big index. Unused index may subject to dropping, large index will need close...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Should I Stay or Go?

    j_e_o (5/26/2016)


    ... I have revised my resume to remove half of my job experience and I removed all other dates (degrees and training) because I truly believe the problem was...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Should I Stay or Go?

    I was at one job for nine years and after some frustrating setbacks with no management support, I decided to quit. When I told my friends, they said "Oh,...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Log backup taking long.

    Grumpy DBA (5/24/2016)


    Base the log backup frequency on the amount of data your business user can afford to lose.

    This. If the database just does one ETL job daily and...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: How to reduce the database size of the User DB's

    Aside from Jeff's valid question about the largest index, I would like to know why: why does the database size need to be reduced. Yes, disk space is a...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: The Politics of SQL Security

    So many developers have full admin access to their workstations that you end up needing admin access to run the bloody stuff. First rule should be to make the...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: A Lifetime of Software

    Eric M Russell (5/11/2016)


    Because they grew up in an era without cubicles...

    Free range programmers? 😀

    Actually, in 30some years I've never truly worked in a cube farm. I've always had...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

Viewing 15 posts - 31 through 45 (of 1,220 total)