Forum Replies Created

Viewing 15 posts - 15,076 through 15,090 (of 49,552 total)

  • RE: READ_COMMITTED_SNAPSHOT & TRUNCATE TABLE

    Sean Lange (12/26/2012)

    The locking you are seeing is because of lock escalation.

    It's not lock escalation.

    Truncate table locks at the table level because there's no other sensible level to lock...

    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

    December 26, 2012 at 1:04 pm

    #1571651

  • RE: NOT EXISTS - tortoise or horse ?

    http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

    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

    December 26, 2012 at 1:03 pm

    #1571650

  • RE: Ask for help in index

    idyana (12/26/2012)

    How do I want to make both of them (State and City) is Index Seek?

    You can't.

    A seek requires something to search for. Something to filter on. Your query requests...

    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

    December 26, 2012 at 1:00 pm

    #1571649

  • RE: Stored Procedure looses execution plan.

    It's probably got nothing whatsoever to do with the cached execution plan. The optimiser is not allowed (in most cases) to spend minutes optimising a query.

    What's probably causing the slow-down...

    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

    December 26, 2012 at 12:56 pm

    #1571648

  • RE: Fragmentation size

    zi (12/26/2012)

    1-1-How to know the fragmentation size for whole database not only for certain table, to decide if it exexceeds 30% to re-build index or re-organise.

    Databases don't have fragmentation. Indexes...

    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

    December 26, 2012 at 12:53 pm

    #1571646

  • RE: Are the posted questions getting worse?

    Box set of Star Trek: The Next Generation DVDs. All seasons.

    You guys don't need me for the next month or so, do you?

    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

    December 26, 2012 at 12:49 pm

    #1571644

  • RE: Hardware or Bad Queries = Performance issues?

    Lynn Pettis (12/24/2012)

    Aren't logical reads reads from data cached in memory?

    Yes

    Would these be good reads as SQL Server doesn't have to go to disk to get the data?

    Maybe. 🙂

    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

    December 26, 2012 at 12:48 pm

    #1571643

  • RE: Log File Size Issue

    SQLCrazyCertified (12/24/2012)

    Some times you need to do log backups couple of times in order for the inactive logs to be truncated.

    Not if the DB is in simple recovery, which 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

    December 26, 2012 at 12:46 pm

    #1571641

  • RE: File Size

    A once-off shrink to a sensible size (not as small as possible), then rebuild all indexes.

    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

    December 24, 2012 at 7:07 am

    #1571274

  • RE: SQL Server consuming 90% Memory

    That's perfectly normal, expected behaviour. SQL will use as much memory as it can to improve performance.

    If it's using too much, lower max server memory, and inform the windows team...

    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

    December 24, 2012 at 5:37 am

    #1571259

  • RE: Forum Etiquette: How to post data/code on a forum to get the best help

    Please post your problem in a new thread. Thanks

    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

    December 24, 2012 at 5:33 am

    #1571258

  • RE: download sql server management studio RTM 9.00 1399.00

    You can't just download SSMS (other than the express version). Install it off the SQL Server 2005 installation disks

    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

    December 24, 2012 at 1:11 am

    #1571236

  • RE: Are the posted questions getting worse?

    Jeff Moden (12/23/2012)

    I don't know about the rest of you, but the amount of SPAM posts on SSC seems to be growing. I even got SPAMmed on my PM...

    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

    December 24, 2012 at 1:08 am

    #1571235

  • RE: select where searchvalues are in list

    Dynamic SQL (watch for SQL injection) or a string splitter function. I recommend the latter. Search this site for 'Delimited8kSplit'

    Oh, and as for why your attempt failed, that equates 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

    December 23, 2012 at 7:33 am

    #1571183

  • RE: TLOG GROWING VERY LARGE

    shohelr2003 (12/23/2012)

    Imagine that I take one full backup at the beginning of the day and later on take four log backups at two hours interval and again take another full...

    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

    December 23, 2012 at 2:44 am

    #1571174

Viewing 15 posts - 15,076 through 15,090 (of 49,552 total)