Forum Replies Created

Viewing 15 posts - 7,741 through 7,755 (of 9,715 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/5/2010)

    Well, getting really short here, tomorrow is my last day with my current employer!

    Wish me luck!!

    ACK! Lynn has Shorttimers Disease!

    Much luck on your new position. @=)

    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.

    August 6, 2010 at 4:26 am

    #1203360

  • RE: Performance Issue in Insert Values

    In addition to the index problem, having 100 columns in a table just by itself will cause performance problems. I have to wonder how many times a single record 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.

    August 6, 2010 at 4:24 am

    #1203356

  • RE: Are the posted questions getting worse?

    Chris Morris-439714 (8/5/2010)

    Jack Corbett (8/5/2010)

    ...

    Where you place the criteria for OUTER JOIN's DOES make a difference. Whenever you place criteria in the WHERE clause that references a column in...

    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.

    August 5, 2010 at 8:13 am

    #1202773

  • RE: Are the posted questions getting worse?

    Chris Morris-439714 (8/5/2010)

    What creeps me out is when I left-join a child table to a parent, then inner join child to a grandchild, with no reference to either 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.

    August 5, 2010 at 8:11 am

    #1202768

  • RE: Today's Random Word!

    Ice

    Twenty minutes on, twenty minutes off. Repeat about three times.

    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.

    August 5, 2010 at 7:51 am

    #1202749

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/5/2010)

    uh, Steve, DBCC Timewarp is acting up or something.

    Maybe you need to clear the warp cache on your local machine. It seems to be working just fine...

    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.

    August 5, 2010 at 7:49 am

    #1202746

  • RE: Sql Managementstudio

    Apparently, other people have had problems with that .DLL and sometimes it's related to the .Net Framework.

    Check this link for more details.

    Also, google "Faulting application sqlwb.exe". There are a ton...

    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.

    August 5, 2010 at 7:31 am

    #1202729

  • RE: Buffer Pool information/usage

    Pam,

    Thank you for posting that resolution. It definitely is helpful as I did not know that could be a problem.

    Glad you got it resolved. (Assuming you did get him...

    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.

    August 5, 2010 at 7:25 am

    #1202722

  • RE: Are the posted questions getting worse?

    jcrawf02 (8/5/2010)

    Brandie Tarvin (8/4/2010)

    Jack Corbett (8/4/2010)

    Probably the most complex SQL I've had to write. Too many OUTER JOINs (business requires this design), and then parameters that could turn...

    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.

    August 5, 2010 at 7:21 am

    #1202715

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (8/2/2010)

    In case anyone needs a humorous break: http://www.youtube.com/watch?v=KiFKm6l5-vE

    I was finally able to watch that last night. Reminds me of some of my end users. @=)

    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.

    August 5, 2010 at 7:07 am

    #1202704

  • RE: Are the posted questions getting worse?

    Alvin Ramard (8/4/2010)

    Excuse me boss, can I leave a few minutes early so I can get back to work on time? 😛

    ROTFLMAO

    Stop spying on my workplace!

    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.

    August 4, 2010 at 11:53 am

    #1202265

  • RE: Are the posted questions getting worse?

    Jack Corbett (8/4/2010)

    The problem in this case is that I do need the INNER JOIN conversion because without it I'd get rows I don't want, but there are rows 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.

    August 4, 2010 at 11:39 am

    #1202251

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/4/2010)

    Actually, this would probably be good material for an article. :smooooth:

    Uh-huh. Sounds to me like you're trying to get Jack to write an article so that 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.

    August 4, 2010 at 11:03 am

    #1202223

  • RE: Monitoring Tempdb - Does this script help? Please advice

    iqtedar (8/4/2010)

    did anyone look at the script and see if it helps?

    No. Partially because you didn't include create scripts for your tables so that I could actually test it. @=)

    But...

    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.

    August 4, 2010 at 10:54 am

    #1202212

  • RE: Maintenance Plan Errors

    Chances are you were having network troubles when the job tried to complete. It could have been anything from noise to inaccessibility. Try the job again, while you're sure 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.

    August 4, 2010 at 10:49 am

    #1202209

Viewing 15 posts - 7,741 through 7,755 (of 9,715 total)