Forum Replies Created

Viewing 15 posts - 29,686 through 29,700 (of 49,552 total)

  • RE: Which table is used last

    Craig Farrell (10/27/2010)

    Although, I'm with Wayne. Where do you find the 'last time index changed' date? 🙂 I'm relatively sure you can't do it in 2k, but perhaps...

    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

    October 28, 2010 at 2:48 am

    #1243388

  • RE: Which table is used last

    Jeff Moden (10/27/2010)

    I may be misreading the requirements but can't you just determine when one of the indexes on the table was last used which would also indicate when 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

    October 28, 2010 at 2:33 am

    #1243385

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (10/27/2010)

    I'll drop some topics out here for you. Here's a couple that I have saved up:

    - Finding/changing the default backup location

    - scheduling a trace

    - duplicating...

    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

    October 27, 2010 at 1:31 pm

    #1243157

  • RE: Duplicate Index Performance

    upstart (10/27/2010)

    -- What are the performance hits incurred by having duplicate Non-Clustered indexes on a table? Is there any easy way to measure this?

    Ur... It depends.

    Set up...

    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

    October 27, 2010 at 12:53 pm

    #1243137

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (10/27/2010)

    BTW, speaking of technical stuff....

    I wonder if any of you would be interested in writing to fill holes? I keep finding posts here, and 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

    October 27, 2010 at 12:40 pm

    #1243129

  • RE: Log file grows very big after running a job

    Two completely and totally different commands. Unrelated.

    1) Discards inactive log records, break the log chain, marks the space that those log records occupied as reusable. Log backups are impossible after...

    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

    October 27, 2010 at 12:27 pm

    #1243125

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (10/27/2010)

    Whew, for a second I thought I was going to learn something on The Thread.

    Heaven forbid. That would be a disaster.

    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

    October 27, 2010 at 10:40 am

    #1243049

  • RE: Are the posted questions getting worse?

    WayneS (10/27/2010)

    GilaMonster (10/26/2010)

    Trey Staker (10/26/2010)

    @Gail, how's that difficult contract going?

    Difficultly.

    Officially going to prod on Friday.

    And how long after Friday do you think it will take for everything to be...

    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

    October 27, 2010 at 10:25 am

    #1243036

  • RE: Shrinking Log files on regular basis -SQL Server 2005

    That's well into the category of 'serious mismanagement of transaction logs'

    Why shrink? They're just going to grow again. The fact that you don't see performance problems now is not 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

    October 27, 2010 at 9:44 am

    #1242996

  • RE: ROWLOCK

    Edit: Misunderstood the question.

    That option isn't on the table, it's on the primary key, which is an index. You can't say

    CREATE TABLE [dbo].[MyTable2](

    [id] [int] IDENTITY(1,1) 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

    October 27, 2010 at 9:38 am

    #1242989

  • RE: Log file grows very big after running a job

    mike.hartman (10/27/2010)

    My solution for maintenance that is to occur during "scheduled downtime" (such as index rebuilding that causes the log to grow substantially) is to have steps in the job...

    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

    October 27, 2010 at 9:36 am

    #1242986

  • RE: ROWLOCK

    ps. (10/27/2010)

    is there a way to find out if these are turned ON or OFF for a particular table?

    They're not enabled for a table, they're enabled for an index.

    Query sys.indexes.

    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

    October 27, 2010 at 9:15 am

    #1242974

  • RE: got a parameter sniffing example/demo script?

    Gianluca Sartori (10/27/2010)

    Gail has a superb blog post on the topic:

    http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

    Saves me from looking that up. 😀 Need to fix the formatting on that.

    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

    October 27, 2010 at 9:13 am

    #1242973

  • RE: got a parameter sniffing example/demo script?

    Lowell (10/27/2010)

    I'd said previously that my theory is when parameter sniffing occurs, i think the saved execution plan is used to get the data on a row by row basis,...

    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

    October 27, 2010 at 9:11 am

    #1242971

  • RE: ROWLOCK

    ps. (10/27/2010)

    Thanks Adi. I tried to explain them this but they were somehow of the view that if rowlevel lock *setting* is in place, they will get lesser deadlocks.

    Deadlocks are,...

    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

    October 27, 2010 at 8:48 am

    #1242945

Viewing 15 posts - 29,686 through 29,700 (of 49,552 total)