Forum Replies Created

Viewing 15 posts - 1,861 through 1,875 (of 5,685 total)

  • RE: should i remove READ UNCOMMITTED statements after i turn on Row Versioning

    Correct, otherwise you're not going to use the snapshot. Snapshot Isolation is basically an option for isolation levels, and anywhere that specifically calls out a different one will ignore...

    January 31, 2012 at 12:11 pm

    #1440888

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (1/31/2012)

    Brandie Tarvin (1/31/2012)

    Greg Edwards-268690 (1/31/2012)

    Brandie Tarvin (1/31/2012)

    SQLRNNR (1/31/2012)

    Greg Edwards-268690 (1/31/2012)

    Koen Verbeeck (1/31/2012)

    Greg Edwards-268690 (1/31/2012)

    Must have been the 3rd table that caused the confusion.

    Book only showed 2 in an...

    January 31, 2012 at 12:02 pm

    #1440877

  • RE: Are the posted questions getting worse?

    SQLRNNR (1/27/2012)

    jcrawf02 (1/27/2012)

    SQLRNNR (1/27/2012)

    GSquared (1/27/2012)

    sturner (1/27/2012)

    GSquared (1/27/2012)

    Stop trying to help them.

    Personally, I am growing more and more fond of Celko's approach with each passing day.

    I understand the temptation, truly do.

    Just...

    January 27, 2012 at 11:05 am

    #1439540

  • RE: Are the posted questions getting worse?

    GilaMonster (1/27/2012)

    My favourite 'not enough information' recently was at SQLTeam. Question basically stated "The following code throws an error. Please help

    Dim CPDHourUpdate As SqlDataSource = New SqlDataSource() CPDHourUpdate.ConnectionString = ConfigurationManager.ConnectionStrings("Application").ToString()...

    January 27, 2012 at 3:20 am

    #1439237

  • RE: Best practices for File groups in OLTP Database?

    Um, erm... :ermm:

    "It Depends". What's your physical spindle separation look like? Are you dealing with BLOBs? What's your table access look like? What's your lookup...

    January 27, 2012 at 3:17 am

    #1439233

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (1/27/2012)

    SQL Kiwi (1/27/2012)

    Koen Verbeeck (1/27/2012)

    I got the swift reply: "No links. Only code samples plz. Its urgent."

    Whenever I see "...it's urgent...", I think: "Not for me it isn't."

    Indeed...

    January 27, 2012 at 3:12 am

    #1439231

  • RE: Are the posted questions getting worse?

    Roy Ernest (1/26/2012)

    Somebody please put the brakes on the THREAD. It keeps moving from one random topic to another. It does not even care who gets run over with these...

    January 27, 2012 at 2:40 am

    #1439209

  • RE: Please help :(

    mithubhudolia (1/27/2012)

    please reply me of my question only .

    Thanks

    You need a tally or calendar table (as Paul mentioned above) to fill in the gaps. See the link in my...

    January 27, 2012 at 2:38 am

    #1439207

  • RE: how write split function for this store procedure

    er.sivaganesh (1/27/2012)

    can u plz help me

    Gianluca tried. Twice. You're not bothering to help yourself.

    The article he linked to Jeff Moden's splitter function is a walkthrough on how to...

    January 27, 2012 at 2:36 am

    #1439206

  • RE: Today's Random Word!

    Brandie Tarvin (1/26/2012)

    "Wish it were Sunday, cause that's my fun day."

    "And that's where I wil be... I'm gonna see the cow beneath the sea...."

    -- Cowtown, TMBG for the unfamiliar

    January 26, 2012 at 11:42 am

    #1438964

  • RE: Multiple Data Flow Performance

    P Jones (1/26/2012)

    You can use sequence containers to group things and put precedence constraints between the containers to run them one at a time.

    Exact opposite of what he's looking to...

    January 26, 2012 at 11:36 am

    #1438962

  • RE: Logging strategy - specifically logging data about affected tables

    webrunner (1/26/2012)

    Hello,

    I'm wondering if there is any best practice or established convention about dealing with the following:

    I'm designing a job that cleans up log tables by deleting rows older than...

    January 26, 2012 at 11:31 am

    #1438960

  • RE: Trying to get dev team off the sa account

    I agree with Jack on most points but personally I'd use AD groups, not individual users, for security assignment. This way all the security associations exist at the AD...

    January 26, 2012 at 11:28 am

    #1438958

  • RE: Connection Managers in SSIS - which one to use

    HowardW (1/25/2012)

    In terms of the source or destination of a data flow task, I'd definitely choose the OLE DB connection. However, if executing a stored procedure (for example) in an...

    January 26, 2012 at 11:17 am

    #1438953

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/26/2012)

    GilaMonster (1/26/2012)

    Brandie Tarvin (1/26/2012)

    GilaMonster (1/26/2012)

    Brandie Tarvin (1/26/2012)

    Dealer: Umm, about that tiny oil leak....

    I hate days like this.

    I've had that. It was followed by almost R10 000 repair bill...

    January 26, 2012 at 11:15 am

    #1438951

Viewing 15 posts - 1,861 through 1,875 (of 5,685 total)