Forum Replies Created

Viewing 15 posts - 5,131 through 5,145 (of 9,707 total)

  • RE: Are the posted questions getting worse?

    jcrawf02 (11/7/2011)

    SQLRNNR (11/4/2011)

    SQL Kiwi (11/4/2011)

    SQLRNNR (11/4/2011)

    Cadavre (11/4/2011)

    Brandie Tarvin (11/4/2011)

    SQL Kiwi (11/4/2011)

    So, it depends

    Someone so needs to come up with an interview question where this is the exact answer that's needed.

    Isn't...

    November 7, 2011 at 7:16 am

    #1403937

  • RE: Sort objecst in Object Explorer

    Sorry it took me so long to respond. I've been busy.

    I appreciate the answers, but I'm not sure you understand what I'm looking for. I want to fiddle with the...

    November 7, 2011 at 6:10 am

    #1403888

  • RE: Comparing 2 Tables

    Sean Lange (11/4/2011)

    Sounds like you need the cascading delete and an insert trigger on the master. In your trigger just insert into the peer review table the new metric. No...

    November 7, 2011 at 5:26 am

    #1403856

  • RE: SSIS inserts are very slow

    Alexander Suprun (11/4/2011)

    Stefan Krzywicki (11/3/2011)

    Brandie Tarvin (11/3/2011)

    I forgot to mention something.

    If push comes to shove and you can't use an Execute SQL Task, and absolutely must have a Data Flow...

    November 7, 2011 at 5:19 am

    #1403855

  • RE: Why is my SELECT query slower when the table is indexed?

    cliffb (11/4/2011)

    In terms of data types, I would not use a FLOAT to define a monetary field. FLOAT is an approximate numeric.

    You'd be amazed at how many businesses want...

    November 4, 2011 at 11:30 am

    #1403418

  • RE: Are the posted questions getting worse?

    SQL Kiwi (11/4/2011)

    So, it depends

    Someone so needs to come up with an interview question where this is the exact answer that's needed.

    @=)

    November 4, 2011 at 8:30 am

    #1403271

  • RE: Are the posted questions getting worse?

    Ki,

    You do remember that Table Variables use TempDB, right?

    November 4, 2011 at 7:29 am

    #1403207

  • RE: Why is my SELECT query slower when the table is indexed?

    You didn't post your index(es). What are they?

    November 4, 2011 at 7:14 am

    #1403199

  • RE: Comparing 2 Tables

    bubs (11/2/2011)

    -"For the delete, make MasterReviewID on PeerReview reference MasterReview with a cascading delete."

    Can you please provide an example?

    Look up Triggers in SQL Books Online. That's what he means.

    -"But for...

    November 4, 2011 at 7:12 am

    #1403198

  • RE: Are the posted questions getting worse?

    WHOOT! Just got my author's copy of Space Tramps in.

    Space Tramps information:

    Amazon link: http://www.amazon.com/Space-Tramps-Full-Throttle-Tales/dp/0984592741

    ISBN numbers, if you care to order it from your local bookstore (which I highly encourage!):

    ISBN-10: 0984592741...

    November 4, 2011 at 6:39 am

    #1403173

  • RE: SSIS inserts are very slow

    Evil Kraig F (11/3/2011)

    I should learn not to post when I'm typing quickly.

    Or when you have the lint ball monster from H3CK watching over your shoulder with it's evil googly...

    November 4, 2011 at 6:35 am

    #1403169

  • RE: Are the posted questions getting worse?

    Lynn Pettis (11/3/2011)

    I really wonder about some of the people that come here. Some of the questions are just so elemetary that I can't believe someone actually has to...

    November 4, 2011 at 6:32 am

    #1403167

  • 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 1:03 pm

    #1402888

  • RE: SSIS inserts are very slow

    I forgot to mention something.

    If push comes to shove and you can't use an Execute SQL Task, and absolutely must have a Data Flow Task instead, use a stored procedure...

    November 3, 2011 at 12:22 pm

    #1402861

  • RE: SSIS inserts are very slow

    Stefan Krzywicki (11/3/2011)

    Brandie Tarvin (11/3/2011)

    ricer (11/3/2011)

    Is the GUID your clustered index key as well?

    If so you are probably seeing lots of page splits when you are doing inserts.

    I fail to...

    November 3, 2011 at 12:19 pm

    #1402853

Viewing 15 posts - 5,131 through 5,145 (of 9,707 total)