Forum Replies Created

Viewing 15 posts - 2,356 through 2,370 (of 5,685 total)

  • RE: Are the posted questions getting worse?

    Sean Lange (11/14/2011)

    And a good reminder that we can all use a refresher on from time to time.

    As others have said, let me know if I cross that line. As...

    November 14, 2011 at 12:17 pm

    #1407472

  • RE: What else have you done?

    Good Lord. This is... going to sound a bit like a brag, but yeaaaahhhh...

    (these are the non-computer ones)

    - Janitor

    - Stock Broker

    - Costume Shop manager

    - Warehouse picker

    - 1 Hour...

    November 4, 2011 at 5:04 pm

    #1403539

  • RE: Split large table into smaller tables of equal size.

    Look into partitioned views. That may get you where you need to be, and will ease insert/deletion/lookups as well.

    November 4, 2011 at 4:09 pm

    #1403530

  • RE: Where are the good Senior Level DBA's?

    L' Eomot Inversé (11/2/2011)

    I guess that if you are fighting that one you've decided what tha A in DBA stands for? Depending what you want DBA to mean, you...

    November 4, 2011 at 12:39 pm

    #1403459

  • RE: Are the posted questions getting worse?

    SQLRNNR (11/4/2011)

    What is this query plan operator?

    Out of context I can't help but think that's a 'You are here' sign in a hotel room.

    November 4, 2011 at 12:34 pm

    #1403451

  • RE: Are the posted questions getting worse?

    Anyone else been having serious problems with posting today? Edits, quotes, even just add reply is being feisty. Won't seem to trigger the post creation page, then it...

    November 3, 2011 at 4:22 pm

    #1402975

  • RE: Are the posted questions getting worse?

    SQLRNNR (11/3/2011)

    GSquared (11/3/2011)

    I just found a stored procedure from my predecessor at my current job, and it just kind of made my jaw drop in the elegant simplicity of it's...

    November 3, 2011 at 4:19 pm

    #1402974

  • RE: SSIS inserts are very slow

    Stefan Krzywicki (11/3/2011)

    Evil Kraig F (11/3/2011)

    jcrawf02 (11/3/2011)

    I had a similar question on Andy Leonard's latest Stairway article. I thought SSIS was specifically designed to streamline the ETL process, but it...

    November 3, 2011 at 3:48 pm

    #1402968

  • RE: SSIS inserts are very slow

    jcrawf02 (11/3/2011)

    I had a similar question on Andy Leonard's latest Stairway article. I thought SSIS was specifically designed to streamline the ETL process, but it seems staging tables and updates...

    November 3, 2011 at 2:00 pm

    #1402922

  • RE: Over (Partition By)

    derekr 43208 (11/2/2011)

    One thing, the total rows returned is 121311 but the last value for SalesOrderDetailID is 121317

    Is that normal?

    Yep. It's the number of attempted inserts, not the number...

    November 2, 2011 at 12:46 am

    #1401982

  • RE: Maximum flow from continuous flow rate

    Brian Ki (11/1/2011)

    Sorry for the delay - back at it now. Normal flow rates of 0 to 10 mgd. Also there will be lots of data - perhaps...

    November 1, 2011 at 5:52 pm

    #1401932

  • RE: Collation and SQL_VARIANT

    Rich Weissler (11/1/2011)

    cfradenburg (11/1/2011)That's row number 2, not two rows.

    Doh! That's clear as day now. Thank you! (Both for the answer, and the patience.) (I learned...

    November 1, 2011 at 2:38 pm

    #1401866

  • RE: Subquery in quirky update

    gcresse (11/1/2011)

    I'm open to any ideas or suggestions on how I might accomplish this. Thanks for your input.

    My apologies. I'm sure there's a way out of this but...

    November 1, 2011 at 1:59 pm

    #1401837

  • RE: Where are the good Senior Level DBA's?

    InDeeDBA (11/1/2011)

    DBA has become a very wide ranging job title, and I think that's where the problem lies.

    +1 I couldn't agree more. I'm losing the fight to make...

    November 1, 2011 at 1:53 pm

    #1401828

  • RE: Using a Stored Procedure as A Data Source

    Welsh Corgi (11/1/2011)

    I need to make the following column headings and several others dynamic:

    CONVERT(VARCHAR(5), NULL) AS [2010],

    CONVERT(VARCHAR(25), NULL) AS [2011 YTD],

    CONVERT(VARCHAR(25),...

    November 1, 2011 at 12:49 pm

    #1401795

Viewing 15 posts - 2,356 through 2,370 (of 5,685 total)