Forum Replies Created

Viewing 15 posts - 27,121 through 27,135 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    jcrawf02 (3/24/2011)

    GilaMonster (3/24/2011)

    The first couple movies were OK (not great), but when the story got more complex (book 4), the movies didn't keep up. Too much focus on non-important stuff...

    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

    March 24, 2011 at 3:06 pm

    #1303253

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (3/24/2011)

    I'm also not a fan of the Harry Potter books. The movie seemed like a study in ADD, nothing was really connected to anything else and the quidditch...

    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

    March 24, 2011 at 2:05 pm

    #1303222

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (3/24/2011)

    I should have walked out of the first Harry Potter movie, but I didn't 'cause I was with friends and didn't have a book. They probably would have...

    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

    March 24, 2011 at 1:55 pm

    #1303216

  • RE: Third party backup tool breaking the backupset LSN chain

    If what you are looking for re updates is something so that you can quickly undo data and schema changes, look at Database Snapshots (SQL feature). Unless you revert 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

    March 24, 2011 at 1:55 pm

    #1303215

  • RE: Page Number question

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

    The following table specifies the maximum sizes and numbers of various objects defined in SQL Server databases or referenced in Transact-SQL statements.

    <snip lots>

    File size (data): 16 terabytes

    So 16...

    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

    March 24, 2011 at 8:38 am

    #1303012

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (3/24/2011)

    GilaMonster (3/23/2011)

    And drive on the wrong side, and in the emergency lane, and on the pavement, and where there just isn't any space

    I've seen that happening in...

    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

    March 24, 2011 at 7:11 am

    #1302930

  • RE: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x59f6e189; actual: 0x59fae189). It occurred during a read of page (1:40) in database ID 22 at offset 0x00000000050000 in file 'd:\data\ms\sample.mdf'

    vamshikrishnaeee (3/24/2011)

    Can I use page restore from full bakcup in case if am in full recovery model to recover that page which is corrupted?

    Depends on what page gets corrupt. Most,...

    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

    March 24, 2011 at 7:10 am

    #1302928

  • RE: Third party backup tool breaking the backupset LSN chain

    In general I've found that mixing backup types (3rd party and native) is not a particularly good idea. Often OK if the 3rd party tool is just a VDI (taking...

    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

    March 24, 2011 at 7:06 am

    #1302925

  • RE: Third party backup tool breaking the backupset LSN chain

    UMG Developer (3/23/2011)

    Can the third party backup tool be configured to make the backup in "copy only" mode? (That should prevent the LSN from being changed and breaking the 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

    March 24, 2011 at 7:02 am

    #1302920

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (3/24/2011)

    No, you didn't offend. I'm just really confused and trying to figure out where I picked up that notion.

    Done any reading/work on Exchange? A friend who is an...

    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

    March 24, 2011 at 6:57 am

    #1302915

  • RE: Log file not shrinking

    See the above-mentioned articles. Bulk-logged, like full recovery, requires regular log backups.

    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

    March 24, 2011 at 6:54 am

    #1302908

  • RE: Check if table exists

    You haven't mentioned what version of SQL. If 2005 or above, this will work. If 2000, replace sys.tables with sysobjects and add an extra filter for xtype = 'U'

    IF EXISTS...

    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

    March 24, 2011 at 2:06 am

    #1302821

  • RE: Running DB trace on live server

    I assume (from the mention of a stop button) that you were using the Profiler GUI. Don't. Use a server-side trace rather.

    http://www.sqlservercentral.com/stairway/72363/

    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

    March 24, 2011 at 2:05 am

    #1302819

  • RE: Developer making me look ignorant

    Elliott Berkihiser (3/23/2011)

    I was curious about the situation with Views. Since the main filtering we want is to select only a few columns, but most of the rows, wouldn'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

    March 24, 2011 at 2:01 am

    #1302817

  • RE: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x59f6e189; actual: 0x59fae189). It occurred during a read of page (1:40) in database ID 22 at offset 0x00000000050000 in file 'd:\data\ms\sample.mdf'

    vamshikrishnaeee (3/24/2011)

    So if I turn on the checksum option while backing up databases.Will sqlserver intimate me about this error before?

    If you backup with checksum, SQL checks the checksums as 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

    March 24, 2011 at 1:57 am

    #1302814

Viewing 15 posts - 27,121 through 27,135 (of 49,552 total)