Forum Replies Created

Viewing 15 posts - 3,136 through 3,150 (of 9,715 total)

  • RE: Prevent RENAME of a database

    Igor Micev (8/15/2014)


    ...this is the code

    ALTER TRIGGER ddl_trig_REname

    ON ALL SERVER

    FOR RENAME

    AS

    BEGIN

    DECLARE @data XML;

    DECLARE @database nvarchar(100);

    DECLARE @eventType varchar(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: Add a total column

    M Joomun (8/18/2014)


    Hello both,

    Thanks for your replies.

    As to the table schema, tblPerson - tblManagementOfBleeding is a 1 ~ 1. I've attached screenshots which give more detail. Do you need anything...

    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: System Tables for Database Mirroring

    Beatrix Kiddo (8/18/2014)


    Ah, you beat me to it! I finally knew something, too :-D.

    I appreciate the thought. @=)

    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: Add a total column

    Without DDL and sample data, here's my first thought:

    SELECT YearRecruited, Hospital, Jan, Feb, Mar, Apr, May,

    Jun, Jul, Aug, Sep, Oct, Nov, Dec, MyCounter,

    (Jan + Feb + Mar +...

    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: Backup SQL settings?

    Copied is good. Let us know if you need any additional fodder to help with your case for a more robust solution.

    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: System Tables for Database Mirroring

    Nevermind. Finally found a link with them listed.

    sys.database_mirroring

    sys.database_mirroring_endpoints

    sys.database_mirroring_witnesses

    sys.dm_db_mirroring_connections

    Thanks anyway.

    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: Backup SQL settings?

    dstoltz 35443 (8/18/2014)


    Thanks everyone - unfortunately, we don't have a DR site, or even a DR server...we have a 4 hour response time support to get the server fixed if...

    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: Sleeping Log Reader Agent blocking Distribution clean up job

    First, let's try approaching this problem as if it has nothing to do with the VLFs issue, okay?

    What is the schedule (if any) of your snapshot agent?

    How big are your...

    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: Compare two columns

    So did Tom answer your question, then?

    If so, please mark his post as the solution. If not, please post again and tell us why it didn't work for 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.

  • RE: SQL DBA high ended question (5+ years’ experience)

    Jeff Moden (8/16/2014)


    Evil Kraig F (8/15/2014)


    Brandie Tarvin (8/15/2014)


    It's Wednesday. 3 people walk up to your cube. One is from the QA team, one is from the reporting team, and one...

    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: SQL DBA high ended question (5+ years’ experience)

    GilaMonster (8/15/2014)


    Evil Kraig F (8/15/2014)


    Is it bad that my first question is to the reporting team guy: "Which reports, and what's their SLA's?" while asking the QA person to email...

    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: SQL DBA high ended question (5+ years’ experience)

    Evil Kraig F (8/15/2014)


    Brandie Tarvin (8/15/2014)


    It's Wednesday. 3 people walk up to your cube. One is from the QA team, one is from the reporting team, and one is 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.

  • RE: SQL DBA high ended question (5+ years’ experience)

    I'm thinking about the original post and I think I'd ask questions like this:

    It's Wednesday. 3 people walk up to your cube. One is from the QA team, one 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: SQL DBA high ended question (5+ years’ experience)

    GilaMonster (8/11/2014)


    paul.knibbs (8/11/2014)


    Jeff Moden (8/9/2014)

    With the understanding you have of that counting problem and the additional understanding that I don't ask "trick" questions or questions based on trivia, explain or...

    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: How to connect to SQL server named instance on a static port

    Have you tried connecting to SQL without the ",<portnumber>" yet?

    At my workplace, we had an issue way back when where the port number was required until our networking team fixed...

    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 - 3,136 through 3,150 (of 9,715 total)