Forum Replies Created

Viewing 15 posts - 35,611 through 35,625 (of 49,552 total)

  • RE: Updating a variable number of tables with a single update

    MatthewA.Herold (11/27/2009)

    select @tablename = (select Name from Sysobjects where Name like 'queue%' and type = 'U')

    That select must return only one value. You're assigning the result to a single string...

    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 27, 2009 at 1:18 pm

    #1085031

  • RE: Log File is MASSIVE

    aureolin (11/27/2009)

    You need to balance the storage space necessary for keeping all those backups with how far back you might need to go to find something.

    Not just how far...

    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 27, 2009 at 1:10 pm

    #1085030

  • RE: Confusing performance degradation

    Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/ It's really hard to talk about performance in abstract.

    Are the indexes fragmented?

    First execution of a query will...

    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 27, 2009 at 1:08 pm

    #1085026

  • RE: Performanance Issue with DELETE SCAN

    John Paul-702936 (11/27/2009)

    Please .......Pleaseeeeee

    Reply Please ........................

    Bitbucket did. What about his reply (which did answer your question on deleting records in related tables) was not sufficient?

    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 27, 2009 at 1:05 pm

    #1085024

  • RE: TDE

    shivrudra_2008 (11/27/2009)

    i need to encryt the database

    Why? What's your goal, what are you trying to achieve?

    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 27, 2009 at 8:33 am

    #1084931

  • RE: sysindex corrption

    Please run the following and post the FULL output. There's not enough information in what you've so far posted to make even an educated guess.

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

    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 27, 2009 at 8:32 am

    #1084930

  • RE: Introduction to Indexes: Part 2 – The clustered index

    Not any update to a varchar, one that increases the size of the varchar, hence increasing the size of the row.

    It's an option, just not a free one. Tradeoffs, just...

    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 27, 2009 at 4:27 am

    #1084847

  • RE: Introduction to Indexes: Part 2 – The clustered index

    Would you like to expand on that? (details or example)

    PAD_INDEX controls whether the fill factor applies to just the leaf levels or the entire index (leaf and non-leaf levels)

    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 27, 2009 at 3:18 am

    #1084825

  • RE: Introduction to Indexes: Part 2 – The clustered index

    Johnc (11/27/2009)

    What about free space? I assume SS allocates a default % headroom to each row to allow for growth and that the % is adjustable so we could reduce...

    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 27, 2009 at 3:02 am

    #1084821

  • RE: Create table permission denied

    cute_lhen05 (11/26/2009)

    Thanks for your help! it worked! however there's a message showing everytime the user creates a table like

    "you are not logged on as the databae owner or system...

    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 26, 2009 at 2:15 pm

    #1084716

  • RE: UPDATE question

    Not so much MSMQ, but Service Broker sure. Question is, are you willing to put up with the massive increase in complexity and increased administrative overhead (and it is high)...

    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 26, 2009 at 2:10 pm

    #1084714

  • RE: UPDATE question

    Jeff Moden (11/26/2009)

    (sys.sysColumns I believe... not sure because this is 2k8).

    Just sys.columns

    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 26, 2009 at 12:55 pm

    #1084698

  • RE: Sleeping/Awaiting Command

    sqllearner-339367 (11/26/2009)

    select count (*) from tentable

    select * from tentable.

    Those are far from the same query and will execute very differently

    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 26, 2009 at 12:51 pm

    #1084697

  • RE: pURGING THE DATA

    Look up SET ROWCOUNT in SQL Books Online

    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 26, 2009 at 9:07 am

    #1084632

  • RE: Need Technical Details for this TSQL

    Damien-987863 (11/26/2009)

    Because we complain about slow processing of transactions so he give that to us to run it everytime the processing of system is slow.

    That's insane. So every time things...

    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 26, 2009 at 8:34 am

    #1084613

Viewing 15 posts - 35,611 through 35,625 (of 49,552 total)