Forum Replies Created

Viewing 15 posts - 30,076 through 30,090 (of 39,763 total)

  • RE: Just passed. My steps to passing 70-431 ( no exam spoilers, dont worry!)

    If I remember right, it was about 35-37 questions, multiple choice and then 10-15 simulations.

  • RE: major production issue

    It's possible that other activity was slowing the rollback, or that something was hung.

    Restarting means that it can roll forward/back without anyone else trying to read/write to the system, so...

  • RE: tempdb growing and not main database

    You must have some open transaction in tempdb that is holding space. It should be in simple mode and truncate itself (log) every few minutes. If tempdb is growing constantly,...

  • RE: Add to Briefcase feature to forums

    We've talked about it and we hesitate to change the forum code too much. Makes upgrading hard.

    I'll add this to the list and maybe there's a way that we can...

  • RE: Data corruption on a Database

    Forum moved and please try to post only what you think is relevant. We don't necessarily need to see the whole log.

  • RE: do DBAS need local system admin privileges? and why?

    I agree things move slowly and if you page out the Windows guy a few times at night, things might change. Or if you don't get a db working fast...

  • RE: T-Log backup question

    No differences between Truncate on checkpoint and simple I know of. The former is older syntax.

    I agree with Michael, I'd run more frequent log backups and then add in another...

  • RE: SSMS Tricks

    The only advantage for QA that I've seen is that it's quick and starts immediately. I don't need to spend time waiting on SSMS to start up, eat system resources,...

  • RE: sql server 2000 to sql server 2005

    Look on the MS site for new things. Most things should be backwards compatible from the T-SQL side.

  • RE: ODBC Connection does not accept 'local'

    No idea, but please post in the appropriate forum. (this has been moved).

  • RE: Database backups best practice

    Full and diff backups don't use truncate.

    The backup scheme depends on what works for your business. If they can tolerate finding a full, then a diff, then a ton of...

  • RE: Attaching AdventureWorks.mdf

    Is that path correct?

    If so, it sounds like you have a corrupt download. Get the real one from Microsoft.

  • RE: The December Energy Update

    I'm not sure about the Ethanol, but I tend to agree that we can't blindly switch from food to fuel. It would be better to mandate some type of percentage...

  • RE: The December Energy Update

    They already are squawking. The new Energy Act passed, just as I was publishing this. I'll comment more in the Feb update, but the solar and wind subsidies were removed....

  • RE: Permission Issue

    My apology for the confusion. Actaully I wanted to mention that we cann't allow it to run as Local Admin. It's running as Local Admin.

    That doesn't make sense? It's Which...

Viewing 15 posts - 30,076 through 30,090 (of 39,763 total)