Forum Replies Created

Viewing 15 posts - 23,956 through 23,970 (of 49,552 total)

  • RE: @@SPID is deprecated? What should replace this command in the new 2008 R2?

    No, @@SPID is not deprecated in any way.

    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

    August 24, 2011 at 7:30 am

    #1372552

  • RE: Database Size is not Expanding

    Maybe, but you'll also have to change sharepoint to point to the other instance, not to the Express instance

    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

    August 24, 2011 at 7:29 am

    #1372551

  • RE: Database Size is not Expanding

    Exactly what I thought...

    You have Express edition, the free edition of SQL. Databases are limited to 4GB in SQL Express 2008 and 10GB in SQL Express 2008 R2.

    You're probably going...

    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

    August 24, 2011 at 7:24 am

    #1372544

  • RE: Truncating log file vs Checkpoint

    GilaMonster (8/24/2011)

    The log is truncated by a checkpoint in simple recovery and a log backup in full recovery.

    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

    August 24, 2011 at 7:22 am

    #1372543

  • RE: Database Size is not Expanding

    GilaMonster (8/24/2011)

    select @@version

    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

    August 24, 2011 at 7:13 am

    #1372531

  • RE: db offline

    Please post new questions in a new thread. Thanks

    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

    August 24, 2011 at 6:51 am

    #1372517

  • RE: Database Size is not Expanding

    select @@version

    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

    August 24, 2011 at 6:50 am

    #1372516

  • RE: security of audit.

    That's just auditing login failures. Changes to security settings are not logged unless you have a trace or some form of trigger.

    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

    August 24, 2011 at 6:46 am

    #1372512

  • RE: Truncating log file vs Checkpoint

    In simple recovery a checkpoint writes all dirty pages to disk and truncates the log. In full and bulk-recovery it just writes dirty pages to disk.

    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

    August 24, 2011 at 6:45 am

    #1372509

  • RE: security of audit.

    Without some custom audit, that information is not stored anywhere.

    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

    August 24, 2011 at 2:10 am

    #1372394

  • RE: security of audit.

    Got any auditing or DDL triggers in place?

    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

    August 24, 2011 at 2:03 am

    #1372391

  • RE: Confusing Index size

    Run DBCC UpdateUsage

    This DB has been upgraded from SQL 2000?

    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

    August 24, 2011 at 1:29 am

    #1372381

  • RE: Truncating log file vs Checkpoint

    Truncating the log is the process of marking 0 or more VLFs as inactive. The log is truncated by a checkpoint in simple recovery and a log backup in 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

    August 24, 2011 at 1:28 am

    #1372380

  • RE: 2011 SSC Code for PASS Summit

    Steve Jones - SSC Editor (8/23/2011)

    It looks like we can rent a room for a party on Tuesday night. We will likely sell tickets for a lower cost for everyone...

    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

    August 23, 2011 at 2:25 pm

    #1372270

  • RE: Seeing no change after applied DTA recommendation

    Maple07-598122 (8/23/2011)

    I should not use NOT IN in the query. Either IN or NOT IN hurts the performance really bad.

    Since the columns are nullable, rather use NOT EXISTS than...

    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

    August 23, 2011 at 2:23 pm

    #1372268

Viewing 15 posts - 23,956 through 23,970 (of 49,552 total)