Forum Replies Created

Viewing 15 posts - 23,581 through 23,595 (of 49,552 total)

  • RE: Alert based Transaction log backup job

    Seriously, not a great idea.

    You should have regular log backups already. Properly planned, that will take care of the log backup reasons for logs full (plus, if you're restoring 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

    September 12, 2011 at 2:33 pm

    #1380321

  • RE: Index rebuild causes severity 20 error "A system assertion check has failed" involving statutil.cpp

    If it was a rebuild-everything job, quite likely.

    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

    September 12, 2011 at 2:27 pm

    #1380318

  • RE: 'PRIMARY' filegroup is full

    The error message gave details on how to fix it.

    Krasavita (9/12/2011)

    Could not allocate space for object 'dbo.UserData'.'UserData_Url' in database 'Network_cde' because the 'PRIMARY' filegroup is full. Create disk space by...

    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

    September 12, 2011 at 9:37 am

    #1380131

  • RE: Integrity job fails error -1073548784

    That's the output from traceflag 1204. old style, limited info, hard to read.

    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

    September 12, 2011 at 9:35 am

    #1380127

  • RE: Discrepancy in definitions in system tables in same database

    The information schema views are ISO standard. There will be lots of areas where the schema views show more information than they do.

    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

    September 12, 2011 at 8:58 am

    #1380094

  • RE: Db in recovery after restoring

    I'm still waiting for the info from the error log that I asked for.

    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

    September 12, 2011 at 8:09 am

    #1380033

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (9/12/2011)

    GilaMonster (9/11/2011)

    I'm seriously contemplating, early next year when I have some spare time again, ripping all the drives out of that machine, replacing them with...

    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

    September 12, 2011 at 7:21 am

    #1379980

  • RE: Integrity job fails error -1073548784

    That is not a deadlock graph. Please enable the traceflag and post the deadlock graph if the problem occurs again.

    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

    September 12, 2011 at 7:09 am

    #1379967

  • RE: Integrity/Optimization jobs system

    Index rebuilds are only needed for MSDB. Master has no user tables, model should not ever have data changing fast enough to require rebuilds.

    Edit: And besides, you should never reorganise...

    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

    September 12, 2011 at 6:44 am

    #1379941

  • RE: Integrity/Optimization jobs system

    Note that you can't back TempDB up, and trying index rebuilds will be a waste of time (if even possible). You can run CheckDB, but any problems you find will...

    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

    September 12, 2011 at 6:21 am

    #1379920

  • RE: help required plz

    How would you handle things like these:

    John van Wyk (van Wyk is the surname)

    David West Jnr (West is the surname)

    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

    September 12, 2011 at 6:14 am

    #1379917

  • RE: Page File location and Size

    As I said 'rough figure'

    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

    September 12, 2011 at 6:08 am

    #1379911

  • RE: read_committed_snapshot is off?

    http://msdn.microsoft.com/en-us/library/ms345124.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

    September 12, 2011 at 4:38 am

    #1379873

  • RE: The xml data type cannot be compared or sorted, except when using the IS NULL operator.

    You're using distinct or union with a xml column in the select, or you have a join or filter on the XML. All of those require some form of comparison...

    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

    September 12, 2011 at 4:24 am

    #1379868

  • RE: Objects in a datafile

    It won't degrade performance. It probably won't help 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

    September 12, 2011 at 4:22 am

    #1379867

Viewing 15 posts - 23,581 through 23,595 (of 49,552 total)