Forum Replies Created

Viewing 15 posts - 5,146 through 5,160 (of 9,715 total)

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    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.

    @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    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?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    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?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 3, 2011 at 12:19 pm

    #1402853

  • RE: Odd, Intermittent Error in Dataflow

    Jack Corbett (11/3/2011)

    I've never used the multi-cast, I'll have to look at it as it might be a better way to handle this.

    Multicast is a funderful thing. Try it. You...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 3, 2011 at 12:12 pm

    #1402843

  • RE: SSIS inserts are very slow

    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 see how having a...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 3, 2011 at 12:09 pm

    #1402842

  • RE: Are the posted questions getting worse?

    Quick question. Has anyone else been approached by John Millward of Callidus Technology Limited for permission to use your SQL Articles on a social networking site he's putting together?

    The site...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 3, 2011 at 12:02 pm

    #1402837

  • RE: SSIS inserts are very slow

    Stefan Krzywicki (11/3/2011)

    Brandie Tarvin (11/3/2011)

    For the two instances you don't require any transformations, don't use the Data Flow task. Using a stored procedure in an Execute SQL Task is much...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    November 3, 2011 at 11:56 am

    #1402831

Viewing 15 posts - 5,146 through 5,160 (of 9,715 total)