Forum Replies Created

Viewing 15 posts - 7,261 through 7,275 (of 9,720 total)

  • RE: How to get unique value from a records from multiple columns

    Yikes. You're trying to eliminate cascading values? That's not nearly as easy as you presented it and changes both answers you've received on this thread.

    Leaning towards Celko on 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.

    October 8, 2010 at 12:23 pm

    #1234452

  • RE: Backup Types

    I'm glad the question has helped so many people. I did not realize how few people knew about File and Partial backups.

    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.

    October 8, 2010 at 12:03 pm

    #1234431

  • RE: Are the posted questions getting worse?

    Ray K (10/8/2010)

    Gianluca Sartori (10/8/2010)

    At last, Mr. Celko gives a polite and useful answer to a poor-worded question.

    It's nice to see everyone can learn.

    I don't know. I sensed 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.

    October 8, 2010 at 11:53 am

    #1234426

  • RE: How to get unique value from a records from multiple columns

    I noticed, in your example, you only listed two of the unique numbers instead of all four. Is there a reason why the other two numbers should not come 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.

    October 8, 2010 at 11:52 am

    #1234425

  • RE: Database Goes Missing

    Oh. Sorry. I'm having a weird Friday.

    I have not yet tested File Watcher. I'll check into that as soon as I get a chance. Have you tested it yet?

    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.

    October 8, 2010 at 11:39 am

    #1234414

  • RE: Database Goes Missing

    Greg Edwards-268690 (10/8/2010)

    Did you look at file watcher? Would you consdier this a valid option?

    Greg, I'm not the OP. I was just testing a suggestion I made earlier in...

    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.

    October 8, 2010 at 9:31 am

    #1234352

  • RE: Are the posted questions getting worse?

    Chris Morris-439714 (10/8/2010)

    Brandie Tarvin (10/8/2010)

    Grant Fritchey (10/8/2010)

    what is it we do for work again?

    Work is a four letter word. My mother taught me to behavior better than that.

    Behaviour, please 🙂

    Can...

    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.

    October 8, 2010 at 8:55 am

    #1234323

  • RE: Are the posted questions getting worse?

    Grant Fritchey (10/8/2010)

    what is it we do for work again?

    Work is a four letter word. My mother taught me to behavior better than that.

    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.

    October 8, 2010 at 8:43 am

    #1234314

  • RE: Today's Random Word!

    SDLC

    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.

    October 8, 2010 at 7:06 am

    #1234228

  • RE: How to truncate log file in SQL Server 2005

    GilaMonster (10/8/2010)

    It may not finish immediately, depending on the amount of dirty pages and the requested checkpoint duration, but it should start straight away.

    Got a demo or reference?

    Only personal experience....

    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.

    October 8, 2010 at 7:01 am

    #1234219

  • RE: Database Goes Missing

    Okay. I've tested the DDL trigger and it does not work against SSAS databases. Unfortunately.

    I have it straight from the horse's mouth that when reprocessing occurs, there is data file...

    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.

    October 8, 2010 at 6:52 am

    #1234208

  • RE: How to truncate log file in SQL Server 2005

    Be aware that just typing in CHECKPOINT and executing it does not mean that it will execute immediately. SQL Server will run it immediately only if it's convenient to 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.

    October 8, 2010 at 5:23 am

    #1234156

  • RE: Are the posted questions getting worse?

    Jeff Moden (10/8/2010)

    The Dixie Flatline (10/7/2010)

    I just had an idea for an epic summer movie. It involves an intrepid group of DBA's and SQL Developers who...

    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.

    October 8, 2010 at 5:17 am

    #1234151

  • RE: Are the posted questions getting worse?

    Jeff Moden (10/8/2010)

    WayneS (10/7/2010)

    Brandie Tarvin (10/7/2010)

    GilaMonster (10/7/2010)

    This has got to take some form of prize. http://www.sqlservercentral.com/Forums/FindPost1000227.aspx

    Time to get the crystal ball out again.

    Apparently it's my turn to feel snippy. I...

    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.

    October 8, 2010 at 5:16 am

    #1234149

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/7/2010)

    I'd been intending to ask at some point as I do go to a number of cons, mostly in the NE US + WorldCon any year it isn't...

    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.

    October 7, 2010 at 12:41 pm

    #1233871

Viewing 15 posts - 7,261 through 7,275 (of 9,720 total)