Forum Replies Created

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

  • RE: Query maxing out 24 CPUs

    Ninja's_RGR'us (9/20/2011)

    Not 100% sure if the plan in cache has that info, I would guess it does (I don't usually use that to pull out plans).

    No, it doesn't.

    If 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

    September 20, 2011 at 11:14 am

    #1384028

  • RE: Alert based Transaction log backup job

    Once more with feeling...

    GilaMonster (9/13/2011)

    If you have regular log backups and the log fills, it's probably filling for some reason other than needing a log backup. Like active transaction,...

    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

    September 20, 2011 at 10:04 am

    #1383965

  • RE: How a db_user has all kind of permissions, although I didn't given?

    sporoy (9/20/2011)

    So all users are member of public role implicitly?

    Yup, that's why it's called 'public'

    May I suggest, shoot your developers, then get them to fix this mess (and maybe shoot...

    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

    September 20, 2011 at 8:43 am

    #1383886

  • RE: Query maxing out 24 CPUs

    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

    September 20, 2011 at 7:53 am

    #1383856

  • RE: How a db_user has all kind of permissions, although I didn't given?

    Is that login the database owner? Is it a member of a fixed server role?

    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

    September 20, 2011 at 7:34 am

    #1383847

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (9/20/2011)

    Does this work? (my apologies for posting code on the Thread)

    USE tempdb

    GO

    CREATE FUNCTION test()

    RETURNS TABLE

    AS

    RETURN (

    WITH sampleData (Num) AS (

    SELECT 1

    UNION ALL

    SELECT 2

    )

    SELECT *

    FROM sampleData

    )

    GO

    SELECT * FROM...

    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

    September 20, 2011 at 6:19 am

    #1383786

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (9/20/2011)

    GilaMonster (9/20/2011)

    Brandie Tarvin (9/20/2011)

    CTEs (i.e. ;WIth () ... SELECT ) are single statements in this context, yes?

    <pedantic>

    CTEs don't start with a ';', no more than an english...

    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

    September 20, 2011 at 6:18 am

    #1383782

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (9/20/2011)

    That's true only for the first phrase in any documents / books :-D.

    And then again, the last thing you read ended with a period.

    /pedantic :hehe:.

    .Really?

    .So this would be...

    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

    September 20, 2011 at 6:00 am

    #1383760

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (9/20/2011)

    CTEs (i.e. ;WIth () ... SELECT ) are single statements in this context, yes?

    <pedantic>

    CTEs don't start with a ';', no more than an english sentence starts with...

    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

    September 20, 2011 at 5:52 am

    #1383754

  • RE: High CPU/IO

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    September 20, 2011 at 4:41 am

    #1383718

  • RE: Dead lock issue

    You're barking up the complete wrong tree.

    If you have no idea where to start, get a specialist in to help. Or

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    September 20, 2011 at 4:41 am

    #1383715

  • RE: Deadlock event

    free_mascot (9/20/2011)

    Enable traceflag 3605 which will help you to capture the information in sql log.

    All 3605 does is redirect certain output (like DBCC Page) to the error log. It's...

    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

    September 20, 2011 at 4:26 am

    #1383702

  • RE: Dead lock issue

    Hang on...

    What is your question here? What is your problem? You're jumping around from topic to topic and I can't figure out what the root problem 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

    September 20, 2011 at 4:21 am

    #1383700

  • RE: How to turn off the checking if the column exists

    The error comes from the algrebiser as it binds the query to the objects involved, it appears before execution, that's why the EXISTS doesn't help

    You can change the select 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

    September 20, 2011 at 2:48 am

    #1383674

  • RE: Multiple TempDB Files (Data & Log)

    uncle_boris (9/19/2011)

    2. The report also mentioned doing the same for the TempDB log files. I have read that unless the max size of a log file is going to be...

    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

    September 20, 2011 at 2:45 am

    #1383672

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