Forum Replies Created

Viewing 15 posts - 21,376 through 21,390 (of 59,072 total)

  • RE: 10gb size of Index rebuild when space left overall 5gb

    hcip.77 (3/2/2015)

    I have 10 Gb index and disk space only left 5gb .

    How can i rebuild index ?

    I appreciate your time.

    Not many choices left. You're going to need 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)

    March 2, 2015 at 11:24 pm

    #1781270

  • RE: bcp queryout not working with line break

    The BCP command, including the embedded query, must be on a single line. The work around would be to use the "S" and "d" parameters and the query would...

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

    March 2, 2015 at 11:23 pm

    #1781269

  • RE: Where do senior SQL DBAs land finally?

    ZZartin (3/2/2015)

    Jeff Moden (3/2/2015)

    Don Halloran (3/1/2015)

    (Also I hate web development 😛 )

    Ah, yeah... we need to you move that smiley face one pixel to the right and change the color...

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

    March 2, 2015 at 6:48 pm

    #1781261

  • RE: Where do senior SQL DBAs land finally?

    Don Halloran (3/1/2015)

    (Also I hate web development 😛 )

    Ah, yeah... we need to you move that smiley face one pixel to the right and change the color on the tongue...

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

    March 2, 2015 at 3:26 pm

    #1781239

  • RE: Why does backup cause trigger to fire?

    I'll never understand why people audit the INSERTED table, ever. It's a gross duplication of data.

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

    March 2, 2015 at 2:09 pm

    #1781215

  • RE: Need help to create file with name and current time stamp.

    Note that BCP can generate files with the .xlsx extension, but they'll still just be text files. BCP cannot generate a true spreadsheet file... period. At best, 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)

    March 2, 2015 at 1:46 pm

    #1781205

  • RE: Patitioning

    iqbalbutt (3/2/2015)

    Is this the correct process to do partitioning?

    Rename constraints, indexes, and table

    Create table

    Create clustered index using Partition Scheme

    Create constraints

    Back fill data from renamed table

    Create non clustered indexes

    Verify row counts

    Drop...

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

    March 2, 2015 at 12:23 pm

    #1781192

  • RE: Partitioning

    iqbalbutt (3/2/2015)

    Is it a good practice to ask your manager for downtime before implementing partition?

    You should keep this question with the questions you asked about downtime on partitioning where 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)

    March 2, 2015 at 12:21 pm

    #1781191

  • RE: EXCEL HELL!!!

    sqldriver (3/2/2015)

    This is a great day! I get to tell people I'm as good at something in SQL as Jeff Moden, even if it is SSIS. 😀

    😀

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

    March 2, 2015 at 9:33 am

    #1781142

  • RE: Patitioning

    sql-lover (3/2/2015)

    iqbalbutt (3/1/2015)

    When you load the data into a new partition table, can it to done online without any downtime? because I have few tables that are around 250 gigs...

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

    March 2, 2015 at 9:05 am

    #1781130

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/1/2015)

    I am HOME!

    I had a nice dinner at Kassondra's house. I'm sorry, nothing beats good home cooking!

    Yeeee-haaaa!!!! The disturbance in the force has been resolved! ...

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

    March 2, 2015 at 9:00 am

    #1781128

  • RE: Flip data in SQL

    helal.mobasher 13209 (3/1/2015)

    Jeff,

    Thank you very much for your help. Just curious to know how to make it as dynamic SQL?

    Helal

    Luis' code (above) will do the dynamic thing for 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)

    March 2, 2015 at 8:56 am

    #1781125

  • RE: Insert into table dates in between two dates

    cs_source (2/28/2015)

    I have a table that has hotel guests and their start stay date and end stay date, i would like to insert into a new table the original 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)

    March 1, 2015 at 9:40 pm

    #1781018

  • RE: Patitioning

    iqbalbutt (3/1/2015)

    When you load the data into a new partition table, can it to done online without any downtime? because I have few tables that are around 250 gigs 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)

    March 1, 2015 at 9:35 pm

    #1781017

  • RE: Creating Tables from Excel list

    GrassHopper (3/1/2015)

    I have a list in Excel that has a list of about 30 tables with all column names and types. How can I programatically create the tables using...

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

    March 1, 2015 at 9:32 pm

    #1781015

Viewing 15 posts - 21,376 through 21,390 (of 59,072 total)