Forum Replies Created

Viewing 15 posts - 14,416 through 14,430 (of 49,552 total)

  • RE: Transaction scope for a batch

    However this isn't that much better.

    BEGIN TRANSACTION

    DELETE FROM table1

    DELETE FROM table2

    DELETE FROM table3

    DELETE FROM table4

    DELETE FROM table5

    DELETE FROM table6

    COMMIT TRANSACTION

    What do you think will happen if the delete from table3...

    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 5, 2013 at 11:28 am

    #1584541

  • RE: What is proper way of indexing on a table which contain large amount of data

    Yes you can. No there isn't.

    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 5, 2013 at 11:12 am

    #1584534

  • RE: What is proper way of indexing on a table which contain large amount of data

    Yes, absolutely yes.

    As you have it, it's a security risk (SQL injection) and subject to poor plan caching and reuse.

    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 5, 2013 at 9:38 am

    #1584484

  • RE: Clustered Index affecting DELETE

    Is the delete getting blocked?

    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 5, 2013 at 9:36 am

    #1584482

  • RE: t-sql alter problem

    wendy elizabeth (2/5/2013)

    Can you tell me what is wrong with the following sql:

    Err.. everything. 🙂

    That's a create table statement's form. Alter has very different syntax: http://msdn.microsoft.com/en-us/library/ms190273%28v=SQL.100%29.aspx

    What are you trying 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

    February 5, 2013 at 9:35 am

    #1584480

  • RE: Low Performance - High CPU Problem and others...

    http://sqlinthewild.co.za/index.php/2011/11/11/sql-university-advanced-indexing-indexing-strategies/

    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 5, 2013 at 9:30 am

    #1584478

  • RE: What is proper way of indexing on a table which contain large amount of data

    http://sqlinthewild.co.za/index.php/2011/11/11/sql-university-advanced-indexing-indexing-strategies/

    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 5, 2013 at 9:29 am

    #1584477

  • RE: Low Performance - High CPU Problem and others...

    SQL Pizza (2/5/2013)

    IS it the best practice to delete all old indexes and recreate them one by one as needed?

    Do you want to start by crippling the server 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

    February 5, 2013 at 9:08 am

    #1584458

  • RE: What is proper way of indexing on a table which contain large amount of data

    Grant Fritchey (2/5/2013)

    Other than that, I'd say recognize the access patterns and then build indexes to support them. In most circumstances, compound keys and included columns work much better than...

    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 5, 2013 at 8:53 am

    #1584449

  • RE: Transaction Log Corruption

    How would you get an incorrect checksum in the log anyway?

    Checksums are on database pages in the data file.

    There are instances of log corruption, that's not one of them.

    Absolutely do...

    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 5, 2013 at 8:52 am

    #1584446

  • RE: sql server permissions on triggers

    Either db_datawriter role or UPDATE, INSERT and DELETE granted on the table.

    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 5, 2013 at 6:14 am

    #1584340

  • RE: logical consistency-based I/O error

    Have you fixed the errors in MSDB yet? If not, that's probably why you can't create a maint 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

    February 5, 2013 at 5:46 am

    #1584328

  • RE: TempDB Inserts and Updates

    erics44 (2/5/2013)

    i assumed it was because the ssis package used the tempdb differently

    the sql is identical in both, originally it was better in a ssis package because data was coming...

    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 5, 2013 at 5:40 am

    #1584325

  • RE: TempDB Inserts and Updates

    erics44 (2/5/2013)

    nope none of that

    what about joins and sorts on the queries? would that affect the tempDB?

    I mentioned those:

    or have complex select/from portions to those insert/updates that does hash joins...

    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 5, 2013 at 4:53 am

    #1584298

  • RE: Performance Issue - understanding query plans

    Don't suppose you could post the graphical plan? There's not enough info in that text 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

    February 5, 2013 at 4:52 am

    #1584297

Viewing 15 posts - 14,416 through 14,430 (of 49,552 total)