Forum Replies Created

Viewing 15 posts - 24,856 through 24,870 (of 59,099 total)

  • RE: optimal indexes for a table that is read frequently

    Sridhar-137443 (1/6/2014)

    Hi, we have a history table in our system that we insert records into it once every 2 weeks but we query the table almost every day. So, we...

    --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 6, 2014 at 12:48 pm

    #1677860

  • RE: Windowing Ranges

    Hugo Kornelis (12/9/2013)

    marcia.j.wilson (12/9/2013)

    Any examples of how these would be used?

    Running totals. Traditionally done with slow set-based code, with a (relatively!) fast cursor, or with some dangerous unsupported side effect...

    --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 6, 2014 at 12:11 pm

    #1677854

  • RE: DATEDIFF Statement help!

    ChrisM@Work (1/6/2014)

    If you haven't got a timestamp date/time column in your table, how can you tell if something is more than 7 days old?

    Does your table have an assocoation 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 6, 2014 at 9:16 am

    #1677795

  • RE: Compare XML in two tables

    Better yet, stop storing denormalized data in the form of XML in your database (never mind storing it twice!). 😉

    --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 6, 2014 at 9:11 am

    #1677793

  • RE: please help me

    elham_azizi_62 (1/6/2014)

    thanks for your reply.I create this sp with your query:

    ALTER procedure [dbo].[icanSP_Convert_GetEntityDependencies]

    @DocId INT,@Count int

    as

    begin

    ;WITH MyTable AS (

    SELECT * FROM (select linknumber,savabegh from main2 where savabegh is not null 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 6, 2014 at 9:07 am

    #1677791

  • RE: Hidden Formatting Troubles with STR() (SQL Spackle)

    First, thanks for the test. On the subject of defending MS for the slowness of FORMAT based on the fact that it's a generic function, I'm sure that 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)

    January 6, 2014 at 1:18 am

    #1677663

  • RE: Get Previous month data based on condition

    born2achieve (1/5/2014)

    Hi Geff,

    First of all i don't have enough vocabulary to thank you because the way you answering to the forum questions are much professional and elaborated which will help...

    --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 5, 2014 at 8:22 pm

    #1677636

  • RE: Get Previous month data based on condition

    Ok, here we go. It always takes me a little longer than others because I like to explain things a bit.

    First, I like Michael's code the best out 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)

    January 5, 2014 at 4:39 pm

    #1677618

  • RE: Get Previous month data based on condition

    born2achieve (1/5/2014)

    you meant to say startdate is any date in july 2013 and enddate is any date in jusly 2014. Obviously the data has to fetched because all the 30...

    --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 5, 2014 at 2:47 pm

    #1677614

  • RE: Get Previous month data based on condition

    Almost forgot. What do you want to do about the Jul 2013 to Jul 2014 scenario that I previously stated?

    --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 5, 2014 at 1:02 pm

    #1677609

  • RE: Get Previous month data based on condition

    born2achieve (1/5/2014)

    Hi Jeff,

    Thanks for your precious time on this post and here is my exact business requirement,

    From the sample i have provided, assume current date is January 5th which...

    --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 5, 2014 at 12:59 pm

    #1677608

  • RE: Segregation of Accounting Duties Analysis DB Help

    The Many-to-Many table doesn't mean that this isn't in 3rd Normal form.

    For the "conflict" resolution that you seek, you're going to need to setup some sort of a "rules" table...

    --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 5, 2014 at 12:14 pm

    #1677604

  • RE: transfer data

    fateme soleimani (1/5/2014)

    very thanks for your guides.but i am low level and i dont sovle my problems.

    please more help me about solve problem.

    best regards

    Understood. This isn't a trivial task,...

    --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 5, 2014 at 11:28 am

    #1677599

  • RE: Copy Backup to DVD

    alnawrass2002 (1/5/2014)

    Hi,How can I automate copying Last Backup to DVD using SQL Server Job.

    Regards

    Schedule the manual process that you're currently doing using Windows Scheduler.

    As a bit of a sidebar, 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)

    January 5, 2014 at 11:24 am

    #1677598

  • RE: How to partition table

    arooj300 (1/5/2014)

    whenever we try to upload the data...the application will be hang or it stop uploading data.

    please tell me how to resolve this issue

    Thanks in avance

    Gosh... still not enough information....

    --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 5, 2014 at 11:16 am

    #1677596

Viewing 15 posts - 24,856 through 24,870 (of 59,099 total)