Forum Replies Created

Viewing 15 posts - 15,406 through 15,420 (of 49,552 total)

  • RE: Index Partitioning Help

    If you think that partitioning = magic performance improvement, you'll be sorely disappointed. While it can give performance improvements, the queries may have to be rewritten to take advantage 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

    November 30, 2012 at 1:11 pm

    #1564553

  • RE: Materialized View Logs on Log shipped secondary server database

    Not sure I follow what you're trying to do. What do you mean by 'materialized view log'?

    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

    November 30, 2012 at 12:56 pm

    #1564549

  • RE: Index Partitioning Help

    First question...

    Why are you partitioning? What's the reason, what's the goal?

    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

    November 30, 2012 at 12:55 pm

    #1564547

  • RE: log shipping and transaction log

    sdpages (11/30/2012)

    Can these trans log backup files be used in case of Failure and Restore of the server ? Will these trans log backup be used with my Weekly Full...

    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

    November 30, 2012 at 12:50 pm

    #1564543

  • RE: Help On Execution Plan Status

    ScottPletcher (11/30/2012)

    Grant Fritchey (11/30/2012)

    And the indexes have to be selective enough to be useful for a seek or you'll get scans. Same things apply to non-clustered indexes too.

    For lots more...

    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

    November 30, 2012 at 12:49 pm

    #1564540

  • RE: Help On Execution Plan Status

    Seek when there's a SARGable predicate (<column> <comparison operator> <expression>) on the index key columns. Scan if there isn't. Very, very simplified, but that's the basics.

    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

    November 30, 2012 at 8:12 am

    #1564399

  • RE: pages

    SQL Server 2008 Internals by Kalen Delaney

    Paul Randal's blog.

    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

    November 30, 2012 at 6:45 am

    #1564338

  • RE: Does Backup Log break shipping?

    The question then becomes, what's the reason for taking a copy-only log backup.

    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

    November 30, 2012 at 6:00 am

    #1564323

  • RE: pages

    sanket kokane (11/30/2012)

    ScottPletcher (11/29/2012)

    Depends on how many bytes in table, and how long a row is.

    A SQL page is 8K, with 8060 total bytes available for data. Each row...

    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

    November 30, 2012 at 5:44 am

    #1564313

  • RE: Help with query...

    http://www.sqlskills.com/blogs/kimberly/post/A-new-and-improved-sp_helpindex-(jokingly-sp_helpindex8).aspx

    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

    November 30, 2012 at 4:02 am

    #1564253

  • RE: Total newb question

    There is no guest login. If you don't have either a username and password or a windows login granted access to the DB, you cannot log in to SQL.

    There are...

    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

    November 30, 2012 at 3:59 am

    #1564249

  • RE: Suspect mode error

    Highly unlikely to work. SQL can only recreate the log file if the DB was cleanly shut down prior to the log being damaged/lost.

    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

    November 30, 2012 at 12:09 am

    #1564172

  • RE: Unconsistent consistency errors...

    NTesla (11/29/2012)

    Solved.

    RAID array had one black sheep.

    Ah-ha!

    Too bad that the card is so cheap it doesn't give any warning...

    Well there's your motivation for better hardware...

    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

    November 29, 2012 at 1:38 pm

    #1564018

  • RE: Fragmentation and log shipping ??

    Please note: year old thread.

    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

    November 29, 2012 at 1:15 pm

    #1564003

  • RE: Differential backups failing since we started VM

    Something's taking full backups of the DB other than your SQL agent backup jobs. I've seen that with BackupExec, can probably happen with other VDI backups. Whatever they're using 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

    November 29, 2012 at 12:08 pm

    #1563966

Viewing 15 posts - 15,406 through 15,420 (of 49,552 total)