Forum Replies Created

Viewing 15 posts - 22,666 through 22,680 (of 59,099 total)

  • RE: Work Pattern Calendar Tables

    itwhiz (10/5/2014)

    Hi,

    I need to prove that there is a speed issue with one of our stored procs/functions but to do this I need to create a large static work pattern...

    --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)

    October 5, 2014 at 11:59 pm

    #1750217

  • RE: Are the posted questions getting worse?

    rodjkidd (10/5/2014)

    Jeff Moden (10/4/2014)

    rodjkidd (10/4/2014)

    So in Utrecht, for SQL Sat Holland.

    Early start, have coffee, seen some familiar faces, so going well so far!

    Any one got a heckle for Grant? 🙂

    Jeff...

    --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)

    October 5, 2014 at 8:03 am

    #1750185

  • RE: The Next Five Years

    To be honest and despite the best intentions of people doing such things, I'm afraid... very afraid.

    Look at what went on just this last year. How many companies data...

    --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)

    October 4, 2014 at 11:30 pm

    #1750170

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (10/4/2014)

    Jeff Moden (10/3/2014)

    I'm in Pittsburgh for SQL Saturday 315 and I just got a PM from "Luke L" (one of the older members of SQL...

    --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)

    October 4, 2014 at 10:10 pm

    #1750166

  • RE: Are the posted questions getting worse?

    rodjkidd (10/4/2014)

    So in Utrecht, for SQL Sat Holland.

    Early start, have coffee, seen some familiar faces, so going well so far!

    Any one got a heckle for Grant? 🙂

    Jeff talking of wanting...

    --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)

    October 4, 2014 at 10:08 pm

    #1750165

  • RE: Conversion of varchar to datetime

    Probably not. And, you don't usually need to use CONVERT to cast a VARCHAR to a DATETIme when you're using things like DATEDIFF.

    What you do need to do, though,...

    --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)

    October 3, 2014 at 10:32 pm

    #1750119

  • RE: fast_forward cursors are read only but are they insensitive?

    gyerena (10/2/2014)

    Hello,

    I have this doubt. I've found different answers for this question in the web. A fast_forward cursor is read only by definition, meaning the rows can't be...

    --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)

    October 3, 2014 at 9:49 pm

    #1750115

  • RE: What's the right way to "test" a SQL Service Pack?

    Not everyone can afford the luxury of multiple boxes even if they're VM but I keep a Dev, Staging, and Prod systems up and running at all times. My...

    --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)

    October 3, 2014 at 9:46 pm

    #1750114

  • RE: Row limits

    Steve Jones - SSC Editor (10/3/2014)

    Jeff Moden (10/3/2014)

    Heh... the correct answer isn't actually listed. Answer "D" should be "During the mandatory peer review, you get a trip to 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)

    October 3, 2014 at 9:12 pm

    #1750113

  • RE: Row limits

    stephen.long.1 (10/3/2014)

    Steve, thanks for the easy question to end the week. I prefer TOP for my queries because its effects don't persist, but several of my peers use SET ROWCOUNT.

    Jeff,...

    --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)

    October 3, 2014 at 9:10 pm

    #1750112

  • RE: Are the posted questions getting worse?

    I'm in Pittsburgh for SQL Saturday 315 and I just got a PM from "Luke L" (one of the older members of SQL Server Central that's been laying low lately)...

    --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)

    October 3, 2014 at 8:55 pm

    #1750111

  • RE: Row limits

    Heh... the correct answer isn't actually listed. Answer "D" should be "During the mandatory peer review, you get a trip to the woodshed for a porkchop dinner for writing...

    --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)

    October 3, 2014 at 7:43 am

    #1749983

  • RE: Login Trigger Causing Deadlocks

    Ok.... I've studied your code and tables a bit. Let's peel one potato at a time...

    First, I see no need for the explicit transaction. Getting rid of 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)

    October 3, 2014 at 12:24 am

    #1749872

  • RE: Login Trigger Causing Deadlocks

    Stamey (10/2/2014)

    Jeff,

    In a perfect world this never would have happened. In my world, ruled by management, I can only be as heavy-handed as they will allow me. My first suggestion...

    --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)

    October 2, 2014 at 10:45 pm

    #1749870

  • RE: Remove non alpha chars from a column

    dwain.c (10/2/2014)

    DonlSimpson (10/2/2014)

    Maybe I'm missing something here, but this is simple and fast:

    declare @t varchar(5000) = 'RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row." This-divided-by,that|&/multiplied\by(100)give*you,%;<percent>.'

    declare @s-2...

    --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)

    October 2, 2014 at 10:37 pm

    #1749869

Viewing 15 posts - 22,666 through 22,680 (of 59,099 total)