Forum Replies Created

Viewing 15 posts - 4,771 through 4,785 (of 9,715 total)

  • RE: Store procedure

    Krasavita (1/27/2012)


    I have a lot of sp and I want provide access to all sp with execute,is there way to select all of them at the same time or 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.

  • RE: Are the posted questions getting worse?

    GSquared (1/27/2012)


    Brandie Tarvin (1/27/2012)


    So, question of the day. How do you help people who refuse to be helped? People who are resistant to your suggestions of "test it" or "try...

    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: Combining Simple Count Queries

    frfernan (1/27/2012)


    trying to understand and domain some code is like trying to map a room in the dark, extending the hand and discovering a needle because it hurts.

    That 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: Effect of Clustered Index Updates

    If your updates are going to cause a lot of fragmentation, and frequent fragmentation at that, then it is advised you check your database maintenance jobs and verify you are...

    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: Store procedure

    I should mention that my response before the edit was completely predicated on the fact that I totally missed the comment "run sp" in the original post. I saw "update...

    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: Effect of Clustered Index Updates

    An UPDATE statement really doesn't have any effect except to alter the pointer information and possibly split your index leaves or fragment the indexes (if this causes them to be...

    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: Log Shipping

    If the log files are corrupted, chances are that they are corrupted when they are being taken, not when they are being received on the log shipping side.

    But this 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: Effect of Clustered Index Updates

    I'm still a little iffy on my sum-total index knowledge, but AFAIK the answer is "no." Updating a clustered index updates the data rows, but does not update the leaf...

    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: Store procedure

    FYI: You might want to update the title of this thread to properly reflect your issue, which is security questions.

    Look up Books Online for fixed database roles. Read and Write...

    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?

    Kiara (1/27/2012)


    Evil Kraig F (1/27/2012)


    Roy Ernest (1/26/2012)


    Somebody please put the brakes on the THREAD. It keeps moving from one random topic to another. It does not even care who gets...

    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: email excel file using sp_send_dbmail

    Be very careful sending excel files through the mail. They tend to be too large for most people to send or receive.

    You can either zip the file and send...

    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: Combining Simple Count Queries

    Careful, Francesc. You're making assumptions of foreign key relations based on names that could or could not have anything to do with the actual UserID. I've seen a lot of...

    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: What is a flat table?

    deepikamm (1/27/2012)


    Thank you so much for explaining the concept in an understandable manner.:-).

    You are welcome. I hope it helps you avoid them. @=)

    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 Server Agent Service error

    Is SQL Server Service started? If not, I'd also check your disk drives to make sure they aren't full.

    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?

    So, question of the day. How do you help people who refuse to be helped? People who are resistant to your suggestions of "test it" or "try this".

    I'm talking forum...

    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,771 through 4,785 (of 9,715 total)