Forum Replies Created

Viewing 15 posts - 18,841 through 18,855 (of 59,072 total)

  • RE: Shrink Database

    david.holley (12/23/2015)

    I have a project that uses a SQLExpress database. The size of the database is close to 50% of the max for a SQLExpress db. A big honking chunk...

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

    December 23, 2015 at 6:42 pm

    #1847867

  • RE: Attaching a file from Network Location

    GilaMonster (12/23/2015)

    sri2015 (12/23/2015)

    EXEC XP_CMDSHELL 'net use H: \\foldername1\foldername2\sharedfoldername3'

    EXEC XP_CMDSHELL 'Dir H:'

    EXEC XP_CMDSHELL 'net use H: /delete'

    Nope!

    SQL does not support mapped drives for database files, just the //server/share format,...

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

    December 23, 2015 at 6:27 pm

    #1847865

  • RE: Please Suggest Partition boundaries

    TheSQLGuru (12/22/2015)

    Jeff Moden (12/22/2015)

    TheSQLGuru (12/22/2015)

    Partitioning CAN make PROPERLY DESIGNED report queries go much faster when partition elimination can allow said queries to hit a small fraction of the total 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)

    December 23, 2015 at 6:25 pm

    #1847864

  • RE: Syntax help on how to create a rule

    mw112009 (12/23/2015)

    Create table x

    (

    IN_TABLE_NAME varchar(50),

    SOURCE_TYPE CHAR(1)

    );

    Question: I only want the SOURCE_TYPE column to have the

    following values: P, S, N, M

    How do I create a rule so that 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)

    December 23, 2015 at 6:02 pm

    #1847863

  • RE: LEAP and LAG behind the scenes

    Jason A. Long (12/23/2015)

    This is just a quick test... But according to this, the Windowed SUM is going faster... see what you think...

    You've fallen into the same trap that half...

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

    December 23, 2015 at 5:45 pm

    #1847862

  • RE: How to reduce Huge Log File size

    ScottPletcher (12/23/2015)

    Jeff Moden (12/22/2015)

    WhiteLotus (12/21/2015)

    Sounds good ..I also notice that all databases autogrowth option are 10% . Should I change all of them ?

    If the initial size was 1MB, 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)

    December 23, 2015 at 4:42 pm

    #1847859

  • RE: will full backup break log shipping

    PearlJammer1 (12/23/2015)

    Thanks very much. For some reason where I work they are saying that in the past backups have broken things...not sure what they have been doing historically.

    Thanks for confirmation...

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

    December 23, 2015 at 4:36 pm

    #1847857

  • RE: Changing the column name dynamically

    twin.devil (12/22/2015)

    Jeff you are right about the actual root cause thing but sometimes OP required the only one thing which is missing from the puzzle. i-e OP have already done...

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

    December 23, 2015 at 11:53 am

    #1847826

  • RE: Are the posted questions getting worse?

    Ed Wagner (12/22/2015)

    Michael L John (12/22/2015)

    Phil Parkin (12/22/2015)

    It seems that everyone in this thread spends their spare time shooting things :exclamationmark::-D

    It's better stress relief than choking developers.

    I find that people...

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

    December 23, 2015 at 11:20 am

    #1847815

  • RE: LEAP and LAG behind the scenes

    J Livingston SQL (12/23/2015)

    Jeff Moden (12/23/2015)

    I don't know what goes on behind the scenes but I do know that, whatever they did, it makes for relatively slow running totals. :crazy:

    Jeff...if...

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

    December 23, 2015 at 10:41 am

    #1847806

  • RE: Another Recursive Hierarchy bit of help needed...

    Jason A. Long (12/22/2015)

    Yea... I'm right there with you. My latest test harness was based solely on my perception of what Jeff was talking about. I'm not certain that it's...

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

    December 23, 2015 at 8:45 am

    #1847780

  • RE: LEAP and LAG behind the scenes

    I don't know what goes on behind the scenes but I do know that, whatever they did, it makes for relatively slow running totals. :crazy:

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

    December 23, 2015 at 8:27 am

    #1847768

  • RE: Datetime2

    Early Christmas gift... thanks Steve.

    Shifting gears to one of my "favorite" rants...

    Heh... if you use DATETIME2(3), you get approximately the same precision as DATETIME (3.3 milliseconds rounded to the nearest...

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

    December 23, 2015 at 8:24 am

    #1847766

  • RE: SQL server slowdown by increasing processors?

    awarnke 39611 (12/22/2015)

    I'd go back and rewrite the queries, but that would be a huge undertaking for a system we are moving towards obsolescence. We'll continue to dig...

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

    December 22, 2015 at 6:51 pm

    #1847629

  • RE: Database Stuck in Restore Mode

    itguy2015 (12/22/2015)

    I have a similar situation. I had a database "mydb" on a sql server instance on vm1. I also had mydb on a sql server instance on...

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

    December 22, 2015 at 6:47 pm

    #1847628

Viewing 15 posts - 18,841 through 18,855 (of 59,072 total)