Forum Replies Created

Viewing 15 posts - 5,161 through 5,175 (of 9,726 total)

  • 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

  • RE: SSIS inserts are very slow

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

    BTW, what type of...

    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:36 am

    #1402820

  • RE: Are the posted questions getting worse?

    Jeff Moden (10/5/2011)

    "How do you return the current date and time from SQL Server using T-SQL?"

    ...

    The answer the interviewee returned was "I don't know... we always used the GUI...

    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:32 am

    #1402818

  • RE: Are the posted questions getting worse?

    Sean Lange (10/3/2011)

    This one (http://codevc.com/19244_A_The_WebGrid_Helper_-_Making_Selections.aspx) is a classic. The images are replaced with "Thief" image because they were lifted. The link in the article to "My previous article" even points...

    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:24 am

    #1402816

  • RE: Are the posted questions getting worse?

    GilaMonster (10/3/2011)

    SQLRNNR (10/3/2011)

    GilaMonster (10/3/2011)

    It's not the only one.

    http://consultingblogs.emc.com/sujeethkonagalla/archive/2011/09/29/with-recompile-and-option-recompile-sql-server-2008.aspx

    http://www.sqlservercentral.com/articles/T-SQL/70809/

    and

    http://consultingblogs.emc.com/sujeethkonagalla/archive/2011/09/29/take-an-asp-net-application-offline.aspx

    http://weblogs.asp.net/dotnetstories/archive/2011/09/24/take-an-asp-net-application-offline.aspx

    Wow, this guy is a real class act. I wonder what EMC thinks about it?

    From what I could see (with a few...

    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:21 am

    #1402812

Viewing 15 posts - 5,161 through 5,175 (of 9,726 total)