Forum Replies Created

Viewing 15 posts - 19,681 through 19,695 (of 59,098 total)

  • RE: view creation using xml column on linked/distributed server

    The other have told you how to parse it. That's good because I just want to rant a bit and I know none of it is your fault. ...

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

    September 4, 2015 at 5:39 pm

    #1824792

  • RE: First Occurance of the string from text

    If I understand what you're looking for, it's actually pretty easy. Use a "not" pattern to exclude BCD.

    DECLARE @Text1 VARCHAR(8000);

    SELECT @Text1 = 'ABNAGENDRACSURENDRADJITHENDRAXNARENDRABVEERNDARAXDRMNDRAXRVINDRABNAGENDRACSURENDRADJITHEN';

    -- ...

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

    September 4, 2015 at 5:15 pm

    #1824791

  • RE: Create dates right on the hour interval-best technique

    mar.ko (9/4/2015)

    Sorry guys, my bad....definitely having a bad day.

    And DateAdd is probably efficient....as whenever strings are involved, the conversion is usually costly.

    Lowell's solution is very slick and efficient.

    Sean's solution 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)

    September 4, 2015 at 3:49 pm

    #1824785

  • RE: Can't release space of temdb

    Eric M Russell (9/4/2015)

    Jeff Moden (9/4/2015)

    Alvin Ramard (9/4/2015)

    Jeff Moden (9/3/2015)

    sriponraj (9/3/2015)

    Check the connection for temp db by using sp_who2 active. Kill all the connection related to temp db and try...

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

    September 4, 2015 at 10:29 am

    #1824737

  • RE: Create dates right on the hour interval-best technique

    mar.ko (9/4/2015)

    Sean Lange (9/4/2015)

    mar.ko (9/4/2015)

    I tried this:

    SELECT Convert(smalldatetime,Round(Convert(float,(dbo.fnDateOnly(getDate())))+16.0000000/24.0000000,6))

    Result: 2015-09-04 16:00:00

    It works (FnDateOnly strips the time).

    Is there a more efficient way ?

    What are you trying to do? And what is fnDateOnly?

    RTFM:...

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

    September 4, 2015 at 9:23 am

    #1824713

  • RE: The Problem Solver

    Eric M Russell (9/4/2015)

    Andrew_Steitz (9/4/2015)

    Ed Wagner (9/3/2015)

    Jeff Moden (9/3/2015)

    When I was the Director of MIS for a small but nationwide telephone company, someone asked me about my habit of hiring...

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

    September 4, 2015 at 9:13 am

    #1824707

  • RE: Partition switching when you can have old data

    kyagi.jo (9/4/2015)

    Hi,

    That's fine, it makes sense, but my exact case, I view it as more like if the initial partition is A, then I want to partition switch, but load...

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

    September 4, 2015 at 8:53 am

    #1824697

  • RE: Can't release space of temdb

    Alvin Ramard (9/4/2015)

    Jeff Moden (9/3/2015)

    sriponraj (9/3/2015)

    Check the connection for temp db by using sp_who2 active. Kill all the connection related to temp db and try to shrink..

    So, if the run...

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

    September 4, 2015 at 8:39 am

    #1824692

  • RE: Creating 15000 partitions

    shamshad.ali (9/3/2015)

    I have an assignment on this and prepare a presentation for this task in few days. Please do not forget your post on this. I need to resolve it...

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

    September 4, 2015 at 1:10 am

    #1824557

  • RE: Slow site

    @robert.chipperfield,

    Praise and kudos to you and the team, again. The site has been absolutely awesome and better than it has been for longer than we thought. That hardware/cable...

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

    September 3, 2015 at 7:48 pm

    #1824528

  • RE: SQL Backups

    jasona.work (8/28/2015)

    mike 57299 (8/27/2015)

    Thank you for the info.

    In your opinion, which is better - full every night or full once a week and differentials?

    Mike

    Short answer, it depends.

    Long answer,...

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

    September 3, 2015 at 7:45 pm

    #1824527

  • RE: SQL Backups

    jasona.work (8/28/2015)

    Ricky, you are correct about basing the TLog backups on how much data loss is acceptable.

    In my case, the actual data loss customers agree too (not my call) 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)

    September 3, 2015 at 7:42 pm

    #1824524

  • RE: The Problem Solver

    Andy Warren (8/31/2015)

    Jeff,

    I wonder if the life of a DBA isn't different than most because of the complexity compared to other systems. I'm not an Exchange/Sharepoint/whatever/whatever guy, but it sure...

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

    September 3, 2015 at 7:37 pm

    #1824523

  • RE: Percentage of Fragmentation increased after 6 hours

    coolchaitu (9/1/2015)

    Dear Jeff,

    In that case, how to find unused indexes.

    You can still use the information in sys.dm_db_index_usge_stats to guide you. You just don't want to do it based...

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

    September 3, 2015 at 7:09 pm

    #1824520

  • RE: Can't release space of temdb

    sriponraj (9/3/2015)

    Check the connection for temp db by using sp_who2 active. Kill all the connection related to temp db and try to shrink..

    So, if the run you kill is 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)

    September 3, 2015 at 5:13 pm

    #1824511

Viewing 15 posts - 19,681 through 19,695 (of 59,098 total)