Forum Replies Created

Viewing 15 posts - 421 through 435 (of 3,047 total)

  • RE: Data Quality - Addressing non-stated requirements

    Unfortunately my experience has been no-one knows what they don't know. So it comes down to putting something together that matches the requirements, have it tested, discover what was missed,...

    July 28, 2016 at 6:43 am

    #1892458

  • RE: Too Much Information for Sports

    I just love it when an athlete does something just absolutely impossible, that the data of the day says can't be done, such as Roger Bannister breaking the 4 minute...

    July 28, 2016 at 6:36 am

    #1892456

  • RE: Yet another way to defrag indexes

    GabyYYZ (7/25/2014)

    ggeier (7/25/2014)

    What advantages does this script have over Ola Hallengren's index maintenance solution?

    Sometimes, I want a script without too many bells and whistles. That was mainly it.

    Great. As...

    July 28, 2016 at 6:24 am

    #1892452

  • RE: Learning to Search

    Gary Varga (7/27/2016)

    As for emails, I use my Inbox as a traditional (read physical) Inbox. It is a todo list of tasks so everything either gets filed or deleted when...

    July 27, 2016 at 6:27 am

    #1892248

  • RE: Fibonacci Series in TSQL

    Michael Meierruth (12/18/2014)

    OK, so it's a cute CTE exercise.

    But has anyone ever used the Fibonacci series values for anything in the real world?

    I would be curious to know.

    It can be...

    July 26, 2016 at 6:37 am

    #1892022

  • RE: The basic Aggregate function

    david.gugg (7/25/2016)

    I think this kind of makes sense if you come at it from the Oracle perspective. In Oracle, to select values you have to go against the SYS.DUAL...

    July 26, 2016 at 6:31 am

    #1892021

  • RE: How do you know when it is time to leave a job?

    For my current job I'll leave when I retire from work altogether.

    July 25, 2016 at 6:35 am

    #1891802

  • RE: How do you know when it is time to leave a job?

    Yet Another DBA (7/22/2016)

    Time to leave?

    Hmm, with some companies its the day after I started.

    That's sad you didn't know that before you started.

    July 25, 2016 at 6:35 am

    #1891801

  • RE: A DBCC Copy

    SQLRNNR (7/20/2016)

    Ed Wagner (7/20/2016)

    Now that's a powerful command I hadn't heard of before. Thanks for the opportunity to learn something new (and also cool) this morning.

    In fairness, the command...

    July 21, 2016 at 5:43 am

    #1891279

  • RE: Computer Math

    Good to know, thanks. Missing parenthesis trip up a lot of new programmers.

    July 21, 2016 at 5:40 am

    #1891277

  • RE: Byte Me: Supervirus

    Cute

    July 21, 2016 at 5:37 am

    #1891276

  • RE: Fuzzy Processing

    Over forty years ago one of my advanced math classes had a problem about how to aim a moving sub's torpedo at a moving ship and hit it. Of course...

    July 7, 2016 at 6:42 am

    #1888897

  • RE: Kill Connections for a specific database

    a.m 46061 (7/7/2016)

    Killing connections like that reminds me of my Sybase days!

    How about a one liner?

    ALTER DATABASE [dbname] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    That will drop all user connections apart from...

    July 7, 2016 at 6:27 am

    #1888893

  • RE: Changing Linked Server Properties

    Thanks for the education about linked servers. We have created some backup servers that we want to link.

    July 7, 2016 at 6:25 am

    #1888891

  • RE: Get Blocking Details

    Boy have I got a good use for this one, thanks.

    July 6, 2016 at 6:28 am

    #1888659

Viewing 15 posts - 421 through 435 (of 3,047 total)