Forum Replies Created

Viewing 15 posts - 39,706 through 39,720 (of 49,552 total)

  • RE: Update statistics

    ALZDBA (4/15/2009)

    As I learned from Gail Shaw, the issue of outdated statistics with sql2000 caused by the way your data is added/deleted/updated shouldn't be an issue with sql2005 anymore. Its...

    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

    April 16, 2009 at 7:09 am

    #978784

  • RE: SELECT statement hangs on certain where conditions

    Any chance of seeing the estimated execution plan?

    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

    April 16, 2009 at 4:19 am

    #978699

  • RE: Reference 'Deleted' table: Dynamic SQL

    rodney.williams (4/15/2009)

    Also, your trigger is so generic, how can I make it a global trigger?

    My trigger's not generic at all. It's got explicit references to the table 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

    April 16, 2009 at 4:10 am

    #978693

  • RE: SELECT statement hangs on certain where conditions

    Try updating the statistics on that table. Fullscan may be necessary.

    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

    April 16, 2009 at 4:06 am

    #978692

  • RE: sys.dm_db_index_physical_stats

    Tim Walker (4/16/2009)

    My apologies to Gail, I didn't appreciate what she had linked to when I posted my previous input.

    No apology was necessary there. Just because one person posts...

    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

    April 16, 2009 at 4:04 am

    #978690

  • RE: How to check which user changed the compatibility level of database?

    It might be in the default trace (set of .trc files in the SQL log directory). If not, then no, it won't be stored anywhere.

    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

    April 16, 2009 at 4:01 am

    #978689

  • RE: WITH NOLOCK hint effect result set order

    It's because SQL's allowed to use a different method of scanning the table (allocation order scan) when the isolation level is read uncommitted. The different method is slightly faster, can...

    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

    April 16, 2009 at 3:54 am

    #978686

  • RE: design database

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic698243-373-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

    April 16, 2009 at 3:49 am

    #978684

  • RE: sys.dm_db_index_physical_stats

    btb1977 (4/15/2009)

    We did not update the statistics after the upgrade, I've already left for the night and will set up a job to do 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

    April 16, 2009 at 1:47 am

    #978648

  • RE: Are the posted questions getting worse?

    Bruce W Cassidy (4/15/2009)

    [font="Verdana"]I didn't want to confuse issues by asking "aren't there some ANSI standards around character sets and collations?"[/font]

    One question that pops to mind. Did ANSI create ASCII?...

    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

    April 15, 2009 at 2:24 pm

    #978398

  • RE: Index optimization

    Are the filters always inequality, as you showed in the first post, or will some be equality?

    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

    April 15, 2009 at 2:09 pm

    #978385

  • RE: Are the posted questions getting worse?

    Jeffrey Williams (4/15/2009)

    Okay - I am just wondering if Lynn has finally hit his limit. I'm just a bit surprised - and shocked - and the response :w00t:

    http://www.sqlservercentral.com/Forums/Topic697843-146-1.aspx#bm697863

    Really -...

    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

    April 15, 2009 at 2:03 pm

    #978378

  • RE: Conversion from SqlServer2000 to 2005

    Did you update statistics after the upgrade?

    There's no need to bump your post after just a few hours. This is not a chat room, also some people are away due...

    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

    April 15, 2009 at 1:59 pm

    #978377

  • RE: sys.dm_db_index_physical_stats

    btb1977 (4/15/2009)

    We've got a database that is facing massive time out issues since the upgrade from SQL 2005 from SQL 2000.

    Did you update all statistics after the upgrade?

    For composite...

    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

    April 15, 2009 at 1:56 pm

    #978374

  • RE: Index optimization

    Maybe. Could you show a few sample queries? (use profiler/SQL Trace to get a sample workload if you don't already have one)

    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

    April 15, 2009 at 10:04 am

    #978209

Viewing 15 posts - 39,706 through 39,720 (of 49,552 total)