Forum Replies Created

Viewing 15 posts - 4,441 through 4,455 (of 9,722 total)

  • RE: Are the posted questions getting worse?

    dwain.c (5/13/2012)


    Oh and BTW. I've been using the below terminology. If anyone knows of different, more widely accepted terminology, I'd appreciate knowing what that is.

    Single use trigger -...

    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.

  • RE: Common questions asked in SQL Server DBA Interview

    What is the wing span of an unladen swallow?

    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.

  • RE: Today's Random Word!

    Ray K (5/11/2012)


    Hawaii (vacation planned for October!)

    50

    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.

  • RE: Error :64(The specified network name is no longer available.)

    I find it amusing that this is the only time that having multiple points of failure is a good thing.

    Of course, I'm not really sure you should have used 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.

  • RE: Are the posted questions getting worse?

    Apparently, I just made one of the help desk guys very happy. He passed on a user problem with an Access db that has become unwieldy asking for solutions. My...

    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.

  • RE: why i can't shrink tempdb data file

    Bhuvnesh (5/9/2012)


    mike schreiner (5/9/2012)


    2. Go to cmd prompt and Run as Administrator

    5.Go to the Binn directory of the SQL Server instance. In this case it was d:\Program Files\Microsoft SQL...

    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.

  • RE: why i can't shrink tempdb data file

    mike schreiner (5/9/2012)


    How you fix it-

    1..Shut down SQL Services on SQL Backend.

    2. Go to cmd prompt and Run as Administrator

    5.Go to the Binn directory of the SQL Server instance....

    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.

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/10/2012)


    Brandie Tarvin (5/10/2012)


    Wow. I come back to The Thread and find the lot of you talking blasphemy.

    I think I shall strap myself to the porkchop launcher and launch...

    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.

  • RE: Are the posted questions getting worse?

    Wow. I come back to The Thread and find the lot of you talking blasphemy.

    I think I shall strap myself to the porkchop launcher and launch myself out of reach...

    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.

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (4/23/2012)


    Also congratulations! First standalone work, that's awesome! Love the title and the cover and I look forward to getting it.

    Thank you. I appreciate it.

    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.

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (4/23/2012)


    Brandie Tarvin (4/23/2012)


    Hijacking the thread for another book announcement.

    You can read the details on the top post of my Google+ stream here: Legend of the Beemen

    That'll teach...

    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.

  • RE: Are the posted questions getting worse?

    Hijacking the thread for another book announcement.

    You can read the details on the top post of my Google+ stream here: Legend of the Beemen

    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.

  • RE: Bulk Insert works but leave's spaces in data

    Eugene Elutin (4/23/2012)


    Try to drop and recreate destination table with SET ANSI_PADDING OFF, it's still supported in SQL 2012

    Note to OP: If you have data in this table and 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.

  • RE: Trying to trap 1st error in a restore snapshot command

    Why not do a bit of code before the restore in an IF EXISTS type of statement?

    All you have to do is search the sys.databases table where source_database_id 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.

  • RE: Table with 2000 records - Clustered Scan or Index Scan?

    When you say Clustered Scan or Index Scan, as Gail already mentioned, a Clustered Scan is a Clustered Index Scan / Table Scan. You can also have Index Scans on...

    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.

Viewing 15 posts - 4,441 through 4,455 (of 9,722 total)