Forum Replies Created

Viewing 15 posts - 32,566 through 32,580 (of 49,552 total)

  • RE: Differences between SQL Server 2008 and SQL Server 2008 R2

    http://www.google.com/search?q=new+features+%22SQL+2008+R2%22

    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

    June 8, 2010 at 9:42 am

    #1177535

  • RE: What Will We Take For Granted Tomorrow?

    Scott-144766 (6/8/2010)

    In some parts of the world it's even becoming a greater problem than historically, because of strains of drug-resistant forms that are starting to appear.

    And when you combine TB...

    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

    June 8, 2010 at 8:04 am

    #1177488

  • RE: DDL Trigger to monitor server changes

    Don Stevic (6/8/2010)

    I am not sure why this is, but I haven't found a way around it as yet.

    I can think of one reason. Security. Think what 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

    June 8, 2010 at 7:38 am

    #1177469

  • RE: What Will We Take For Granted Tomorrow?

    Scott-144766 (6/7/2010)

    Sadly, tuberculosis isn't a thing of the past like smallpox. It infects a third of the world's population and kills over a million people a year.

    In some parts 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

    June 8, 2010 at 7:30 am

    #1177463

  • RE: Sub Query VS Left Outer Join

    Abrar Ahmad_ (6/8/2010)

    Please, let try to be focus on generic questions stated in start of thread, so we can all benefit from it.

    The answer to your generic question is '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

    June 8, 2010 at 7:28 am

    #1177460

  • RE: update statistics

    You can use the STATS_DATE() function to see when stats were last updated. It won't tell you if they need updating, just when they were updated.

    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

    June 8, 2010 at 6:30 am

    #1177427

  • RE: how to resolve error: The result set is closed.

    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/Topic933903-391-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

    June 8, 2010 at 6:07 am

    #1177413

  • RE: stored procedure taking more time

    Have a look at these articles

    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

    June 8, 2010 at 6:06 am

    #1177412

  • RE: Error - Possible schema corruption. Run DBCC CHECKCATALOG

    Please post your new question in a new thread.

    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

    June 8, 2010 at 1:27 am

    #1177337

  • RE: Recovery State

    Generally rollback operations take as long to complete as the operation did until that opoint, or longer. If the delete was running (not blocked) for 2 days in a single...

    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

    June 8, 2010 at 1:15 am

    #1177332

  • RE: Error - Possible schema corruption. Run DBCC CHECKCATALOG

    Please post new questions in a new thread. Include the complete output of the following.

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    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

    June 8, 2010 at 1:07 am

    #1177330

  • RE: Time Bomb Coding

    sanjays-735734 (6/7/2010)

    Hi David

    I would like to add something in Your "simple example"...

    IF EXISTS(SELECT 1 FROM ... WHERE...)

    Instead of this Use following...

    IF EXISTS(SELECT TOP(1) 1...

    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

    June 7, 2010 at 9:15 am

    #1177119

  • RE: DDL Trigger to monitor server changes

    Don't use Profiler, too much impact. Server-side trace is much better for long-term tracing.

    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

    June 7, 2010 at 8:20 am

    #1177096

  • RE: Fragmentation VS statistics

    Some DML operations can cause fragmentation. Deletes will never, updates and inserts may, depending what they do.

    Some DML operations can make statistics outdated, depending what they do.

    It's trivially possible to...

    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

    June 7, 2010 at 6:05 am

    #1177035

  • RE: Help me in creating indexes

    Please post execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    June 7, 2010 at 5:32 am

    #1177022

Viewing 15 posts - 32,566 through 32,580 (of 49,552 total)