Forum Replies Created

Viewing 15 posts - 20,491 through 20,505 (of 49,552 total)

  • RE: SQL Query Optimization

    What specifically do you not understand about 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

    February 7, 2012 at 3:34 pm

    #1444188

  • RE: SQL Query Optimization

    http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

    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

    February 7, 2012 at 3:13 pm

    #1444173

  • RE: Parallel update on the same partitioned table generating deadlocks

    Glad to hear 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

    February 7, 2012 at 1:57 pm

    #1444122

  • RE: sys.dm_db_index_usage_stats question

    Grizzly Bear (2/7/2012)

    Column3 is part of NC Index -- hence rightfully gets incremented.

    Correct. Now, consider the clustered index which implicitly includes every single column in the table (the clustered index...

    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

    February 7, 2012 at 1:56 pm

    #1444120

  • RE: sys.dm_db_index_usage_stats question

    Jim_K (2/7/2012)

    I might be wrong about this, but on a table that has a clustered index, the nonclustered index references back to the clustered index[/url]. If its a heap (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

    February 7, 2012 at 1:36 pm

    #1444104

  • RE: sys.dm_db_index_usage_stats question

    Grizzly Bear (2/7/2012)

    But why would the count for Clustered Index increase by 1 if I update a NC index?

    Can you update a nonclustered index without updating the table that 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

    February 7, 2012 at 1:36 pm

    #1444103

  • RE: Re-format datetime data

    DECLARE @SomeDate DATETIME = '2011-09-30 23:59:59.000'

    SELECT CAST(CAST(@SomeDate AS DATE) AS DATETIME)

    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

    February 7, 2012 at 1:20 pm

    #1444093

  • RE: SQL XML Plan

    http://www.sqlservercentral.com/articles/books/65831

    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

    February 7, 2012 at 1:19 pm

    #1444092

  • RE: sys.dm_db_index_usage_stats question

    Why do you say it's misleading?

    If I have a nonclustered index as such - index key (col1, col2) INCLUDE (col3, col4) and column3 is updated, has that nonclustered index received...

    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

    February 7, 2012 at 1:13 pm

    #1444089

  • RE: sys.dm_db_index_usage_stats question

    The clustered index is the table, it has every single column in the table in it. Hence any update to the table at all updates the clustered index and zero...

    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

    February 7, 2012 at 12:55 pm

    #1444070

  • RE: Adding a cluster index to pk that has a unclustered one that is referenced by 10 fk

    I'm sure there is, have you checked the script library here?

    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

    February 7, 2012 at 12:00 pm

    #1444033

  • RE: Why index use or not

    mtassin (2/7/2012)

    Really?

    Yes. Absolutely. Parameter sniffing is a good thing in the vast majority of situations, it lets the optimiser get a better idea of the cardinalities of various...

    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

    February 7, 2012 at 9:26 am

    #1443904

  • RE: Server performance issues

    Lol, yeah that'll do 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

    February 7, 2012 at 9:09 am

    #1443884

  • RE: Why index use or not

    mtassin (2/7/2012)

    GilaMonster (2/7/2012)

    I will admit, recompile would not be my first or even second option for dealing with parameter sniffing.

    Personally dealing with parameter sniffing I prefer Traceflag 4136. 🙂

    Personally...

    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

    February 7, 2012 at 9:03 am

    #1443876

  • RE: Indexes not being used that are Clustered and Primary Key

    I would very strongly recommend not dropping the clustered index unless you have a better place to put it.

    Indexes supporting unique constraints (and primary keys are a specialisation 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

    February 7, 2012 at 8:57 am

    #1443870

Viewing 15 posts - 20,491 through 20,505 (of 49,552 total)