Forum Replies Created

Viewing 15 posts - 35,371 through 35,385 (of 49,552 total)

  • RE: Fetch the most used/retrieved rows from a table

    There's no record within SQL of how often a row is selected. If you need to do this, then you're going to have to make some changes to your app...

    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

    December 10, 2009 at 1:59 am

    #1090403

  • RE: Are the posted questions getting worse?

    Jeff Moden (12/9/2009)

    Also, just for reference... I don't believe that the "pin table" setting actually does anything anymore as of SQL Server 2k5. I think they kept it 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

    December 10, 2009 at 1:51 am

    #1090397

  • RE: What SQL activities would result in LDF reads?

    G33kKahuna (12/9/2009)

    @Gail: The log size is about 5G on disk. I apologize, should have given the numbers. The reported number are as below

    How much of that is in use at...

    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

    December 10, 2009 at 1:47 am

    #1090395

  • RE: Can anyone verify this please??

    Post. The. Code.

    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

    December 9, 2009 at 1:38 pm

    #1090199

  • RE: What SQL activities would result in LDF reads?

    G33kKahuna (12/9/2009)

    @Gail: I considered log backup but the monkey wrench is that we have 1 nightly full back up and hourly txn file backup. My DMV would have reported low...

    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

    December 9, 2009 at 1:30 pm

    #1090193

  • RE: What SQL activities would result in LDF reads?

    Jonathan Kehayias (12/9/2009)

    GilaMonster (12/9/2009)

    Log backups, full backups, differential backups, transaction rollbacks. Restart recovery. Probably checkpoint.

    Interesting that you mention checkpoint here. I considered that but couldn't remember enough about it...

    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

    December 9, 2009 at 1:16 pm

    #1090185

  • RE: Can anyone verify this please??

    doran_doran (12/9/2009)

    As I understood reading from different blogs that Trigger only handles one row at a time.

    No. Triggers in SQL are statement triggers. Fire once per operation and 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

    December 9, 2009 at 1:06 pm

    #1090176

  • RE: What SQL activities would result in LDF reads?

    Log backups, full backups, differential backups, transaction rollbacks. Restart recovery. Maybe checkpoint.

    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

    December 9, 2009 at 1:03 pm

    #1090172

  • RE: Can anyone verify this please??

    doran_doran (12/9/2009)

    DECLARE @tID int

    SET @tID = (SELECT ID FROM inserted)

    What happens if there's more than 1 row in inserted?

    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

    December 9, 2009 at 12:52 pm

    #1090155

  • RE: Clustered Index Seek Causing Poor Performance - Suggestions For Indexes

    Custom-built app or something that has been bought from elsewhere?

    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

    December 9, 2009 at 12:21 pm

    #1090133

  • RE: Clustered Index Seek Causing Poor Performance - Suggestions For Indexes

    Grant Fritchey (12/9/2009)

    I'd say that moving a gb of data in a single query in 3 minutes is decent, if not great, performance.

    I'm in agreement here. That's a lot...

    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

    December 9, 2009 at 11:49 am

    #1090101

  • RE: INDEX FRAGMENTATION

    As per Books Online, in detailed mode index physical stats produces one row for each level of the index tree.

    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

    December 9, 2009 at 11:05 am

    #1090053

  • RE: Can anyone verify this please??

    As I just said:

    Concatenating strings as part of a parameter assignment to a stored proc is not allowed. Define a variable of type varchar, build up the string and set...

    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

    December 9, 2009 at 10:46 am

    #1090040

  • RE: Are the posted questions getting worse?

    At least he's not asking you to do the syntax check for him.....

    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

    December 9, 2009 at 10:43 am

    #1090038

  • RE: Can anyone verify this please??

    Concatenating strings as part of a parameter assignment to a stored proc is not allowed. Define a variable of type varchar, build up the string and set the parameter value...

    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

    December 9, 2009 at 10:41 am

    #1090035

Viewing 15 posts - 35,371 through 35,385 (of 49,552 total)