Forum Replies Created

Viewing 15 posts - 25,576 through 25,590 (of 59,099 total)

  • RE: Query Optimization help

    - Win (10/21/2013)

    Hello Jeff Moden,

    Happy to see your response on this. I have couple of questions.

    What do you mean ?

    What should I understand with your response, the last lines ?

    SSNs...

    --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 22, 2013 at 2:14 pm

    #1660704

  • RE: Database Queries and Scalability

    L' Eomot Inversé (10/21/2013)

    I certainly don't like the article referenced, it seems to me that it is a heap of assertions for whose credence no basis is offered. Yes,...

    --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 21, 2013 at 4:51 pm

    #1660335

  • RE: can't get rid of leading zeroes

    Keith Tate (10/21/2013)

    You may have leading and/or trailing tabs instead of spaces which the trim's won't replace. You can use CHARINDEX to find CHAR(9) in a string and then use...

    --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 21, 2013 at 4:38 pm

    #1660329

  • RE: Strange Behavior with (nolock)

    josh 92884 (10/21/2013)

    First post here so hope I don't come of as too newb with this.

    I have a table on a MSSQL 2000 with about 4700 rows.

    My query:

    SELECT * FROM...

    --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 21, 2013 at 4:28 pm

    #1660324

  • RE: Stored Proc slow on secondary only

    Everything has a "tipping point". 1 Extra row can cause an execution plan to change drastically.

    --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 21, 2013 at 2:36 pm

    #1660301

  • RE: finding hierarchy info

    This sounds like the perfect task for Nested Sets. Looking forward to readily consumable sample data for this problem.

    --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 21, 2013 at 2:23 pm

    #1660296

  • RE: Stored Proc slow on secondary only

    Are the indexes and stats actually being rebuilt on the secondary?

    --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 21, 2013 at 2:18 pm

    #1660294

  • RE: Best way to DELETE and archive the data

    jonysuise (10/21/2013)

    Hi SSC Journeyman, 😀

    Maybe another approach could be partitionning your table.

    Hope it helps. 😎

    +1. You beat me to the punch on that one. I'm going through 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 21, 2013 at 2:16 pm

    #1660293

  • RE: palindrome

    sqlserver12345 (10/21/2013)

    nothing just ...just learning some coding

    In that case, I strongly recommend that you drop the whole idea of using a WHILE loop and not using REVERSE. Might as...

    --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 21, 2013 at 1:31 pm

    #1660264

  • RE: Export Data from SQL Server 2000 or earlier

    hoseam (10/21/2013)

    Is there any way I could export data to excel or other database(SQL Server 2008 or 2012) from SQL Server 93

    I tried to use SQL Server Import 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)

    October 21, 2013 at 9:04 am

    #1660160

  • RE: Need help with simple ETL strategy with SSIS

    blasto_max (10/20/2013)

    Koen Verbeeck (10/20/2013)

    In contrast with Jeff, I know (quite) a lot about SSIS.

    DO NOT USE SSIS FOR THIS.

    Use dynamic SQL for this (as Jeff mentioned).

    If I would need to...

    --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 21, 2013 at 8:23 am

    #1660154

  • RE: palindrome

    dwain.c (10/20/2013)

    sqlserver12345 (10/20/2013)

    I do not want to use reverse function.please check the code I posted and correct what wrong I did.thanks

    That's exactly what we're doing by showing you the right...

    --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 20, 2013 at 8:44 pm

    #1660015

  • RE: palindrome

    sqlserver12345 (10/18/2013)

    declare @count int

    declare @charvaluefront varchar

    declare @charvalueback varchar

    declare @frontpos int

    declare @backpos int

    select @count=len('ABC')

    set @frontpos=1

    set @backpos=@count

    while(@frontpos<=@count)

    begin

    select @charvaluefront=substring('ABC',@frontpos,1)

    select @charvalueback=substring('ABC',@backpos,1)

    set @frontpos=@frontpos+1

    set @backpos=@backpos-1

    print @charvaluefront

    print @charvalueback

    end

    How do I compare @charvaluefront and @charvalueback values to test...

    --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 20, 2013 at 5:38 pm

    #1660009

  • RE: palindrome

    mickyT (10/20/2013)

    The 'no reverse' is an interesting requirement.

    I believe what we have here is homework about how to use WHILE loops and the instructor probably never heard of a Tally...

    --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 20, 2013 at 5:01 pm

    #1660008

  • RE: palindrome

    sqlserver12345 (10/20/2013)

    I do not want to use reverse function.please check the code I posted and correct what wrong I did.thanks

    I'm curious... please explain why you don't want to use "REVERSE".

    I...

    --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 20, 2013 at 12:13 pm

    #1659984

Viewing 15 posts - 25,576 through 25,590 (of 59,099 total)