Forum Replies Created

Viewing 15 posts - 37,576 through 37,590 (of 49,552 total)

  • RE: Not sure how to get my subquery right

    Jeff Moden (7/18/2009)

    Now, if you throw in an inequality, all bets are off because you've just built a triangular join.

    Inequality or a TOP 1 ... ORDER BY. Both 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

    July 18, 2009 at 9:02 am

    #1026561

  • RE: GAM (Sql Server)

    sudhakara (7/18/2009)

    i am going to create one data file for each cpu processor with equal size for tempdb so how it will chose the data file to allocate extend and...

    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

    July 18, 2009 at 8:40 am

    #1026559

  • RE: integrity job failing

    Take the database into single user mode and run CheckDB with the repair_rebuild option. Sometimes manually dropping and recreating the indexes is sufficient (note, dropping and recreating, not rebuilding), sometimes...

    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

    July 18, 2009 at 8:37 am

    #1026558

  • RE: GAM (Sql Server)

    GAM pages are per file. Each file will have its own GAM pages tracking extent allocation within that file.

    Why are you asking?

    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

    July 18, 2009 at 6:02 am

    #1026535

  • RE: integrity job failing

    Take the database into single user mode and run CheckDB with the repair_rebuild option.

    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

    July 18, 2009 at 6:00 am

    #1026534

  • RE: Easy way to store changes to a table

    Since you're on SQL 2008, take a look at Change Tracking, Change Data Capture and SQL Audit. I'm sure one of them will serve your purposes.

    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

    July 17, 2009 at 3:28 pm

    #1026463

  • RE: Disable or prevent Trusted Connection (-E) logins [DDL triggers]

    The simplest way would be to ensure that no windows accounts (including Builtin\administrators) are granted logon to the server. Either disable, revoke connect or drop them completely.

    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

    July 17, 2009 at 3:14 pm

    #1026458

  • RE: mirroring

    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/Topic754989-146-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

    July 17, 2009 at 3:04 pm

    #1026456

  • RE: mirroring

    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/Topic754989-146-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

    July 17, 2009 at 3:04 pm

    #1026455

  • RE: database mirroring

    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/Topic754989-146-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

    July 17, 2009 at 3:04 pm

    #1026454

  • RE: Initial Restore for Mirroring stuck "Restoring..."

    NORECOVERY means restore this and leave the database in a restoring state

    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

    July 17, 2009 at 11:26 am

    #1026348

  • RE: Fast Update(Please Help)

    maxyogesh2002 (7/17/2009)

    Dear Friends,

    I m attached the JPEG of my Execution plan plz tell me

    Please read the article I referenced. There's not enough info in a screenshot of an...

    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

    July 17, 2009 at 11:21 am

    #1026345

  • RE: DB Performance Degradation - IO Bottleneck

    Useful indexes will reduce IO load, not increase it. Trick is to find useful indexes.

    Take a look at these two articles, they may help you in identifying the problematic queries.

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    July 17, 2009 at 10:22 am

    #1026306

  • RE: Performance Advise

    Tara (7/17/2009)

    other thing to mention is setting memory on the sql server box. our servers are dedicated to sql server and we set to use 90% of available memory for...

    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

    July 17, 2009 at 8:29 am

    #1026209

  • RE: Performance Advise

    Tara (7/17/2009)

    Dave Ballantyne

    I understand READ UNCOMITTED is exceptional as it gives inconsitent result but i think we dont worry about it as we do not update our productions so i...

    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

    July 17, 2009 at 8:19 am

    #1026203

Viewing 15 posts - 37,576 through 37,590 (of 49,552 total)