Forum Replies Created

Viewing 15 posts - 7,981 through 7,995 (of 9,720 total)

  • RE: Will SQL Server 2000 run on Win Server 2008 R2?

    wodom (5/4/2010)

    What would it matter how many bits our old version has anyway? I've also been asking what kinds of differences there might be between 32 and 64 bit...

    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.

    May 4, 2010 at 3:26 pm

    #1162133

  • RE: TempDB log growth

    Sorry, I misspoke. I don't run InputBuffer anymore. I have better code now that gives me the entire context of the command instead of just the first X number 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.

    May 4, 2010 at 12:53 pm

    #1162043

  • RE: Will SQL Server 2000 run on Win Server 2008 R2?

    wodom (5/4/2010)

    Brandie Tarvin (5/4/2010)

    He's asking if your SQL 2000 is 64 bit or 32 bit.

    I don't know. Haven't been able to find out. We're supposed to download it from MS....

    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.

    May 4, 2010 at 12:51 pm

    #1162041

  • RE: TempDB log growth

    It doesn't matter what database you're on for the InputBuffer command (and I believe the same for the OpenTran). A SPID is unique in the whole server instance. It should...

    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.

    May 4, 2010 at 12:48 pm

    #1162040

  • RE: Timout expired when logging in from client SSMS

    Another question. Are you querying directly through SSMS or through an application or web service?

    Connection Timeout properties can hide all sorts of places and not all of them 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.

    May 4, 2010 at 11:15 am

    #1161980

  • RE: Where are you?

    tosscrosby (5/4/2010)

    That's why I put the caveat in there about language nuances. I knew what you meant and I'm sure Brandie did too but a newcomer might 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.

    May 4, 2010 at 11:13 am

    #1161978

  • RE: Will SQL Server 2000 run on Win Server 2008 R2?

    He's asking if your SQL 2000 is 64 bit or 32 bit.

    I don't have experience with that version of Windows, but I think I heard that running 32 bit SQL...

    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.

    May 4, 2010 at 11:07 am

    #1161966

  • RE: Where are you?

    tosscrosby (5/4/2010)

    Who? The men in white coats carrying a net?

    Sorry, guys. I'm the one who called the WhiteCoats, but I thought they were going after my local...

    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.

    May 4, 2010 at 8:02 am

    #1161817

  • RE: Where are you?

    Bhuvnesh (5/3/2010)

    I dont understand why we have very few girls in database field ? , i think ROLLBACK doesnt work for them 😀

    There's a joke here I seem 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.

    May 4, 2010 at 6:11 am

    #1161724

  • RE: Different owner on the logshipped database

    Roust_m (5/3/2010)

    Brandie Tarvin (5/3/2010)

    Norecovery isn't going to help you. It'll leave the db in the same state as it is now. "Restoring".

    This is the same. If you specify "norecovery"...

    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.

    May 4, 2010 at 6:09 am

    #1161720

  • RE: Tempdb GROWS

    Sorry, Jason. I'm referring to Gianluca Sartori's post. I should have quoted 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.

    May 3, 2010 at 8:51 am

    #1161321

  • RE: Tempdb GROWS

    You can't rely just on writes, though. Excessive reads could also be causing an issue. Especially if there's a RBAR problem in the query. Bad use of indexing could also...

    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.

    May 3, 2010 at 8:44 am

    #1161311

  • RE: The Cost of Data Loss

    Steve Jones - Editor (5/3/2010)

    However, not being an underground guy, if they offer a tour, I'll send you, Brandie.

    I'll hold you to that. @=)

    It's a neat idea, and...

    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.

    May 3, 2010 at 8:11 am

    #1161291

  • RE: The Cost of Data Loss

    Fidelity happens to be in my neck of the woods, so I found this article very interesting and very sad. It disheartens me to know that the few bad DBA...

    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.

    May 3, 2010 at 5:16 am

    #1161184

  • RE: Tempdb GROWS

    I'd like to know the answer to Jeff's question myself. Please don't take this the wrong way, because we're just trying to help. But you seem to be making an...

    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.

    May 3, 2010 at 4:46 am

    #1161177

Viewing 15 posts - 7,981 through 7,995 (of 9,720 total)