Forum Replies Created

Viewing 15 posts - 23,371 through 23,385 (of 49,552 total)

  • RE: avg disk queue length

    Ignore it. It's a useless counter these days (and has been for several years to be honest). There's too much between the server and the drives (especially with a SAN)...

    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 21, 2011 at 2:10 pm

    #1384794

  • RE: After SQL 2005 Upgrade my SQL Version is still 8.0

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

    cmorris 6147 (9/21/2011)

    Screen shot attached.

    That's the server level. That server is sql 2000.

    Which is the point of the question, that an (apparently) upgraded server is still the old...

    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 21, 2011 at 11:41 am

    #1384714

  • RE: After SQL 2005 Upgrade my SQL Version is still 8.0

    Are you sure you're connecting to the right instance?

    Did you do an in-place upgrade or did you install SQL 2005 alongside SQL 2000?

    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 21, 2011 at 11:36 am

    #1384704

  • RE: Running SQL server 2008R2 on Hyper-V crashed sql server.

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1178814-1550-1.aspx

    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 21, 2011 at 10:41 am

    #1384668

  • RE: Interview Question

    Matt Miller (#4) (9/21/2011)

    (: Hakuna Matata 🙂 (9/21/2011)

    Gianluca Sartori (9/21/2011)

    (: Hakuna Matata 🙂 (9/21/2011)

    Can we rollback if we use truncate command??? I dont think we can rollback since truncate command...

    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 21, 2011 at 9:40 am

    #1384618

  • RE: Tempdb log not freeing up space in SQL 2000 SP4

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

    You can use the default trace to see at what time the db starts growing and then you can zoom in on the jobs that run at that time...

    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 21, 2011 at 9:13 am

    #1384587

  • RE: Tempdb log not freeing up space in SQL 2000 SP4

    Monitor SQLPerf(LogSpace). That will give you a view of used space.

    If it keeps growing check open transactions (while it's growing) and see if a checkpoint helps.

    Edit: Additionally, check DBCC...

    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 21, 2011 at 9:01 am

    #1384567

  • RE: Tempdb log not freeing up space in SQL 2000 SP4

    Shark Energy (9/21/2011)

    There is 1 job every night that uses probably 30gb of tempdb log space. But over the last few months the space doesn't seem to be reused anymore....

    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 21, 2011 at 8:46 am

    #1384547

  • RE: Tempdb log not freeing up space in SQL 2000 SP4

    ps. (9/21/2011)

    GilaMonster (9/21/2011)

    ps. (9/16/2011)

    also, once any data/log file reaches a particular size, it wont free up space on it's own.

    Errr, what???

    Doesn't matter how large a log gets, assuming nothing 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 21, 2011 at 8:44 am

    #1384544

  • RE: Tempdb log not freeing up space in SQL 2000 SP4

    ps. (9/16/2011)

    also, once any data/log file reaches a particular size, it wont free up space on it's own.

    Errr, what???

    Doesn't matter how large a log gets, assuming nothing is preventing log...

    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 21, 2011 at 8:32 am

    #1384528

  • RE: Interview Question

    (: Hakuna Matata 🙂 (9/21/2011)

    I dont think we can rollback since truncate command does not generate any logs.

    Common myth, completely false. Truncate (like every single other data modification in 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

    September 21, 2011 at 8:30 am

    #1384526

  • RE: How to resolve deadlock for MSSQL 2008

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

    Deadlock is mostly caused by bad code, that just doesn't fix itself with more ram.

    Poor indexing's the other main cause.

    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 21, 2011 at 8:09 am

    #1384511

  • RE: How to resolve deadlock for MSSQL 2008

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

    senfriends2008 (9/21/2011)

    i have one exprience in my office!

    Daily five or six time deadlock accurse on production server. We optimize program coding also still getting deadlock. so resarch...

    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 21, 2011 at 7:58 am

    #1384503

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

    I tested this out on my local server, modified for tables and columns that I have and it worked fine (and returned expected results). So either you have no databases...

    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 21, 2011 at 6:56 am

    #1384458

  • RE: How to resolve deadlock for MSSQL 2008

    nhphuong76 (9/21/2011)

    I ran the script "DBCC TRACEON(1222,-1)" but deadlock still appear

    Can resolve finish ?

    I never said the traceflag would fix the deadlocks, please read my post. I said

    That will result...

    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 21, 2011 at 6:45 am

    #1384451

Viewing 15 posts - 23,371 through 23,385 (of 49,552 total)