Forum Replies Created

Viewing 15 posts - 22,336 through 22,350 (of 49,552 total)

  • RE: Updating Stats

    Usman Butt (11/10/2011)

    Since read uncommitted isolation level could bring dirty reads, If I am not getting it wrong, then even after updating stats with full scan could lead to 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

    November 11, 2011 at 1:53 am

    #1406116

  • RE: Index Fragmentation

    Depends. The terminology around this varies. I've seen this called physical fragmentation, I've seen that term used for file system fragmentation.

    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

    November 11, 2011 at 1:50 am

    #1406115

  • RE: Use of WITH(NOLOCK)

    Iulian -207023 (11/10/2011)

    What scenario make sens for using With(NoLock)?

    When you don't care if the data is inaccurate. Something like a dashboard where the graphs show aprox values only may 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

    November 10, 2011 at 9:17 am

    #1405858

  • RE: issue with Trd column

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1203642-392-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

    November 10, 2011 at 9:09 am

    #1405854

  • RE: Use of WITH(NOLOCK)

    Iulian -207023 (11/10/2011)

    I think it depend on how often the data does change. If it is updated, let's say, once a day I would see no issue in using With(NoLock).

    If...

    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

    November 10, 2011 at 9:00 am

    #1405850

  • RE: INSERT into sys.objects on 2008

    Dev @ +91 973 913 6683 (11/10/2011)

    GilaMonster (11/10/2011)

    Minnesota - Viking (11/10/2011)

    Any Ideas as to how to SCRIPT a encrypted VIEW or for that matter any object ?

    my Generate...

    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

    November 10, 2011 at 8:46 am

    #1405840

  • RE: INSERT into sys.objects on 2008

    Dev @ +91 973 913 6683 (11/10/2011)

    GilaMonster (11/10/2011)

    Minnesota - Viking (11/10/2011)

    Any Ideas as to how to SCRIPT a encrypted VIEW or for that matter any object ?

    my Generate...

    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

    November 10, 2011 at 8:45 am

    #1405839

  • RE: Updating Stats

    Start with the auto_stats events. See how often they really happen.

    For queries affected by poor stats, normal monitoring and look for queries with erratic durations. Investigate and see if...

    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

    November 10, 2011 at 8:42 am

    #1405836

  • RE: Are the posted questions getting worse?

    SQLRNNR (11/10/2011)

    Ninja's_RGR'us (11/10/2011)

    Stefan Krzywicki (11/10/2011)

    Kiara (11/10/2011)

    In case y'all haven't seen this.. http://thedailywtf.com/Articles/The-Query-of-Despair.aspx...

    I'm sure we've all had days like that...

    I inherited a query like that back in 99. It was 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

    November 10, 2011 at 8:32 am

    #1405828

  • RE: INSERT into sys.objects on 2008

    Minnesota - Viking (11/10/2011)

    Gazareth (11/10/2011)

    When I compare the old and new objects in both sys.objects and sys.columns, its so convincing that what all the sysobject table[view] needs is 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

    November 10, 2011 at 8:29 am

    #1405825

  • RE: INSERT into sys.objects on 2008

    Minnesota - Viking (11/10/2011)

    Any Ideas as to how to SCRIPT a encrypted VIEW or for that matter any object ?

    my Generate script task stops coz it cant script...

    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

    November 10, 2011 at 8:27 am

    #1405823

  • RE: Updating Stats

    If you haven't monitored, then you have no grounds for a decision either way. These kind of things shouldn't be guesses, they should be informed decisions based on solid data.

    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

    November 10, 2011 at 8:04 am

    #1405780

  • RE: Index Fragmentation

    derekr 43208 (11/10/2011)

    GilaMonster (11/10/2011)

    derekr 43208 (11/9/2011)

    So when a NC index is created, its leaf pages match the order of the data pages

    No, no, no. Nothing whatsoever to do with 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

    November 10, 2011 at 8:02 am

    #1405779

  • RE: Updating Stats

    Maybe, but you'll have to test.

    Have you monitored and seen queries waiting for stats updates? Compile sitting waiting? Frequent auto updates?

    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

    November 10, 2011 at 7:52 am

    #1405768

  • RE: How to Take Incremental Backup in sql server

    rocky@123 (11/10/2011)

    usually differential backups treated as an incremental backups..i don't think both are different..

    Differential and incremental backups are different. SQL does not have incremental backups.

    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

    November 10, 2011 at 6:41 am

    #1405709

Viewing 15 posts - 22,336 through 22,350 (of 49,552 total)