Forum Replies Created

Viewing 15 posts - 11,956 through 11,970 (of 39,909 total)

  • RE: It's not you; it's us

    Good job, Gail, and I'm sorry for you, the current MCMs, and those that are studying for the certification now. It's poor treatment, and a bumbling way of handling the...

  • RE: How to tell if instance is MSDN licenced or not

    I'm not sure there's an easy way. I saw someone say if a productID wasn't entered, it's MSDN, but I think that's changed.

    Ultimately, I'm not sure it matters. The licensing...

  • RE: database in simple mode with growing log file into the GBytes

    I'd listen to Hanshi.

    The definition of insanity is doing the same thing over and over, but expecting something different.

    Why shrink the space if you need it again soon? You don't...

  • RE: Is there any way to turn of parsing?

    Pedro's method would be the only thing. The script itself needs to be parsed in order to generate a plan, and it can't do it if the columns don't exist....

  • RE: Microsoft Certified Master

    Vedran Kesegic (9/4/2013)


    I got the mail starting with "Congratulations!". Passing the lab exam from the first attempt and receiving so wanted MCM certificate makes me very happy! I will celebrate,...

  • RE: Difference Between Restore And Attach

    In practice, a restore typically has .bak, .trn., and .dif files. The attach usually has .mdf, .ldf, and .ndf files.

  • RE: SQL 2000 Install

    I understood you, but probably didn't explain myself well.

    I think that you can install SS2K as an instance on a machine with SS2K8 already as a default or named instance....

  • RE: SQL Server Full to Simple to Full Recovery Model

    Read Gail's article and then set up log backups to manage your recovery. you can shrink the log file if you need to recover the space, but if you...

  • RE: Adding Indexes produces faster execution times, but not the numbers to support it

    You are welcome, but the important thing to note is this is an ongoing, evolutionary process. It's not a set it and forget it, or a single session.

    Go slow, change...

  • RE: Are the posted questions getting worse?

    GilaMonster (9/3/2013)


    Steve Jones - SSC Editor (9/3/2013)


    ... but didn't have the 10 years of SQL Server admin work.

    I don't.

    I have about 8 years experience designing, developing and tuning SQL Server....

  • RE: Are the posted questions getting worse?

    ChrisM@Work (9/3/2013)


    Thanks Tom. I voted in favour of keeping the program.

    It's the only MS cert I know of for sure which can't be cheated.

    Yet. It can't be cheated yet....

  • RE: Are the posted questions getting worse?

    GilaMonster (9/2/2013)


    SQLRNNR (9/2/2013)


    Koen Verbeeck (9/1/2013)


    GilaMonster (8/31/2013)


    Just ....

    Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams as of October 1,...

  • RE: unable to connect to server

    It looks like you have issues on your H: drive. SQL Server is just reporting issues from the OS when it tries to access the file, just as you'd receive...

  • RE: AAG Backup

    Grant Fritchey (9/3/2013)


    You must use COPY_ONLY when backing up a database on a secondary server. When backing up a database on the primary you can run a regular backup, or...

  • RE: Two languages for full text search.

    Yes, but you need a union query. Each FTS query is single language. Use two with the LCID for each, joined by a UNION.

Viewing 15 posts - 11,956 through 11,970 (of 39,909 total)