Forum Replies Created

Viewing 15 posts - 2,941 through 2,955 (of 9,720 total)

  • RE: Are the posted questions getting worse?

    Sean Lange (1/20/2015)

    We are finally starting to move our ERP to a new system (well new to us but still rather antiquated). In the process of looking at vendors our...

    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 20, 2015 at 11:19 am

    #1771556

  • RE: Database growth calculations & Shrinking DBs

    Gazareth (1/20/2015)

    Oh, forgot - autogrowth events can be found in the default trace...

    Which sounds familiar and makes me think this might have been the thing I was racking my brain...

    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 20, 2015 at 8:32 am

    #1771477

  • RE: Database growth calculations & Shrinking DBs

    Gazareth (1/20/2015)

    I use a powershell script (happy to share if you want to try it) to grab weekly db/filesizes and store them in a db table but obviously you'd need...

    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 20, 2015 at 8:31 am

    #1771476

  • RE: Are the posted questions getting worse?

    GAH. Talk about a "drain bramage" kind of day. I knew the answer to this once, but my head just cannot seem to come up with the answer today. 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.

    January 20, 2015 at 6:41 am

    #1771428

  • RE: Are the posted questions getting worse?

    GilaMonster (1/19/2015)

    Well this is fun.

    Officially, according to the government, South Africa uses the , as the decimal point. In reality, everyone, including the government, uses the .

    Windows 7, when used...

    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 20, 2015 at 5:50 am

    #1771413

  • RE: Are the posted questions getting worse?

    WayneS (1/18/2015)

    I'm curious...

    How many folks have a home lab set up with servers?

    I used to. I need to set one up again.

    How many folks just use virtual machines 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.

    January 20, 2015 at 5:46 am

    #1771411

  • RE: Are the posted questions getting worse?

    Ed Wagner (1/16/2015)

    Brandie Tarvin (1/16/2015)

    GilaMonster (1/15/2015)

    Sean Lange (1/15/2015)

    I am having a discussion with somebody who swears that using

    EXISTS(select 1

    is way faster than just select *. I know Gail has...

    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, 2015 at 5:39 am

    #1770721

  • RE: Are the posted questions getting worse?

    GilaMonster (1/15/2015)

    Sean Lange (1/15/2015)

    I am having a discussion with somebody who swears that using

    EXISTS(select 1

    is way faster than just select *. I know Gail has an article on her...

    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, 2015 at 5:32 am

    #1770719

  • RE: Are the posted questions getting worse?

    Sean Lange (1/15/2015)

    I am having a discussion with somebody who swears that using

    EXISTS(select 1

    is way faster than just select *. I know Gail has an article on her blog...

    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 15, 2015 at 12:18 pm

    #1770538

  • RE: Exam 70-461 question

    Ohhh. I shall take a look. Thank you for the reference.

    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 15, 2015 at 5:11 am

    #1770411

  • RE: SQL query to check log shipping error

    Peter2012 (1/13/2015)

    Hi Brandie,

    Thank you for your response.

    Those errors are coming from SQL logs, so there should a way to extract them using SQL query. This is what I'm looking for.

    So...

    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 15, 2015 at 5:01 am

    #1770406

  • RE: Execute SQL task issue

    I am positive that you are trying to squeeze too much data into the variable, but I cannot find anything on the internet that indicates how much data an object...

    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 15, 2015 at 4:56 am

    #1770405

  • RE: Are the posted questions getting worse?

    Luis Cazares (1/14/2015)

    Brandie Tarvin (1/14/2015)

    Koen Verbeeck (1/14/2015)

    Luis Cazares (1/14/2015)

    Congratulations Koen! When I grow up I want to be like you. :hehe:

    Action figures will soon be available! 😎

    With or without superhero...

    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 15, 2015 at 4:47 am

    #1770398

  • RE: Exam 70-461 question

    Koen Verbeeck (1/14/2015)

    Make sure you have a good grip on the new window functions introduced in SQL 2012.

    And you know, for some reason MS still likes to ask XML related...

    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 15, 2015 at 4:44 am

    #1770396

  • RE: Users&Roles for all db's

    I'm glad you found something you could work with.

    Happy coding. @=)

    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 15, 2015 at 4:37 am

    #1770391

Viewing 15 posts - 2,941 through 2,955 (of 9,720 total)