Forum Replies Created

Viewing 15 posts - 18,256 through 18,270 (of 49,552 total)

  • RE: Zeroing out bad block?

    And checkDB completes successfully on the copy once the block has been marked bad?

    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

    June 5, 2012 at 7:34 am

    #1497043

  • RE: Is this a network speed Issue?

    See my post directly above.

    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

    June 5, 2012 at 7:23 am

    #1497035

  • RE: Transaction Log doesn't grow!!!!

    johntaylor (6/5/2012)

    I have no backups going (data or log).

    There's the reason.

    Until there is a full backup to start the log chain, the database behaves as though it were in simple...

    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

    June 5, 2012 at 7:04 am

    #1497026

  • RE: View with Parameter??

    You can't use dynamic SQL in a function.

    Going to have to go procedure with this.

    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

    June 5, 2012 at 6:54 am

    #1497018

  • RE: Query tuning - Left Join vs. Inner Join vs. main table select

    pdanes (6/5/2012)

    GilaMonster (6/5/2012)

    It has nothing whatsoever to do with performance. The meaning of the two queries is different. That's why you're getting different execution plans.

    But Gail, they both produce EXACTLY...

    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

    June 5, 2012 at 5:18 am

    #1496976

  • RE: Is this a network speed Issue?

    SSMS is badly written. Seriously, it's written in a way that causes Async network IO waits as SQL waits to send the results and that's regardless of whether it's on...

    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

    June 5, 2012 at 5:02 am

    #1496973

  • RE: Steps to find out / Resolve SQL Server High RAM usage in SQL Server 2008.

    High memory usage is typically what you want, it means SQL is using the resources on the server.

    Chapter 4: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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

    June 5, 2012 at 5:00 am

    #1496969

  • RE: Query tuning - Left Join vs. Inner Join vs. main table select

    It has nothing whatsoever to do with performance. The meaning of the two queries is different. That's why you're getting different execution plans.

    Simplified example:

    CREATE TABLE #t1 (

    ColourID INT IDENTITY...

    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

    June 5, 2012 at 4:26 am

    #1496955

  • RE: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '.'.

    ramsai1973 (6/5/2012)

    select * from (select * from UserProductivityMapping) wk.WeekStartDate

    pivot(sum(PercentageProductivity) for wk.WeekStartDate

    in ([2013-01-05],[2013-01-12],[2013-01-19],[2013-01-26])) as pivottable

    There's your problem. Table Aliases can't have dots in them. Alias the subquery wk and assuming there'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

    June 5, 2012 at 3:12 am

    #1496940

  • RE: Does a full backup truncate the log?

    Please note: 4 year old thread

    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

    June 5, 2012 at 3:09 am

    #1496939

  • RE: View with Parameter??

    What you're asking for is an in-line table-valued function.

    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

    June 4, 2012 at 2:49 pm

    #1496778

  • RE: What is the perfect Index , in this special case

    Perry Whittle (6/4/2012)

    GilaMonster (6/4/2012)

    I'm not a fan of columns with multiple data values in them, or columns I need to do bitwise operations on. With the current design it's trivial...

    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

    June 4, 2012 at 2:20 pm

    #1496761

  • RE: Improve performace of a simple query

    First thing, get rid of those functions. Data-accessing scalar UDFs are performance nightmares. Use an inline table-valued UDF or a subquery to get the lists.

    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

    June 4, 2012 at 2:18 pm

    #1496759

  • RE: Improve performace of a simple query

    Execution plan please

    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

    June 4, 2012 at 2:04 pm

    #1496747

  • RE: Query tuning - Left Join vs. Inner Join vs. main table select

    pdanes (6/4/2012)

    When you say join ON something, you have to say what in each table is to be the link.

    No you don't.

    This is perfectly legal and valid.

    SELECT *...

    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

    June 4, 2012 at 2:01 pm

    #1496742

Viewing 15 posts - 18,256 through 18,270 (of 49,552 total)