Forum Replies Created

Viewing 15 posts - 26,746 through 26,760 (of 49,552 total)

  • RE: Which index run first Clustered index or Non_Clustered index

    What do you mean 'run first'?

    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

    April 13, 2011 at 3:25 am

    #1310881

  • RE: Recover database from suspect Mode

    Ratheesh.K.Nair (4/13/2011)

    Thanks Gail,

    Our onsite team is doing the restore between i have a doubt,Is it a problem if any job try to access the table or that particular database while...

    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

    April 13, 2011 at 3:23 am

    #1310880

  • RE: serious memory issue - i am totally lost - please help

    Do not use task manager to check SQL's memory usage. It does not show accurate values if you are using locked pages, as the post that Nils referenced explains.

    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

    April 13, 2011 at 2:47 am

    #1310857

  • RE: Recover database from suspect Mode

    shiv-356842 (4/13/2011)

    Can you restore a damage page using below script...

    RESTORE DATABASE dbccpagetest PAGE = '58' FROM DISK = 'C:\dbccpagetest.bak';

    after that restore your database..

    -- Need to complete roll forward. Backup 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

    April 13, 2011 at 2:29 am

    #1310852

  • RE: Who's afraid of Gila Monsters?

    *Hiss*

    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

    April 13, 2011 at 2:27 am

    #1310850

  • RE: SQL on insert trigger won't react if data is updated from SSIS package

    Bulk operations do not by default fire triggers (see Books Online for documentation on that point)

    You need to add the option FIRE_TRIGGERS to the OLEDB destination. It may degrade performance.

    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

    April 13, 2011 at 2:25 am

    #1310848

  • RE: Database size estimation

    File size includes free space in the DB. Backup size does not.

    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

    April 13, 2011 at 12:08 am

    #1310810

  • RE: Performance Issue

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    April 13, 2011 at 12:08 am

    #1310809

  • RE: Database become recovery status

    Because SQL has to do crash recovery (google the term) to ensure that any committed transactions whose changes had not been hardened into the data file at the time of...

    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

    April 13, 2011 at 12:07 am

    #1310807

  • RE: Reseed Identitity column

    There is, but the problem is that it's a complete reseed, so it will insert 3 for the next row, then try to insert 4 and give you either a...

    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

    April 12, 2011 at 11:47 pm

    #1310802

  • RE: Are the posted questions getting worse?

    jcrawf02 (4/12/2011)

    Even when I know what's going on, I'm confused.

    How do you think I feel? :hehe:

    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

    April 12, 2011 at 3:38 pm

    #1310730

  • RE: SQL Server 2005 indexed view for non-unique column

    Lowell (4/12/2011)

    a clustered index does not have to be unique. it just stores the data in the order of the index for the fastest retrieval of the data.

    However the first...

    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

    April 12, 2011 at 3:22 pm

    #1310722

  • RE: SQL Server 2008 Ent R2 64bit will not use all available memory

    How are you monitoring the memory used?

    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

    April 12, 2011 at 3:11 pm

    #1310718

  • RE: Are the posted questions getting worse?

    WayneS (4/12/2011)

    Jack Corbett (4/12/2011)

    I'm sure y'all already know, but today is the last day of $299 price for SQLRally. Goes up to $349 tomorrow and then $399 May 1st....

    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

    April 12, 2011 at 2:39 pm

    #1310703

  • RE: Are the posted questions getting worse?

    Speaking of QotD, I thought up a nice followup for that question on page checksums. On when TDE is applied to a page.

    Now, when am I going to find 5...

    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

    April 12, 2011 at 9:33 am

    #1310467

Viewing 15 posts - 26,746 through 26,760 (of 49,552 total)