Forum Replies Created

Viewing 15 posts - 24,646 through 24,660 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (7/27/2011)

    GilaMonster (7/27/2011)

    Ninja's_RGR'us (7/27/2011)

    @steve-2, when do you plan to re-raise the limits? AFAIK she's not the only one who can't PM anymore because her box is full (assuming it's...

    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

    July 27, 2011 at 9:35 am

    #1359395

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (7/27/2011)

    @steve-2, when do you plan to re-raise the limits? AFAIK she's not the only one who can't PM anymore because her box is full (assuming it's the case...

    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

    July 27, 2011 at 9:17 am

    #1359364

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (7/27/2011)

    ...

    You're welcome... (I can't PM you)

    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

    July 27, 2011 at 9:07 am

    #1359355

  • RE: Consistency error all of a sudden

    Ninja's_RGR'us (7/27/2011)

    Darn, I guess you can't save them all :crying:.

    Lately it's been more a case of 'can't save any of em'. I must have had 10 or more irreparable corruption...

    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

    July 27, 2011 at 8:57 am

    #1359341

  • RE: Time for a ROWID?

    krowley (7/27/2011)

    Forgive a relative newbie to SQL internals but why can't the page size be variable per database or even per table? This would give the best of all worlds...

    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

    July 27, 2011 at 8:51 am

    #1359334

  • RE: New Server MDF& LDF

    Maybe speak to the DBA there?

    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

    July 27, 2011 at 8:50 am

    #1359331

  • RE: Consistency error all of a sudden

    Restore from a clean backup, that can't be repaired.

    If you're in full recovery and have log backups going back to that clean backup, take a tail-log backup before starting 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

    July 27, 2011 at 8:47 am

    #1359325

  • RE: Help with which book to choose

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1149056-146-1.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

    July 27, 2011 at 7:58 am

    #1359269

  • RE: Time for a ROWID?

    the.komplikator (7/27/2011)

    GilaMonster (7/27/2011)

    Errr, no...

    Non-unique clustered indexes get a uniquifier, which is 4 bytes (an int) added to rows that have duplicate values for the clustering key.

    Nonclustered indexes get either 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

    July 27, 2011 at 7:45 am

    #1359257

  • RE: Time for a ROWID?

    the.komplikator (7/27/2011)

    Little remark... All non-unique non-clustered indexes are created with a sysem internal unique id, 8 bytes in size, so that sql could differentiate each row. These id "columns" aren'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

    July 27, 2011 at 2:30 am

    #1359008

  • RE: Sql Certification

    http://www.microsoft.com/learning/en/us/certification/cert-sql-server.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

    July 27, 2011 at 1:16 am

    #1358982

  • RE: Sql Certification

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1148830-146-1.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

    July 27, 2011 at 1:16 am

    #1358980

  • RE: Restore to only 3 logical names

    What do you mean 'logical names'?

    A restore puts the database down exactly as it was at the time of 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

    July 27, 2011 at 1:15 am

    #1358979

  • RE: DBCC Errors -Migarting SQL 2000 database to SQL 2005

    No idea. No idea what caused this, what's actually damaged on SQL 2000, what it will affect.

    Maybe. Maybe 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

    July 26, 2011 at 3:04 pm

    #1358864

  • RE: Trigger + CLR "threading" like workflow

    Service broker is build into SQL 2005 and above. There's no separate installation process

    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

    July 26, 2011 at 2:51 pm

    #1358854

Viewing 15 posts - 24,646 through 24,660 (of 49,552 total)