Forum Replies Created

Viewing 15 posts - 2,101 through 2,115 (of 49,552 total)

  • RE: what is compile wait resource and how to resolve it

    You're going to have to investigate why that procedure is compiling frequently. There's nothing in the code that would cause compiles or recompiles, so start by tracking down which 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

    November 15, 2016 at 3:37 am

    #1912432

  • RE: what is compile wait resource and how to resolve it

    farax_x (11/15/2016)

    Are the wait times long?

    less than a second (about 8 miliseconds)

    That's pretty low. Is this wait causing a problem?

    What is the session that's waiting trying to do?

    The applications(8 apps)...

    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 15, 2016 at 3:27 am

    #1912429

  • RE: what is compile wait resource and how to resolve it

    The procedure is being compiled by the query optimiser to generate plans.

    Is this a common wait? Are the wait times long? What is the session that's waiting 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

    November 15, 2016 at 3:10 am

    #1912425

  • RE: Tables that start with "DIM" missing in AdventureWorksDatabase2012 - Please help

    I suspect you downloaded the incorrect DB.

    AdventureWorks2014 doesn't have any DIM named tables in it, as it's an OLTP demo database. The AdventureWorksDW database is the sample data warehouse 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

    November 15, 2016 at 12:36 am

    #1912395

  • RE: Interleaving DDL and DML

    Most of those recommendations date back to SQL 2000, where recompilation was at the batch (procedure) level. Since SQL 2005 we've had statement-level recompile, which makes interleaving DDL & DML...

    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 15, 2016 at 12:31 am

    #1912394

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (11/14/2016)

    I used to have the same problem in Iceland, blazing fast local but anything else would be crawling, here in London I'm getting around 985Mbs on the download...

    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 15, 2016 at 12:13 am

    #1912393

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (11/14/2016)

    GilaMonster (11/14/2016)

    Steve Jones - SSC Editor (11/14/2016)

    I would be happy to make you a moderator, but it consumes lots of bandwidth. The #$%#$@# way the forums are setup...

    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 14, 2016 at 11:08 am

    #1912326

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (11/14/2016)

    I would be happy to make you a moderator, but it consumes lots of bandwidth. The #$%#$@# way the forums are setup is you'll get...

    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 14, 2016 at 7:44 am

    #1912263

  • RE: Insert into table

    Distinct applies to the entire row, not individual columns.

    If there are multiple values of Col1 and Col5 for a single (repeated) value in Col2, what do you want inserted?

    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 14, 2016 at 1:47 am

    #1912176

  • RE: DBCC CHECKALLOC returns errors

    Depending on how long this has been in the DB, you have two options:

    1) Restore a clean backup and all transaction log backups since that, to get the DB back...

    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 14, 2016 at 12:17 am

    #1912160

  • RE: Are the posted questions getting worse?

    Jeff Moden (11/13/2016)

    GilaMonster (11/13/2016)

    Ed Wagner (11/12/2016)

    I just hid a bunch

    How???

    I'm sick of just reporting them and having the spam hang around for hours afterwards

    Ask Steve to give you the privs...

    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 14, 2016 at 12:09 am

    #1912159

  • RE: Are the posted questions getting worse?

    Ed Wagner (11/12/2016)

    I just hid a bunch

    How???

    I'm sick of just reporting them and having the spam hang around for hours afterwards

    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 13, 2016 at 12:53 am

    #1912102

  • RE: reindex maintenance plan failed in sql 2008 (An item with the same key has already been added)

    I'm going to guess it's a bug in the portion of SSIS that executes maintenance plans (since, on second look, it looks like it might be a .net error)

    Patch 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

    November 13, 2016 at 12:50 am

    #1912101

  • RE: duration in extended event not working properly

    Dynamic 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 12, 2016 at 1:21 pm

    #1912076

  • RE: duration in extended event not working properly

    The times in XE are datetime2 and durations are bigints, so the properties of the datetime datatype are irrelevant. I wouldn't say it's accurate to the microsecond though, there's going...

    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 12, 2016 at 9:06 am

    #1912063

Viewing 15 posts - 2,101 through 2,115 (of 49,552 total)