Forum Replies Created

Viewing 15 posts - 10,051 through 10,065 (of 49,552 total)

  • RE: Sharing Temporary Table between 2 stored procedures

    Should be fine, I've done that before. Can you post the code?

    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 12, 2014 at 7:52 am

    #1688355

  • RE: Optimising the insert into temp table query

    Table definitions, index definitions and execution plan please, 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

    February 12, 2014 at 7:46 am

    #1688353

  • RE: how to reduce sorting cost?

    ananda.murugesan (2/12/2014)

    I am checking with profiler, this paricualr Query tooks duration 30 sec for completion at every execution, and CPU is 0 seconds..

    That sounds more like a blocking problem, or...

    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 12, 2014 at 7:28 am

    #1688342

  • RE: how to reduce sorting cost?

    I'm going to ask the same question I ask every time you post a question like this...

    Is that query a problem? Is that operator the problem?

    Costs are relative, costs MUST...

    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 12, 2014 at 5:36 am

    #1688298

  • RE: Difference between four part naming and execute at

    http://thomaslarock.com/2013/05/top-3-performance-killers-for-linked-server-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 12, 2014 at 4:48 am

    #1688280

  • RE: TempDB datafiles

    peter.cox (2/12/2014)

    There are no extended events

    Huh? If you're using SQL 2012 (and I assume you are since you posted in the SQL 2012 forum), you can use Extended Events...

    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 12, 2014 at 4:41 am

    #1688275

  • RE: foreign key references multiple tables

    Yup, perfectly possible. It's not one foreign key though, it's two foreign keys, one referencing each of the tables

    CREATE TABLE sample1(id INT PRIMARY KEY)

    CREATE TABLE sample2(id INT PRIMARY KEY)

    CREATE 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 12, 2014 at 4:37 am

    #1688273

  • RE: TempDB datafiles

    peter.cox (2/12/2014)

    Most of the time the step takes 20 mins, and all is sweetness and light. Sometimes (once every three weeks?) the step takes over 2 hours (i think 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 12, 2014 at 4:32 am

    #1688271

  • RE: TempDB datafiles

    I'd second Jimbo's recommendation, either 6 or 12 files of a combined size of 120GB (so 6 files of 20GB or 12 files of 10GB)

    That said, why are you splitting...

    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 12, 2014 at 4:06 am

    #1688260

  • RE: DBCC CheckDb Error Message

    You are not going to like the answer...

    That's not repairable. Script all objects (and hope that none fail), export all data (and some may fail), recreate the database.

    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 12, 2014 at 4:04 am

    #1688259

  • RE: Database mirroring quesions

    Oracle_91 (2/11/2014)

    2) Secondly, why can't I have the database which is participating in database mirroring as SIMPLE recovery model? In Log shipping we take transaction log backups and there is...

    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 12, 2014 at 1:38 am

    #1688234

  • RE: Transaction - No transaction or savepoint of that name was found.

    amy26 (2/11/2014)

    The thing I find odd is that in the error log table, it is capturing a problem with my main stored procedure (the one I posted here) with a...

    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 12, 2014 at 1:35 am

    #1688233

  • RE: Understanding the question at hand (word problems!)

    I've just spent part of the morning (teaching database design today) explaining why a business requirements document needs to be specific and detailed (and telling horror stories of times I've...

    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 12, 2014 at 1:32 am

    #1688232

  • RE: Self blocking session could not be killed

    Ok, in that case (0%, 0sec) it's probably a stuck rollback (they happen from time to time, it'll be trying to get something that it can't get) and it's usually...

    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 12, 2014 at 1:28 am

    #1688231

  • RE: Database integerity job failed

    Just run DBCC updateusage without parameters, schedule it for your next maintenance window, whenever you do index maintenance.

    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 11, 2014 at 8:31 am

    #1687938

Viewing 15 posts - 10,051 through 10,065 (of 49,552 total)