Forum Replies Created

Viewing 15 posts - 6,211 through 6,225 (of 9,714 total)

  • RE: Are the posted questions getting worse?

    Off-topic Self Promotion!

    A-Kon 22, the biggest Anime convention in the U.S., will be throwing a launch party for The Ladies of Trade Town anthology (edited by Lee Martindale). Why is...

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (3/23/2011)


    Looks like everyone behaved while I was out yesterday. Good job, everyone

    Wait. You mean we could have raised cain and gotten away with it?

    Darnit!

  • RE: R2 problem with SQL Server Agent

    Just tested it. Agent service starts up fine without Browser running. So Browser apparently has nothing to do with the issue.

    I'm thinking it might have to do with some Shared...

  • RE: R2 problem with SQL Server Agent

    <headdesk>

    The reinstall did fix the issue. I just forgot to restart SQL Server Service after enabling TCP / IP.

    Thanks for the assist anyway, Howard. EDIT: And thanks to Steve also.

  • RE: Query Plans. Any way to store, retrieve, and execute?

    KermitTheRock (3/23/2011)


    Yeah, I know it sounds crazy that I want to "avoid" optimization. But if the data and tables and query have not changed from one day to the next,...

  • RE: Replication Question

    If this is an interview question, I second what Dan said. Read up on replication so you can learn enough to get by.

    But if I'd been asked that question...

  • RE: Shrink 1TB SQL 2K - how long should it take?

    The only advice I can give you is to engage PerfMon and either Profiler or a server-side trace to see what (if any) activity is going on.

    It may very well...

  • RE: R2 problem with SQL Server Agent

    HowardW (3/23/2011)


    Can you connect to the named instance from Management Studio on a different machine or does it also get a connection error?

    This is a stand alone laptop. It's not...

  • RE: Shrink 1TB SQL 2K - how long should it take?

    Do you have lots of large data types or images on this database?

  • RE: Restore

    What version of Litespeed?

    How many files are you trying to restore?

    Can you post the script?

    EDIT: Almost forgot to ask, does the restoring box have Litespeed installed?

  • RE: Are the posted questions getting worse?

    Jack Corbett (3/23/2011)


    I'm not going to make the duck tour, but I am planning on getting into Boston somehow for the dinner. I hate driving in any city and...

  • RE: Shrink 1TB SQL 2K - how long should it take?

    You didn't give it a target_size?

    Run SP_WHO2 to see if anything is blocking the process. Double-check the hard drive to make sure it isn't full. Double-check the tempdb (and...

  • RE: Replication Question

    Also, why are they not in synch? Did something break? Was something stopped?

  • RE: Restore

    Are you restoring natively, using the Litespeed console, or using a restore job / script created by Litespeed?

    Are you restoring to the same box that the backup was made on...

  • RE: Shrink 1TB SQL 2K - how long should it take?

    It depends.

    I know that answer blows, but it really does depend.

    1) Database shrinking or File shrinking?

    2) Through the GUI or a DBCC command?

    3) If you used the DBCC command, please...

Viewing 15 posts - 6,211 through 6,225 (of 9,714 total)