Forum Replies Created

Viewing 15 posts - 5,716 through 5,730 (of 9,726 total)

  • RE: How to remove duplicates from column without using Temp table

    Hashbytes seems overly complicated to me as well.

    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.

    June 20, 2011 at 5:14 am

    #1341055

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (6/17/2011)

    Cross your fingers, everyone. Horse vet called, ugly cut on the rear hind of a horse. I think it can be stitched, but you never...

    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.

    June 20, 2011 at 5:07 am

    #1341050

  • RE: Backup Duration

    GilaMonster (6/17/2011)

    Which would you prefer?

    1) Finding out the backup is damaged and unrestorable right after making it, when you can make another

    2) Finding out the backup is damaged after the...

    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.

    June 20, 2011 at 5:04 am

    #1341045

  • RE: Datetime Conversion Issue in SSIS - Need Help

    paul.knibbs (6/20/2011)

    But if the Sybase DATETIME is only accurate to 1/300th of a second, it CAN'T be using any old values for the thousandths--0.001 would make no sense because the...

    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.

    June 20, 2011 at 5:01 am

    #1341043

  • RE: Are the posted questions getting worse?

    SQLRNNR (6/17/2011)

    Brandie Tarvin (6/17/2011)

    Wow. PASS people have been busy the past two weeks. I've gotten more SQL Saturday speaker request notifications than I can shake a stick at!

    Yeah it seems...

    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.

    June 17, 2011 at 12:36 pm

    #1340664

  • RE: Are the posted questions getting worse?

    Wow. PASS people have been busy the past two weeks. I've gotten more SQL Saturday speaker request notifications than I can shake a stick 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.

    June 17, 2011 at 12:32 pm

    #1340660

  • RE: Are the posted questions getting worse?

    GilaMonster (6/17/2011)

    Off to the UK for a week and a half. Can some people keep an eye on the corruption forums make sure that any problems don't get unchallenged stupid...

    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.

    June 17, 2011 at 12:31 pm

    #1340657

  • RE: Are the posted questions getting worse?

    Kiara (6/17/2011)

    Brandie Tarvin (6/17/2011)

    Kiara (6/17/2011)

    Totally off the security rights topic... can anyone point me in the right direction to get some information on realistic salary levels in the US 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.

    June 17, 2011 at 10:46 am

    #1340593

  • RE: Are the posted questions getting worse?

    Kiara (6/17/2011)

    Totally off the security rights topic... can anyone point me in the right direction to get some information on realistic salary levels in the US for SSRS developers?

    Salary.com is...

    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.

    June 17, 2011 at 10:39 am

    #1340584

  • RE: PerfectDisk Vs DisKeeper

    damiang (6/17/2011)

    I'm the Product Manager for Diskeeper Corporation, & want to speak to some of the questions posed directly.

    That is a very well written post. Thank you for putting up...

    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.

    June 17, 2011 at 10:35 am

    #1340579

  • RE: temp table in user database?

    glen.wass (6/17/2011)

    HI, try looking up variable temp tables, as i understand it these work from memory however, i do think that there is a limit to the amount of data...

    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.

    June 17, 2011 at 10:33 am

    #1340578

  • RE: Backup Duration

    gmamata7 (6/17/2011)

    Question: Is my backup procedure good enough to take backup of Production database?

    Yes and no.

    Yes, because it's taking your backups.

    No, because to truly verify your backups, it's best 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.

    June 17, 2011 at 10:30 am

    #1340574

  • RE: Datetime Conversion Issue in SSIS - Need Help

    paul.knibbs (6/17/2011)

    Brandie Tarvin (6/16/2011)

    Notice the difference in the accuracy.

    They look the same to me--0.000, 0.003 or 0.007 means 3 divisions in 1/100th of a second, which is 1/300th second accuracy....

    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.

    June 17, 2011 at 10:26 am

    #1340569

  • RE: Are the posted questions getting worse?

    GSquared (6/17/2011)

    george sibbald (6/17/2011)

    quick straw poll if you don't mind guys -

    how much access should developers have in a development environment?

    As much as they need. Really, in a dev...

    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.

    June 17, 2011 at 7:49 am

    #1340435

  • RE: temp table in user database?

    Jeff Moden (6/17/2011)

    Brandie Tarvin (6/16/2011)

    However, a lot of people I know use staging tables that they create and drop at need in a user db. These are permanent tables, even...

    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.

    June 17, 2011 at 7:46 am

    #1340432

Viewing 15 posts - 5,716 through 5,730 (of 9,726 total)