Post reply

do you need to take take server offline to backup, what is point of attaching and detaching?

  • November 16, 2005 at 4:27 pm

    #166343

     

    Do you need to take take server offline to backup, what is point of attaching and detaching?

     

    thanks you

     

  • November 21, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • November 21, 2005 at 11:31 am

    #605026

    You don't need to take a database offline to back it up.

    Attaching/detaching: allows to copy the mdf/ldf files.

  • November 21, 2005 at 12:19 pm

    #605044

    thanks , this leads me a couple of questions.

     

    what exactly are cursor used for?

     

     

    which template in profiler best for this situation?

     

    Are views just in emeory or are they , the data not just the query code, written to the hard drive.

     

    yes, I will start with the profiler, thanks!!

  • November 21, 2005 at 2:54 pm

    #605081

    1) cursors are mostly used as last resorts (because they are such a performance drain on the server) to implement complex logic. Beginners tend to use them also because it looks familiar with the loop programming in vb, c, etc

    2)Depends on what you are profiling for

    3)View are "virtual" tables, there is no extra data stored except if you start indexing them.

  • November 21, 2005 at 4:17 pm

    #605096

    so to say a view is a table only in ram is correct, the virtual table is NOT written to the hard drive, accept maybe in cases of swap file for pagging.

     

     

    so views are rerun everytime they are called upon(with would explain why is take more time to query a view than a base table?)?

     

    thanks for helping me clear up confusion in my head!!

Viewing 6 posts - 1 through 5 (of 5 total)

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