Forum Replies Created

Viewing 15 posts - 37,081 through 37,095 (of 59,098 total)

  • RE: 8KB page size

    Gopinath Srirangan (8/28/2010)

    Hi,

    I am creating a table of row size char(1000) as below.

    create table Optimised(id char(1000))

    i am insert values 1,2,3,4.....

    insert into Optimised values('1')

    insert into Optimised values('2')

    insert into Optimised values('3')

    insert into...

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

    August 28, 2010 at 11:18 am

    #1213448

  • RE: Can splitting a database to several databses improve performance.

    CirquedeSQLeil (8/28/2010)

    I would start with finding where the pain points in the app and database are. Once those have been identified, I would optimize the database (indexes, keys, constraints)...

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

    August 28, 2010 at 10:44 am

    #1213445

  • RE: Can splitting a database to several databses improve performance.

    ahmed.net (8/28/2010)

    Thanks Jason

    So what should i do??

    im confused.....!:unsure:

    This isn't meant to be as nasty as it's going to sound... my recommendation would be do get some design help. Get...

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

    August 28, 2010 at 10:41 am

    #1213443

  • RE: getting the sum

    PaulB-TheOneAndOnly (8/28/2010)

    cpinky01 (8/28/2010)

    I have sales type and under which i have

    sales for diff products

    and Calims under which i have different types of claims

    like this:

    1.Sales

    a. ...

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

    August 28, 2010 at 10:36 am

    #1213442

  • RE: recursive or a better way to solve this problem

    WayneS (8/28/2010)

    thava (8/28/2010)

    this way is slow when i used a large amount of data so i want change it for that, i need a little explanation there, could 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)

    August 28, 2010 at 10:34 am

    #1213441

  • RE: recursive or a better way to solve this problem

    thava (8/28/2010)

    sorry for the late reply

    Mark-101232 (8/24/2010)

    Try this

    SET DATEFORMAT YMD

    --Sample table

    DECLARE @TABLE AS TABLE(

    [RID] INT,

    [EMID] INT,

    [In Time] DATETIME,

    [Out Time] DATETIME)

    --Insert sample data

    INSERT INTO @TABLE

    SELECT 62, 12, '2005-08-18 06:02:00', '2005-08-18 06:31:00'

    UNION...

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

    August 28, 2010 at 10:33 am

    #1213440

  • RE: How to Tune Data Inserts

    WayneS (8/27/2010)

    I wouldn't worry about the insertion issue - SQL handles this pretty fast, and only on large tables with lots of data insertion/update/delete activity is this going to 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)

    August 28, 2010 at 9:45 am

    #1213437

  • RE: XP_cmdshell DIR

    Ness (8/27/2010)

    Sorry Jeff - I was anticipating using a script task from within SSIS [font="Arial Black"]to get the info that you were after[/font]. It should be a relatively easy ...

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

    August 28, 2010 at 8:57 am

    #1213429

  • RE: To split comma delimiterd string

    Heh... glad I'm not the only one behind on my posts. 🙂

    Thanks again, Barry and good to "see" you again... you've been "hiding".

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

    August 28, 2010 at 8:51 am

    #1213428

  • RE: Running totals... in groups

    skcadavre (8/25/2010)

    I'd go with something like this: -

    ALTER TABLE #mytable ADD id INT IDENTITY;

    SELECT t.datecount

    ,t.outlet

    ,t.brand

    ...

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

    August 27, 2010 at 8:56 pm

    #1213366

  • RE: concatenating columns

    Prema sambandam (8/25/2010)

    I have first name and last name in my table. I have to concatenate these two columns and update in other column. But if name appears...

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

    August 27, 2010 at 8:51 pm

    #1213365

  • RE: What are the daily DBA administrator tasks

    There's a huge amount of info available on this... just Google 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)

    August 27, 2010 at 8:37 pm

    #1213364

  • RE: Missing sequence number

    WayneS (8/27/2010)

    Jeff Moden (8/27/2010)

    You folks already have the split thing pretty much down pat so I'll just demo another method for detecting and displaying "gaps". I haven't tested every...

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

    August 27, 2010 at 8:24 pm

    #1213363

  • RE: Excel Colum Formatting

    WayneS (8/27/2010)

    Using OpenRowset/OpenDatasource, it can't be done.

    However, you can accomplish the formatting by:

    1. Use the Export wizard.

    2. Use a SSIS package.

    3. Use the sp_OA procedures to perform OLE Automation. This...

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

    August 27, 2010 at 7:35 pm

    #1213356

  • RE: Missing sequence number

    You folks already have the split thing pretty much down pat so I'll just demo another method for detecting and displaying "gaps". I haven't tested every method in 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)

    August 27, 2010 at 7:05 pm

    #1213352

Viewing 15 posts - 37,081 through 37,095 (of 59,098 total)