Forum Replies Created

Viewing 15 posts - 46 through 60 (of 490 total)

  • RE: DBCC Check

    apply the service pack 4 for SQL Server 2005 and then rebuild the currupt indexes once again

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

    June 29, 2011 at 4:11 am

    #1345772

  • RE: Searching with like operator(billions of rows)

    Filter Index

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

    June 29, 2011 at 4:06 am

    #1345771

  • RE: Adding Index, reduces reads, but increases duration, CPU

    Index Fill Factor ?

    is this table is read extensive or dml extensive ?

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

    June 29, 2011 at 4:03 am

    #1345769

  • RE: Can I set the page size of sql server.

    Visit on these mentioned below links

    Heading 'Large Row Support'

    http://msdn.microsoft.com/en-us/library/ms190969.aspx

    Heading 'Row Overflow Considerations'

    http://msdn.microsoft.com/en-us/library/ms186981(v=SQL.90).aspx

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

    June 29, 2011 at 2:34 am

    #1345719

  • RE: Data Archiviing

    1-Identity the transaction tables

    2-Identity the relationships of tables

    You should write store procedure for each table and in each store procedure you will write a transaction its depend upon you how...

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

    June 29, 2011 at 2:17 am

    #1345708

  • RE: New DBA resuming in a financial org.....

    you must be associate DBA and not then you should study alots of stuff

    do you have any expierence as a DBA?

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

    June 28, 2011 at 10:33 am

    #1345324

  • RE: Add replication Feature to an already installed SQL 2008 R2 Cluster

    Yes first add on the passive node and then move cluster on the passive node this will convert on active node then do same as on the second passive node

    take...

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

    June 28, 2011 at 5:27 am

    #1345087

  • RE: Sql job

    Execute the job and check the locks on the tables which those are using in this job and check the status of this job with the help of this query

    SELECT...

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

    June 28, 2011 at 5:16 am

    #1345080

  • RE: Add replication Feature to an already installed SQL 2008 R2 Cluster

    yes you can add this feature in the current installed SQL Server Cluster installation

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

    June 28, 2011 at 5:12 am

    #1345074

  • RE: PRECAUTIONS TO BE TAKEN FOR DATABASE BEFORE REBUILDING INDEX

    Yes

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

    June 28, 2011 at 4:04 am

    #1345043

  • RE: How to get Windows login Name

    User connect the Terminal server first with the windows login and then connect the SQL server with SA how its possible ,it will show SA because users connectiing the SQL...

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

    June 28, 2011 at 3:09 am

    #1345023

  • RE: PRECAUTIONS TO BE TAKEN FOR DATABASE BEFORE REBUILDING INDEX

    consider Backup also

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

    June 28, 2011 at 3:03 am

    #1345020

  • RE: SA Password Recovery

    sp_help_revlogin recovery store procedure is available by microsoft

    visit this link and get the required userid password with the help of this script

    http://support.microsoft.com/kb/246133

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

    June 28, 2011 at 3:02 am

    #1345019

  • RE: Agent Disabled and Database is in Inrecovery mode

    find the recovery process is running in the backupground,you can get the percentage of recovered database with the help of SQL Logs

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

    June 28, 2011 at 2:56 am

    #1345017

  • RE: Copy Only restore taking really long time

    Copy_Only option is available for the Backup without interrupt the database backup chain

    Example

    1-Full Backup without copy_only option

    2-Full Backup with Copy_only Option

    3-Differential Backup

    Then you will restore the first full backup without...

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

    June 28, 2011 at 2:48 am

    #1345014

Viewing 15 posts - 46 through 60 (of 490 total)