Forum Replies Created

Viewing 15 posts - 18,781 through 18,795 (of 59,072 total)

  • RE: Are the posted questions getting worse?

    I rather like the mostly unedited type of articles that are posted on SQLServerCentral. As a regular working Joe-bag-o-dunuts, I don't have a whole lot of time to go...

    --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 29, 2015 at 8:20 am

    #1848503

  • RE: Shrink Database

    simon-hulse (12/29/2015)

    hmm..

    I have just run a shrink file and a shrink file with reorganise on a 30Gb database. The DB has lots of indexes. Just checking a couple... (both Clustered...

    --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 29, 2015 at 8:10 am

    #1848502

  • RE: Shrink Database

    david.holley (12/29/2015)

    I do find it interesting that the gut reaction is no giving the potential impact to Indexes, but a part of me can't help but wonder if normal monitoring...

    --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 29, 2015 at 7:32 am

    #1848487

  • RE: Where Do Staging Tables Belong

    lmarkum (12/28/2015)

    SoHelpMeCodd (12/28/2015)

    I do understand your perspective about not using resources on the OLTP instance for SSIS. I may consider moving things around so I could have SSIS 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 29, 2015 at 7:26 am

    #1848483

  • RE: query for datetime

    charipg (12/28/2015)

    is it correct ?

    SELECT * FROM tablename(nolock) where

    startdate >= Getdate() -6

    and enddate <= Getdate()

    Maybe... it depends on what you define as "days ago". If you mean...

    --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 28, 2015 at 9:54 pm

    #1848393

  • RE: Where Do Staging Tables Belong

    lmarkum (12/28/2015)

    So, the question is, "Do I put the staging tables in the main database or in a separate database?" Is there a best practice and why is 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 28, 2015 at 9:45 pm

    #1848391

  • RE: SQL express vs developer for MCSE:BI

    Don't limit your educational endeavors. Get the Developers Edition. It's usually less than $65USD somewhere. You'd pay almost that much for a good book.

    --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 28, 2015 at 5:05 pm

    #1848376

  • RE: Another XML explicit problem

    kenksoftware (12/28/2015)

    We are building an ETL project that is going to take hundreds of legacy data fields and place them into XML fields in a new SQL server database

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

    December 28, 2015 at 5:03 pm

    #1848375

  • RE: Send email from T-SQL

    mw112009 (12/28/2015)

    (:-P I will run it and findout whether our server is configured correctly to send email)

    If it turns out to not be setup and no one wants 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)

    December 28, 2015 at 4:56 pm

    #1848374

  • RE: Number VS Letter

    ScottPletcher (12/28/2015)

    I'd at least compare the performance of the straightforward brute-force method:

    Agreed. You absolutely should. Please build a million row test table with demonstrable postable code, do...

    --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 28, 2015 at 4:51 pm

    #1848373

  • RE: Bulk Insert not working

    regrahc (12/17/2015)

    Hello!

    Please excuse the "newbie" question, but I have an issue I haven't been able to work out. Trying to do a bulk insert of a .csv into 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)

    December 28, 2015 at 4:48 pm

    #1848372

  • RE: The Most Common Query Blunders...

    Alan.B (12/28/2015)

    Someone beat me to it but NOLOCK table hints are the #1 mistake I have seen.

    Heh... apparently, thousands of people agree with you. Instead, they use SET...

    --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 28, 2015 at 4:42 pm

    #1848371

  • RE: Is BCP queryout limited?

    dwilliscp (12/28/2015)

    I am using @cmd_bcp to generate my BCP command, depending on the parameters passed into the export program. But I am getting a truncate error and the statement is...

    --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 28, 2015 at 4:38 pm

    #1848370

  • RE: Cursor or special select statement?

    Hyabusact (12/28/2015)

    Thank you, I even understood it

    Scott's code works a treat for what you've done but storing Boolean markers horizontally in a table doesn't lend itself well to other things...

    --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 28, 2015 at 10:30 am

    #1848312

  • RE: The Most Common Query Blunders...

    TheSQLGuru (12/28/2015)

    Ooh, another thing I will chime in with. Some of the WORST things I see done on SQL Server have nothing to do with the databases/applications they run -...

    --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 28, 2015 at 9:19 am

    #1848284

Viewing 15 posts - 18,781 through 18,795 (of 59,072 total)