Forum Replies Created

Viewing 15 posts - 5,086 through 5,100 (of 9,722 total)

  • RE: Is this correct use of WITH (NOLOCK, READUNCOMMITTED) in delete?

    p-nut (11/17/2011)

    Ok, as it turns out she believes the reason is 2-fold. Her words: The first is that the nature of our data does not leave open transactions. ...

    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 17, 2011 at 8:51 am

    #1409271

  • RE: Missing Last Row of Data

    Jeff,

    I'm not sure of the intention of ragged right, but I know for a fact in SSIS 2005 it was just about the only version of Flat File Connection Managers...

    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 17, 2011 at 8:48 am

    #1409270

  • RE: Putting a condition on a subgroup to query result

    Both SSAS and SSRS have drill down functionality that makes things easier for you without having to code all the T-SQL. In fact, with SSRS, you can use subreports 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 17, 2011 at 4:48 am

    #1409085

  • RE: Is this correct use of WITH (NOLOCK, READUNCOMMITTED) in delete?

    Ninja's_RGR'us (11/17/2011)

    Dev (11/17/2011)

    I did my best to explain why it should not be used and was met with the same response. I got on the phone about 10...

    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 17, 2011 at 4:42 am

    #1409082

  • RE: Are the posted questions getting worse?

    Remember the guy with the missing CPUs?

    I figured out what his problem is: Tech Support Response[/url]

    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 16, 2011 at 12:47 pm

    #1408819

  • RE: Is this correct use of WITH (NOLOCK, READUNCOMMITTED) in delete?

    Dev (11/16/2011)

    Now I'm curious. Since when is the use of NOLOCK a best practice?

    This is cross-question. This is what I suggested to Ashu. 😀

    But what I am saying...

    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 16, 2011 at 9:44 am

    #1408699

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (11/16/2011)

    CIA is intechangable with many agencies! 😉

    Dangnabbit! You caught me. Yes, I do work for the Celestial Intervention Agency...

    Darned humans. You're too clever by half.

    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 16, 2011 at 9:39 am

    #1408692

  • RE: Are the posted questions getting worse?

    SQLRNNR (11/16/2011)

    Brandie Tarvin (11/16/2011)

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

    Ninja's_RGR'us (11/16/2011)

    I got to remember that one!

    http://www.sqlservercentral.com/Forums/Topic1206736-391-1.aspx

    GilaMonster (11/16/2011)

    ashuthinks (11/16/2011)

    i.m just using this stored procedure for reporting purpose..

    please let me know my usage is at...

    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 16, 2011 at 9:36 am

    #1408687

  • RE: Is this correct use of WITH (NOLOCK, READUNCOMMITTED) in delete?

    Do you have the authority and control to completely rewrite this process?

    If so, I urge you to to move the updates, inserts and deletes to a completely different ETL process...

    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 16, 2011 at 9:33 am

    #1408684

  • RE: Is this correct use of WITH (NOLOCK, READUNCOMMITTED) in delete?

    Dev (11/16/2011)

    ashuthinks (11/16/2011)

    @gila yes sir...

    i knew that if i don't use NOLOCK i will definitely get a deadlock so for successful

    execution i need to use NOLOCK

    You are...

    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 16, 2011 at 9:30 am

    #1408682

  • RE: Are the posted questions getting worse?

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

    Ninja's_RGR'us (11/16/2011)

    I got to remember that one!

    http://www.sqlservercentral.com/Forums/Topic1206736-391-1.aspx

    GilaMonster (11/16/2011)

    ashuthinks (11/16/2011)

    i.m just using this stored procedure for reporting purpose..

    please let me know my usage is at right or not?

    Since...

    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 16, 2011 at 9:28 am

    #1408677

  • RE: SQL Server 2008 vs R2 - Processors - cpu_count

    You're welcome. Did you figure out what the issue was yet? I'd love to hear the details if you have them.

    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 16, 2011 at 5:01 am

    #1408373

  • RE: Are the posted questions getting worse?

    But this is The Thread. Nothing on The Thread is supposed to make sense!

    @=)

    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 16, 2011 at 4:59 am

    #1408371

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (11/16/2011)

    Koen Verbeeck (11/15/2011)

    Ninja's_RGR'us (11/15/2011)

    jcrawf02 (11/15/2011)

    Hey, I like the condensed version of The Thread...

    Same here.

    No offense if I forgot anything else. I didn't reread the whole 2 weeks either...

    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 16, 2011 at 4:52 am

    #1408368

  • RE: Are the posted questions getting worse?

    Jim Murphy (11/15/2011)

    Stefan Krzywicki (11/15/2011)

    Brandie Tarvin (11/11/2011)

    EEEK! I just sold another story. Happy happy.

    Now I have to write more.

    Awesome! Congratulations. (Sorry, I'm catching up on the thread, but this...

    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 15, 2011 at 12:14 pm

    #1408116

Viewing 15 posts - 5,086 through 5,100 (of 9,722 total)