Forum Replies Created

Viewing 15 posts - 14,881 through 14,895 (of 49,552 total)

  • RE: When to Index

    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/

    Missing index DMV = suggestions, not directives. If you're looking at a long-running query, you can use that to see what indexes SQL thinks is missing on the relevant tables....

    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

    January 9, 2013 at 11:21 am

    #1575361

  • RE: Question about Optional Parameters in Stored Procedures

    Jacob Pressures (1/9/2013)

    He suggested that i could perhaps pass the SP or UDF a table name. Is the only way that can be done is through dynamic SQL?

    Yes, 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

    January 9, 2013 at 8:35 am

    #1575293

  • RE: Deadlock list

    GilaMonster (1/9/2013)

    There's no permanent store of deadlocks that have occurred unless you have created one.

    You can't get the ' list of deadlocks available in the server' because there's no...

    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

    January 9, 2013 at 8:06 am

    #1575276

  • RE: Problem with "If Exists (Select ...) Or Exists (Select ...)"

    julian.fletcher (1/9/2013)

    The client's database has a nightly maintenance job to reindex.

    May not be frequent enough. May not update the stats needed.

    Does SQL try to do something 'clever' with "If 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

    January 9, 2013 at 8:04 am

    #1575274

  • RE: Deadlock list

    You might be able to pull some from the system health extended events session. Whether it goes back a full week though is doubtful. There's no permanent store of deadlocks...

    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

    January 9, 2013 at 7:19 am

    #1575239

  • RE: When to Index

    dwilliscp (1/9/2013)

    I was trying to find a better approach than what I am currently doing... that is starting with the query, pulling the top 10 and looking at what tables...

    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

    January 9, 2013 at 7:17 am

    #1575235

  • RE: Problem with "If Exists (Select ...) Or Exists (Select ...)"

    Unfortunately I would need to see more info to really help with this. It's not a standard or known problem with a well documented solution. Could be a million things.

    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

    January 9, 2013 at 7:15 am

    #1575230

  • RE: When to Index

    dwilliscp (1/9/2013)

    Oh, one other side note. (this has not happend yet, since there were almost no indexes) But I like to only have about 3 Non-Cluster indexes on tables, unless...

    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

    January 9, 2013 at 7:13 am

    #1575229

  • RE: Auto increment error

    http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/a471e304-1160-4a27-aa9b-6c72ba7fbacc/

    https://connect.microsoft.com/SQLServer/feedback/details/739013/alwayson-failover-results-in-reseed-of-identity#details

    Despite the title, it's got nothing to do with always on. It's a restart of any form.

    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

    January 9, 2013 at 6:46 am

    #1575220

  • RE: Problem with "If Exists (Select ...) Or Exists (Select ...)"

    In case you missed this...

    GilaMonster (1/9/2013)

    Any chance you can post an execution plan for the first one? What is the wait type that the query has during those 10 minutes?...

    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

    January 9, 2013 at 6:42 am

    #1575216

  • RE: ERROR 823 in SQL 2000 -> Need help

    Please run the CheckDB and post the results. I can't tell you how to fix it (other than restore from a clean backup) without the full, complete and unedited output...

    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

    January 9, 2013 at 6:37 am

    #1575213

  • RE: ERROR 823 in SQL 2000 -> Need help

    shovankar (1/9/2013)

    1. Is there a way that I can track this page back to a particular object in the database ?

    Not from the information you've given, no. The output...

    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

    January 9, 2013 at 4:33 am

    #1575155

  • RE: Which Query has better statistics ?

    Don't run queries with exec plans on to take time stats. Also make sure you run more than once and ignore the first run (caching)

    On a larger data volume, but...

    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

    January 9, 2013 at 4:26 am

    #1575151

  • RE: Problem with "If Exists (Select ...) Or Exists (Select ...)"

    Bhuvnesh (1/9/2013)

    julian.fletcher (1/9/2013)

    Really? Do you have any links to further details? That would be very helpful.

    sse this link http://sqlserverplanet.com/optimization/using-union-instead-of-or

    That's what I was talking about with SQL 2000 and prior...

    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

    January 9, 2013 at 3:03 am

    #1575120

  • RE: Problem with "If Exists (Select ...) Or Exists (Select ...)"

    There is not a well known performance glitch with OR. ORs in a where clause used to perform badly on SQL 2000 because the optimiser had few methods to run...

    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

    January 9, 2013 at 2:51 am

    #1575113

Viewing 15 posts - 14,881 through 14,895 (of 49,552 total)