Forum Replies Created

Viewing 15 posts - 16 through 30 (of 79 total)

  • RE: upgrading from 2000 enterprise to 2005 standard

    ron morgan (7/20/2010)


    I am upgrading my 2 node cluster. since i cannot go from 2000 ent to 2005 standard just want to know which option are best to get to...

  • RE: Striped backup filenames in maintenance plan

    Sherri Barkley (7/15/2010)


    I am a rookie DBA and I have a large database that I need to stripe the backup to improve backup performance/file size. What I am trying...

  • RE: Sql Server Memory Issue

    ashaaban (7/20/2010)


    Hi

    My company has 20 Access databases that are connected to sql server 2008 through ODBC. There are about 20 different databases. The problem that I am having is that...

  • RE: How to decrease the size mdf & ldf file while restoring

    [font="Courier New"]In our environment, we have to keep many development efforts/projects at the same time. Some projects are deployed quickly while others are kept for a while and keeping the...

  • RE: Turn on CHECKSUM after an upgrade

    [font="Courier New"]

    S.K. (7/19/2010)


    Per Paul Randal (unfortunately don't have a link handy), a DBCC CHECKDB([dbname]) WITH DATA_PURITY should be ran in order to get the checksum fully implemented after the upgrade...

  • RE: Procedure Cache Hit Ratio -

    tran008 (7/19/2010)


    We have a sql server with 2.0g of RAM for collecting small amount of data daily. Monitoring the Procedure Cache Hit Ratio, the counter is around 82%~89%. However according...

  • RE: How to change CDC automatic cleanup process?

    Paul,

    yep, thats an oversight and will update my earlier post. You could use sys.sp_cdc_change_job to specify the retention time. Jonathan Kehayias also confirmed this.

    [ @retention ] =retention

    Number of minutes that...

  • RE: How to change CDC automatic cleanup process?

    [font="Courier New"]

    EDIT:

    You could use sys.sp_cdc_change_job sp to change the retention using @retention paramter.

    [ @retention ] =retention

    Number of minutes that change rows are to be retained in change tables. retention is...

  • RE: DATE AND TIME Datatypes storage

    Simple answer is, you may have to rebuild the clustered index on this table until then space won't be released. I have some sample code and some DBCC PAGE commands...

  • RE: Memory Usage

    angiepimentel 1403 (7/15/2010)


    How do you measure the memusage in Sysprocesses table? How many KB in memusage because that is described as Number of pages in the

    ...

  • RE: ALTER

    [font="Courier New"]I am glad this QoD has helped people learn new things. The credit should directly go to Hugo Kornelis for his excellent feedback otherwise this would have been an...

  • RE: Maintenance Plan - Backup with checksum?

    beppe_30 (6/21/2010)


    We are in the process of upgrading our SQL 2K to SQL 2K8.

    We would like to use Maintenance Plan to backup our databases but we also want to use...

  • RE: Maintenance Plan not deleteing old backup files

    BigSam (6/19/2010)


    I have Maintenance Plans for groups of my databases: System, User & Management databases. Each of these have backup jobs that have the 'Create a sub-directory for each database'...

  • RE: Restore database 2008 to 2005

    honey47 (7/9/2010)


    Hi ,

    i m currently running database server 2008 , but due to some reason i want to switch to sql 2005. but i am enable to restore my date...

  • RE: ALTER

    [font="Courier New"]Going thru the comments, it seems NOT everyone is aware that NOT NULL clause is necessary when altering the column. It’s a simple fact but not everyone knows about...

Viewing 15 posts - 16 through 30 (of 79 total)