Forum Replies Created

Viewing 15 posts - 24,481 through 24,495 (of 49,552 total)

  • RE: Sql Server Identity

    Chris Kitchen (8/4/2011)

    1. Set "Identity" to "Yes" for all PK columns and have a procedure/function which will work out the latest inserted value for the PK and use that when...

    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

    August 4, 2011 at 6:50 am

    #1363604

  • RE: Sql Server Identity

    Chris Kitchen (8/4/2011)

    I'm currently putting a lot of thought into whether or not to set the Identity value to "Yes" for each of the Primary Key columns in 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

    August 4, 2011 at 5:50 am

    #1363575

  • RE: CHECKDB Error

    There's probably no such object. The page header of that particular page is damaged and could lead to an incorrect object_id. The object that page actually belongs to is 988855631...

    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

    August 4, 2011 at 5:26 am

    #1363554

  • RE: CHECKDB Error

    Please run the following and post the full and complete 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

    August 4, 2011 at 2:45 am

    #1363493

  • RE: license fee for upgrading from sql server 2005 Enterprise Edition to sql server 2008 Enterprise Edition ?

    2 Tim 3:16 (2/23/2009)

    If you purchased "Software Assurance" with your initial license, then there is no upgrade cost. If not, you have to purcfhase from scratch.

    That's true for all...

    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

    August 4, 2011 at 2:40 am

    #1363491

  • RE: How to Removing SQL 2005 process command in KILLED/ROLLBACK status waiting on MSQL_DQ

    Jeffrey Williams-493691 (8/3/2011)

    GilaMonster (8/3/2011)

    Check in DTC what the state of the transaction is. Also, try a restart of DTS (not SQL, not the machine, just MSDTC), see if that fixes...

    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

    August 4, 2011 at 2:30 am

    #1363490

  • RE: WHAT IS - The Fastest Method For Removing Available Space In A Data File (SQL 2005)

    YSLGuru (8/3/2011)

    BTW - I've always wanted to ask if your avatar is one of the chaarcters from the short lived Babylon 5 spin off? I forget the show name...

    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

    August 4, 2011 at 2:24 am

    #1363486

  • RE: Are the posted questions getting worse?

    Tom.Thomson (8/3/2011)

    which stopped happening 11 years ago) because US immigration control has deteriorated to the point where no-one in his right mind wants to travel to the USA anyway

    Tell me...

    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

    August 3, 2011 at 3:30 pm

    #1363368

  • RE: WHAT IS - The Fastest Method For Removing Available Space In A Data File (SQL 2005)

    Shrinkfile/shrinkdatabase is the only way.

    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

    August 3, 2011 at 3:14 pm

    #1363364

  • RE: Server is in script upgrade mode. Only administrator can connect at this time

    Service either isn't running or the name used is wrong.

    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

    August 3, 2011 at 3:13 pm

    #1363361

  • RE: Need to avoid table spool in view

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    August 3, 2011 at 3:07 pm

    #1363359

  • RE: Server is in script upgrade mode. Only administrator can connect at this time

    Did you read through the page that Ysaias linked 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

    August 3, 2011 at 2:01 pm

    #1363321

  • RE: SQL multiple key index query : How to find where a combined index contains a unique column on all tables in db

    In your case, unless Index1 is clustered, I'd do the following:

    Drop Index1

    Change index2 to UNIQUE INDEX (RID) INCLUDE (DeliveryCartID)

    Sure, key lookups on a single row isn't expensive, but there's always...

    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

    August 3, 2011 at 1:59 pm

    #1363318

  • RE: How to Removing SQL 2005 process command in KILLED/ROLLBACK status waiting on MSQL_DQ

    Check in DTC what the state of the transaction is. Also, try a restart of DTS (not SQL, not the machine, just MSDTC), see if that fixes anything.

    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

    August 3, 2011 at 1:53 pm

    #1363314

  • RE: Need to avoid table spool in view

    Table spools are generally optimisations so that the execution engine doesn't have to go back and recalculate things.

    Sure the costs are correct and the table spool really is the problem?

    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

    August 3, 2011 at 1:51 pm

    #1363311

Viewing 15 posts - 24,481 through 24,495 (of 49,552 total)