Forum Replies Created

Viewing 15 posts - 18,661 through 18,675 (of 49,552 total)

  • RE: Does sequence of MDF defrag and index rebuild matter?

    Rich Yarger (5/2/2012)

    Reason I was asking is because the internal array from HP (for which that part makes up 2.8tb of space) apparently did not come with any tools to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 3, 2012 at 2:59 am

    #1482862

  • RE: Does sequence of MDF defrag and index rebuild matter?

    Rich Yarger (5/2/2012)

    Are there any 3rd party tools that you know of which would negate the need for the manufacturer's specific tool?

    Do you want to potentially lose all the data...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2012 at 4:48 pm

    #1482749

  • RE: UPDATE STATISTICS for tables with / as job

    UPDATE STATISTICS aaa.[/AAA/AAA_AA_AAAA] _WA_Sys_00000011_484FE00B

    The job likely doesn't have quoted identifiers enabled.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2012 at 10:29 am

    #1482545

  • RE: Should I convert my non-clustered index into a clustered index

    If the records never get updated, then I would suggest a clustered index on update date, account number. That should be close to ever-increasing, far more than the other way...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2012 at 10:23 am

    #1482539

  • RE: Should I convert my non-clustered index into a clustered index

    I have no argument against creating a clustered index.

    Converting the index to clustered fora single query (or set of queries) is not the best approach, there is only one clustered...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2012 at 9:31 am

    #1482497

  • RE: Should I convert my non-clustered index into a clustered index

    Just include shop_code in the index, I wouldn't make it clustered, doesn't look like a good candidate for a clustered index

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2012 at 7:46 am

    #1482384

  • RE: primary server failed or deleted

    We're not going to give you complete answers to interview questions.

    Seriously, the primary use of log shipping is to protect against failure of the primary server, so if you don't...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2012 at 7:42 am

    #1482382

  • RE: Rebuild index is running a fragmentation query

    Grant Fritchey (5/2/2012)

    GilaMonster (5/2/2012)

    When an index is being rebuilt online, it does not take any1 locks. That means other processes can read the indexes and other processes can run inserts,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2012 at 7:39 am

    #1482377

  • RE: Rebuild index is running a fragmentation query

    When an index is being rebuilt online, it does not take any1 locks. That means other processes can read the indexes and other processes can run inserts, updates and deletes...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2012 at 7:01 am

    #1482344

  • RE: Cluster Index in Inculude Column

    ESAT ERKEC (5/2/2012)

    It is oke but LOGICALREF is an clustered index column i can why it is suggest that?

    Why shouldn't it be suggested?

    If that include is necessary for the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2012 at 6:56 am

    #1482339

  • RE: Database Integrity Check fails after Virtual Server SAN software upgrade, or other reason?

    Please run the following and post the full and complete results

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2012 at 12:49 am

    #1482201

  • RE: Why deadlock is happening here for this case

    Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.

    DBCC TRACEON(1222,-1)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2012 at 12:34 am

    #1482198

  • RE: primary server failed or deleted

    k.subramanyam1017 (5/2/2012)

    Yes friend! in my resume i have put the experience in logshipping. If u dont mind pls tell me that general quesiton if primary server failed or deleted...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 2, 2012 at 12:32 am

    #1482196

  • RE: MSDB Deadlock = Server crawl?

    How long do you need them for (audits, restore scripts, etc)?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 1, 2012 at 2:34 pm

    #1482105

  • RE: MSDB Deadlock = Server crawl?

    Fraggle-805517 (5/1/2012)

    Gila, I tend to agree with you on the Deadlock as not being the issue. However, when I killed the SPID that was deleting the backup history, and...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 1, 2012 at 1:36 pm

    #1482080

Viewing 15 posts - 18,661 through 18,675 (of 49,552 total)