A Temporary Move

  • Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/atemporarymove.asp

  • The link reference from the 3rd article back to the previous second article is malformed.

    Either the web dudes or the author used "move" instead of "moving" where the latter matches the actual article title. Actual link reference s/b ...

    http://www.sqlservercentral.com/columnists/sjones/movingmsdb.asp

    "Dare to augment broken URLs and Ye shall see the page."


    - Bit

  • Thanks, I'll fix this.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

  • why are you guys "repeating" the information from microsoft knowledgebase? this information is documented in the kb article: Q224071

    instead write some more original articles!

    --jamie

  • Sorry you didn't like the article. Pretty much everything we write about is documented somewhere, just not always easy to find and not always clear.

    The point of the article was to give people an easy reference point for performing this action. Hopefully it will stick in someone's mind.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

  • Good set of articles for the newbies! You can also add Size = to resize and make larger if need be. Also you need to go back and delete the old files as they will hang around on disk. I wrote a litle cmd file that stops all the services and does the delete then restarts them back up. Wrote that for fun basically, no purpose when you can do everything from the GUI. Hey if it moves script it.. SQL2000 QA actually says "Delete old file after restarting SQl".

  • Re:

    quote:


    why are you guys "repeating" the information from microsoft knowledgebase? ... instead write some more original articles!

    --jamie


    And Ojamie has written & contributed how many articles to date? Zero.

    Steve, I found your article helpful; esp. since I do not digest 'Q' articles on a regular basis. 'Q' articles rarely present "the view from the trenches" which is often just as helpful if not more than the cut-n-dry Microsoft explanations/excuses. Evidently, some people just expect too much from a free information resource. Keep up the good work, Steve.


    - Bit

  • sorry, if i offended anyone. i am an average dba, and the first place i go to, when i am stuck is books online, next place is kb. if i'm unsuccessful there, then i turn to sites like sqlteam or sqlservercentral. so i hate to see repetitive, duplicate information at sites like these. we don't have to reinvent the wheel. am sure people like steve jones can add value by concentrating on issues that aren't addressed by microsoft or other sites. well, that's just my opinion. sorry again to those who thought it wasn't appropriate

  • One thing I'd urge anyone to consider when asking the question, "Why are you writing an article on something that's already covered in the knowledge base?" is the fact that if an author writes the same content in a different manner, someone who didn't understand the original content might understand based on the second way the information is presented.

    For instance, when I think back to my high school physics curriculum, there were two teachers who taught algebra-based physics: Dr. Clyde Smith and Dr. Taha Mzoughi. Both teachers were teaching from the same book. Both teachers were teaching the same material at the same time. Both teachers were teaching using the same labs. However, some students learned better from the way Dr. Smith presented the material, others learned better from the way Dr. Mzoughi presented material. For me, I pretty much learned well from both as I took Dr. Mzoughi for algebra-based and Dr. Smith for Calculus-based physics (and this is why I went on to maor in Physics and Mathematics in college).

    With that said, there was a time I was having an impossible time understanding a basic concept in Calculus-based physics. Dr. Smith had done a great job teaching it, because the majority of the class wasn't having any issues. He had spent time with me off-line trying to help me get over the hump with understanding the concept.

    Come the day of the test, I still didn't understand it. I had 15 minutes before the exam, so I popped into Dr. Mzoughi's office. He saw the look of worry on my face and asked what's wrong. When I explained what I was having problems with, Dr. Mzoughi spent about 5 or 6 minutes with me working on it. I had spent probably two hours with Dr. Smith outside of class and just didn't get it. I spent less than 10 minutes with Dr. Mzoughi and all was clear. I scored a near perfect score on the test. Without Dr. Mzoughi, I probably would have had a failing result. The second manner of presenting the material made all the difference.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

  • Thanks for the comments. When I wrote this article, I had to dig through information to find out how to do it. By presenting it, I do so for the reasons Brian Kelley mentioned above as well as because it may stick in someone's mind who reads this site. Then when they need it, they'll have two references and two points of view.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply