Forum Replies Created

Viewing 15 posts - 31,441 through 31,455 (of 59,101 total)

  • RE: On Database Migrations and Agility

    GSquared (1/9/2012)

    But what most developers mean by "Agile" is actually "Cowboy".

    Hear here!!! GUS FOR PRESIDENT!!! 😀

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 9, 2012 at 10:00 pm

    #1430889

  • RE: Censoring the Internet

    Michael Valentine Jones (1/8/2012)

    Jeff Moden (1/7/2012)

    Michael Valentine Jones (1/7/2012)

    Police abuse of this is so common that it is more like robbery than police work, especially because police departments are often...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 9, 2012 at 9:57 pm

    #1430888

  • RE: Censoring the Internet

    Steve Jones - SSC Editor (1/9/2012)

    It also allows for the bypass of a court order...

    I don't believe that's true.... here's a quote from pages 13 and 14 of the bill...

    19...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 9, 2012 at 9:33 pm

    #1430887

  • RE: Calculating percentages

    Thanks for the feedback, Ken. Heh... I always wonder if people notice how I sometimes generate test data for these posts. I guess the answer is that at...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 9, 2012 at 9:13 pm

    #1430882

  • RE: HHMMSS int field to human-friendly time?

    !Aaron Aardvark! (1/9/2012)

    Just for interest's sake, here's the in-line function written to use SQL Server 2012:

    CREATE FUNCTION dbo.agent_datetime_inline

    (

    @Date integer,

    @Time ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 9, 2012 at 8:58 pm

    #1430881

  • RE: Understanding and Using APPLY (Part 1)

    SAinCA (1/9/2012)

    As requested, Jeff:

    I thought the problem may have been with the split function you had listed but, looking at the code you provided for the split functions, I don't...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 9, 2012 at 8:39 pm

    #1430880

  • RE: HHMMSS int field to human-friendly time?

    I agree that the MS function should have been written as an iTVF instead of a scalar UDF. Heh... that was a part of the point I was trying...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 9, 2012 at 6:17 am

    #1430412

  • RE: HHMMSS int field to human-friendly time?

    Michael Valentine Jones (1/8/2012)

    The overhead of the function call can have a large impact on the results.

    Understood and agreed... that's precisely the reason I posted such a test... to show...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 8, 2012 at 7:31 pm

    #1430259

  • RE: Script component

    Thank you for the feedback. I usually don't like to write queries for tables I know nothing about and think I got pretty lucky on this one. Glad...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 8, 2012 at 7:25 pm

    #1430258

  • RE: Kill procceses

    djustice 20821 (1/6/2012)

    I am trying to detach a database. I have killed all processes, but it still gives me an error saying I can't detach because the DB is...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 8, 2012 at 6:51 pm

    #1430256

  • RE: Returning a column per date in a range

    nick-1043370 (1/6/2012)

    Hi

    I need to take a set of records for people with hotel check-in/check-out dates, and display a table that has a column for each date in the range, with...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 8, 2012 at 6:48 pm

    #1430255

  • RE: Weekend data in SQL server 2000

    padhis (1/6/2012)

    Try using this in your query.

    SELECT * FROM tablenae WHERE DATEPART(dw, datecolumn) IN (1, 7);

    Better make real sure what the DATEFIRST setting is if you're going to use that...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 8, 2012 at 6:42 pm

    #1430254

  • RE: On Database Migrations and Agility

    It therefore always surprises me when Application programmers tell me that all 'Agile' techniques are directly applicable to database development.

    Heh... what did you expect, Phil? Many application programmers and...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 8, 2012 at 6:27 pm

    #1430253

  • RE: Microsoft Gold Certified Partner Companies - Horror Stories

    GilaMonster (1/8/2012)

    Jeff Moden (1/8/2012)

    Do you have a convenient link for the "recent changes"?

    Err, no, sorry. I got the rant from my boss and colleague and ran across a few more...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 8, 2012 at 5:41 pm

    #1430251

  • RE: Read-only Data

    We keep 2 days worth of full backups along with Point-in-Time (PIT) logfiles for each full backup. Those, of course, rotate through every two days but not before the...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    January 8, 2012 at 4:58 pm

    #1430250

Viewing 15 posts - 31,441 through 31,455 (of 59,101 total)