Forum Replies Created

Viewing 15 posts - 10,876 through 10,890 (of 49,552 total)

  • RE: Insert Trigger and @@rowcount problem - Performance Issue

    John Hanrahan (11/19/2013)

    But any idea why @@rowcount would be so slow? The line of code doing the insert is a single row insert. I can't understand why 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

    November 20, 2013 at 6:18 am

    #1667764

  • RE: Insert Trigger and @@rowcount problem - Performance Issue

    jcb (11/19/2013)

    just for the record: avoid triggers, they are evil.

    They are a tool. They can be used well or used badly. When used badly, blame the developer, not the tool.

    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

    November 20, 2013 at 6:15 am

    #1667763

  • RE: how does With (Index (Index_Name)) help in fast query execution??

    Abu Dina (11/20/2013)

    mote.ajit2 (11/20/2013)

    Hi,

    But I have added one non clustered index column in select list. Now performance in significantly increased.

    Perhaps an ORDER BY clause in your query is now using...

    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

    November 20, 2013 at 6:13 am

    #1667762

  • RE: blocking

    Ignore the 0. The database ID and object ID are what you need to identify the table that the blocking is on (and it is a table-level lock).

    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

    November 20, 2013 at 6:12 am

    #1667761

  • RE: CHECKDB Error

    Please run a full CheckDB, not just a check table on the one table you know there's a problem with. I asked for a full CheckDB to see if there...

    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

    November 20, 2013 at 5:04 am

    #1667744

  • RE: Regarding adding another data file on PRIMARY

    You can just add the new file (with a decent size) and disable autogrow on the first one. With an empty new file and an almost full existing one, SQL...

    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

    November 20, 2013 at 4:31 am

    #1667739

  • RE: CHECKDB Error

    Please run the following and post the full and complete, unedited output

    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

    November 20, 2013 at 3:21 am

    #1667728

  • RE: how does With (Index (Index_Name)) help in fast query execution??

    Again, not enough information. Please read through the article I referenced.

    If you create an index on a column that is just in the select clause, that index is probably useless.

    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

    November 20, 2013 at 2:25 am

    #1667712

  • RE: how does With (Index (Index_Name)) help in fast query execution??

    No where near enough information to answer that.

    Depends on the columns in the index, the where clause predicates, the selectivity of the index and more.

    http://www.sqlservercentral.com/articles/Indexing/68439/

    http://www.sqlservercentral.com/articles/Indexing/68563/

    http://www.sqlservercentral.com/articles/Indexing/68636/

    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

    November 20, 2013 at 12:33 am

    #1667689

  • RE: blocking

    Database ID 15 (so the database with an ID of 15 in sys.databases)

    Table ID 638292499 (so the table with an ID of 638292499 in sys.objects)

    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

    November 19, 2013 at 10:33 pm

    #1667666

  • RE: database blocking

    Please don't cross post. It just wastes people's time and fragments replies.

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1515848-1550-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

    November 19, 2013 at 10:32 pm

    #1667665

  • RE: Email Notification for Transaction log full

    A properly maintained log should not be growing.

    Please read through this: http://www.sqlservercentral.com/articles/Administration/64582/

    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

    November 19, 2013 at 10:32 pm

    #1667664

  • RE: how does With (Index (Index_Name)) help in fast query execution??

    Short answer - it doesn't. It forces the optimiser to use an index. It's possible that it will result in worse performance if the hinted index is not the best...

    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

    November 19, 2013 at 10:30 pm

    #1667663

  • RE: query to get updates/inserts done everyday

    Depends on your requirements and version. In SQL 2005, triggers are the main ones, on all tables with audit tables that they write into. On 2008 you also have Change...

    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

    November 19, 2013 at 11:28 am

    #1667517

  • RE: query to get updates/inserts done everyday

    Not unless you have some form of auditing or change tracking in place.

    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

    November 19, 2013 at 10:27 am

    #1667497

Viewing 15 posts - 10,876 through 10,890 (of 49,552 total)