Forum Replies Created

Viewing 15 posts - 26,971 through 26,985 (of 49,552 total)

  • RE: Checkpoints and Performance

    The values in sysprocesses are cumulative since that session started. Since checkpoint runs on a system spid, it never disconnects.

    Hence checkpoint has done 274125 in disk io and 418625 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 29, 2011 at 11:59 pm

    #1305252

  • RE: Is a check constraint for max length necessary?

    steveb. (3/29/2011)

    I would have thought that if the check constraint is checking for the same max length as the data type length then it is kind of pointless..

    Absolutely, it'll...

    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 29, 2011 at 11:57 pm

    #1305250

  • RE: Triggers Bug???

    Vincy-856784 (3/29/2011)

    What it turns out to be is you have to use separate triggers then only it won't trigger for After Delete but it moves the row to DELETED during...

    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 29, 2011 at 11:54 pm

    #1305249

  • RE: Triggers Bug???

    Vincy-856784 (3/29/2011)

    In SQL Server 2008, I am noticing that when a row is being updated somehow the After Delete trigger triggers. Is this normal behavior in Database? or...

    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 29, 2011 at 1:20 pm

    #1305111

  • RE: Is a check constraint for max length necessary?

    If you try to insert a value larger than the field can accept it will fail long before the check constraint would be checked.

    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 29, 2011 at 1:16 pm

    #1305107

  • RE: What would happen to the DB file and log files when SQL machine crashes

    Typically yes, providing you have and use BOTH files, providing the IO subsystem didn't glitch in the failure (battery-backed write caches are not optional)

    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 29, 2011 at 12:48 pm

    #1305099

  • RE: Are the posted questions getting worse?

    Tom.Thomson (3/29/2011)

    200 kbytes/sec Gail? Either you are talking average rate (used to calculate storage requirements) rather than peak rate (the only releavant rate for streaming) or you must 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 29, 2011 at 11:54 am

    #1305062

  • RE: Taking backup with option "Disk = nul"

    Rhox (3/29/2011)

    Why should you use this command for?

    You wouldn't in any reasonable situation.

    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 29, 2011 at 11:51 am

    #1305060

  • RE: Can there be two sql servers on a single computer?

    A SQL Server = an instance. It's fully called an instance of SQL Server.

    There can only be one default instance, there can then be up to 49 named instances on...

    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 29, 2011 at 10:51 am

    #1305027

  • RE: Indexed Computed Column Not Used to Perform Seek

    HowardW (3/29/2011)

    Does anyone have a SQL 2008 SP2 instance available they could test this on, so I know it's not already fixed (if it is a bug)?

    I was using a...

    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 29, 2011 at 10:40 am

    #1305021

  • RE: shrink log file and do a transaction backup after transaction log is full

    Transaction log backups every 3-6 hours???? You realise with log backups 6 hours apart you're in a position to lose up to 6 hours of data in the case 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

    March 29, 2011 at 10:38 am

    #1305017

  • RE: Are the posted questions getting worse?

    jcrawf02 (3/29/2011)

    So, just had a thought, trying to figure out if it's a good one or not. Camcorder that records 1080p straight to the cloud? Unlimited (assuming unlimited pocketbook) video...

    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 29, 2011 at 8:30 am

    #1304916

  • RE: Taking backup with option "Disk = nul"

    Brandie Tarvin (3/29/2011)

    The command being discussed has the effect of turning the database (temporarily) to SIMPLE mode because it throws out the transaction log backup

    No it doesn't. It throws...

    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 29, 2011 at 8:23 am

    #1304907

  • RE: Latch Wait

    What's the exact name of the wait that you're seeing?

    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 29, 2011 at 8:15 am

    #1304897

  • RE: MSDB DATABASE SUSPECT MODE

    GilaMonster (3/28/2011)

    Did the script run successfully?

    Did you restart SQL afterwards?

    Is MSDB online?

    Can you query it?

    If not exactly what errors does it return?

    Exactly what messages are there relating to msdb 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 29, 2011 at 8:12 am

    #1304891

Viewing 15 posts - 26,971 through 26,985 (of 49,552 total)