Forum Replies Created

Viewing 15 posts - 16,471 through 16,485 (of 59,067 total)

  • RE: Lexmark Software?

    adalineachani (10/27/2016)

    What are the main issues/Problems in Lexmark Software?

    I've not used it personally nor do I know of anyone that has. Since its basic purpose is "Enterprise Level Process...

    --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 27, 2016 at 4:11 pm

    #1909257

  • RE: 8 Ways to Export SQL Results To a Text File

    ken.trock (10/27/2016)

    For results to file, I have to Cast the columns to a shorter length than what they because, at least for .txt, a Varchar(200) will output a nice underlined...

    --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 27, 2016 at 3:37 pm

    #1909248

  • RE: Question on Simple Recovery Model

    The question you ask is one of "those" questions with a whole lot of tentacles, especially if your in need of doing something in particular using that recovery model. ...

    --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 27, 2016 at 11:46 am

    #1909200

  • RE: Tasks which only a sysadmin can perform

    S_Kumar_S (10/27/2016)

    Hi All

    I need to know what the the tasks which only a sysadmin can perform and cannot be performed by any of other role/roles. I have came across 3...

    --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 27, 2016 at 11:40 am

    #1909198

  • RE: Can anyone help optimize runtime on a dimension creating query?

    Luis Cazares (10/27/2016)

    I just can't understand why the FORMAT function is so slow.

    Rumor has it that it's one of "those" RegEx thingies from the .NET environment and is actually...

    --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 27, 2016 at 10:58 am

    #1909187

  • RE: why my query returns scientific notation for a varchar field?

    halifaxdal (10/27/2016)

    It turns out to be something with the original data import, the function str is fine, and no need because the re-import fixed the issue.

    Sorry for confusing.

    The STR()...

    --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 27, 2016 at 10:50 am

    #1909185

  • RE: DTA - want to delete dta indexes

    krypto69 (10/27/2016)

    Hi,

    Previous DBA used DTA to create allot of indexes.

    I though DTA indexes always skipped (not used) by queries?

    But when I run this:

    SELECT OBJECT_NAME(S.[OBJECT_ID]) AS [OBJECT NAME],

    ...

    --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 27, 2016 at 10:46 am

    #1909184

  • RE: Big data: transfer x-number of rows per batch?

    wtren (10/26/2016)

    Yes, very fast, for multiple tables, you can also open several windows and download different table simultaneously.

    Except, in most SAN environments, that will actually slow things down because you...

    --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 27, 2016 at 10:23 am

    #1909174

  • RE: Want to learn SQL

    maomfamao (10/27/2016)

    found a lot of useful information, I am pleased to join your community!

    Your links look like SPAM to me. Got anything useful?

    --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 27, 2016 at 8:19 am

    #1909137

  • RE: Bit of a rant - queries on space

    Ed Wagner (10/27/2016)

    Jeff Moden (10/26/2016)

    Kazmerelda (10/25/2016)

    My email to them has said I am not prepared to take off backups, and my worry is we won't have that space put in...

    --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 27, 2016 at 8:17 am

    #1909136

  • RE: Can I do this?

    Brandie Tarvin (10/27/2016)

    All right, everyone. I think now is a good time to back away from this thread. Obviously there's been several misinterpretations of who has posted what and what...

    --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 27, 2016 at 8:12 am

    #1909130

  • RE: Wasting Time

    Chris Harshman (10/27/2016)

    Miles Neale (10/12/2012)

    Meetings can be good. However, they need to be short, to the point, make decisions, and not be rambling sessions where everyone gets their say...

    --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 27, 2016 at 8:10 am

    #1909129

  • RE: Bit of a rant - queries on space

    Kazmerelda (10/25/2016)

    My email to them has said I am not prepared to take off backups, and my worry is we won't have that space put in for them.

    Ok... no pun...

    --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 26, 2016 at 4:49 pm

    #1909035

  • RE: Simple Talk Website Redesign

    andrew.ing (9/7/2016)

    I wonder when sql server central will succumb to the red-and-black treatment.

    They kinda almost did a couple of times. The last time was when they started to make...

    --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 26, 2016 at 4:11 pm

    #1909027

  • RE: SQL Job - almost good

    Ed Wagner (10/26/2016)

    If I were doing this, I would fire the email and update the table in the same procedure. I don't see a reason to separate them, unless...

    --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 26, 2016 at 4:04 pm

    #1909026

Viewing 15 posts - 16,471 through 16,485 (of 59,067 total)