Forum Replies Created

Viewing 15 posts - 3,301 through 3,315 (of 9,725 total)

  • RE: Activity Monitor Waiting Resource question

    Well, it's MS Access actually. We have linked tables and macros pulling data but we're about to retire a server and move to a new one. So the process works...

    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.

    January 16, 2014 at 12:18 pm

    #1680817

  • RE: subscription owner change

    Given that the service account should be in sysusers, and that page you referenced updates based on userID, I would say that yes, you can do exactly what you're thinking...

    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.

    January 16, 2014 at 4:48 am

    #1680592

  • RE: Process Monitor Program_Name question

    John Mitchell-245523 (1/10/2014)

    Brandie

    Could the second one be from Object Explorer or similar? I think you get the third for linked server queries.

    John

    I did notice that Object Explorer and 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.

    January 10, 2014 at 6:28 am

    #1679131

  • RE: Process Monitor Program_Name question

    GAH. Dup post...

    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.

    January 10, 2014 at 6:24 am

    #1679128

  • RE: Process Monitor Program_Name question

    Lowell (1/10/2014)

    I believe there was another recent thread that said scheduled jobs that are executing use "Microsoft SQL Server Management Studio", i believe, which was very misleading, since it's not...

    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.

    January 10, 2014 at 6:09 am

    #1679124

  • RE: how to deal with growing tempdb data and log files

    To add to what Gail said, the ONLY 2 reasons you should consider shrinking TempDB would be:

    1) A runaway query that has caused TempDB to grow exponentially beyond the usual...

    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.

    January 10, 2014 at 5:46 am

    #1679112

  • RE: Restoring from broken backup chain

    Differential base... And so I learn a new term (that I arguably should have know before this).

    Thank you again, Gail. You are a star.

    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.

    December 19, 2013 at 11:26 am

    #1674936

  • RE: Restoring from broken backup chain

    GilaMonster (12/19/2013)

    Full backups do not break the log chain. Differential backups do not break the log chain

    I know that. The chain that was broken was between the differential and 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.

    December 19, 2013 at 10:58 am

    #1674932

  • RE: SQLServerCentral apologizes and you can win a book

    jk_in_San_Diego (12/5/2013)

    Once upon a time, in the dark ages of printed textbooks and such, plagarism was not only frowned upon, it was cause for immediate dismissal or expulsion from university.

    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.

    December 11, 2013 at 5:32 am

    #1672582

  • RE: SQLServerCentral apologizes and you can win a book

    Samuel Vella (12/5/2013)

    Brandie Tarvin (12/5/2013)

    One thing most people don't realize is that quoting an author's work, and attributing it properly, might not be plagiarism but it is still copyright infringement....

    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.

    December 5, 2013 at 7:00 am

    #1671063

  • RE: SQLServerCentral apologizes and you can win a book

    jsimancas (12/5/2013)

    SELECT

    [PlagiarizedArticle] AS oversite

    ,rank() OVER (partition by [Ben-Gan].public.Apology)

    FROM SQLServerCentral

    Result:

    ||Hope all is forgiven...here's your free book by author.||

    HA! I like this 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.

    December 5, 2013 at 6:22 am

    #1671038

  • RE: SQLServerCentral apologizes and you can win a book

    j.zinn (12/5/2013)

    I'm just really impressed by the reaction that this site had to content that was lifted without attribution. A quick, scholarly reaction. I hope that Mr. Ben-Gan appreciated 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.

    December 5, 2013 at 6:20 am

    #1671036

  • RE: SQLServerCentral apologizes and you can win a book

    One thing most people don't realize is that quoting an author's work, and attributing it properly, might not be plagiarism but it is still copyright infringement. Microsoft gives a certain...

    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.

    December 5, 2013 at 5:09 am

    #1671001

  • RE: Can someone translate this restore error?

    Having used Litespeed before I know it wouldn't help with this backup because it's a native SQL backup.

    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 1, 2013 at 6:57 am

    #1663396

  • RE: Can someone translate this restore error?

    MyPath is a SAN drive on another server. I'd love to copy the backup file over to the server that I'm going to be restoring to, but I don't have...

    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 31, 2013 at 10:44 am

    #1663183

Viewing 15 posts - 3,301 through 3,315 (of 9,725 total)