Forum Replies Created

Viewing 15 posts - 32,056 through 32,070 (of 49,552 total)

  • RE: Job failing due to deadlocking

    Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.

    DBCC TRACEON(1222,-1)

    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

    July 1, 2010 at 1:32 pm

    #1187877

  • RE: DMV access to non-admin account

    J.D. Gonzalez (7/1/2010)

    On a related note, I tried to use SSMS to give permissions to the underlying DMV's but it complained about having to do this in master. I...

    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

    July 1, 2010 at 1:11 pm

    #1187873

  • RE: I really need some recommendations for this query

    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

    July 1, 2010 at 1:05 pm

    #1187870

  • RE: issue w/ "not in" in my where

    http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

    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

    July 1, 2010 at 12:58 pm

    #1187867

  • RE: Deleting temp tables in the system "tempdb".

    zeeaay (7/1/2010)

    well it is the same question, same issue and I have just added that I have tried all of the above still no success.

    I can still post new but...

    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

    July 1, 2010 at 12:53 pm

    #1187862

  • RE: WTF?? concatenating Date and time varchar fields messes up the milliseconds!!

    mberry 51447 (7/1/2010)

    Still doesnt help with Milliseconds.

    So basically I am SOL without 2008:(

    Store as a varchar, display as a varchar, hope that you don't need any date manipulation.

    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

    July 1, 2010 at 12:50 pm

    #1187859

  • RE: Are the posted questions getting worse?

    Can someone please help out here? i thought it might be the TokenAndPermUserStore problem, but it doesn't appear so. Don't want ppl to think that that because there's a ot...

    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

    July 1, 2010 at 11:13 am

    #1187817

  • RE: Deleting temp tables in the system "tempdb".

    Please post new questions in a new thread and give as much in the way of details as you can.

    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

    July 1, 2010 at 11:12 am

    #1187814

  • RE: SQL 2005 SP2 Enterprise Slowness

    As I mentioned before, query sys.dm_exec_requests. The particular column you're looking for is wait_type

    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

    July 1, 2010 at 11:11 am

    #1187813

  • RE: Object Owner Changes to Database System Objects

    Direct updates should NEVER be done to the system tables. It's all too easy to break lots of things and not realise until far too late.

    When you have a little...

    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

    July 1, 2010 at 11:10 am

    #1187811

  • RE: SQL 2005 SP2 Enterprise Slowness

    No, that's 2 MB. Problems (in my experience) start around 1 GB. Do you have queries waiting on CMEMTHREAD? If not, then you have a different problem

    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

    July 1, 2010 at 10:52 am

    #1187796

  • RE: SQL 2005 SP2 Enterprise Slowness

    jason.nodarse (7/1/2010)

    Also what command can I run to see if the CMemThread memory is being maxed out?

    There's no such thing as CMEMTHREAD memory. CMEMTHREAD is a wait type....

    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

    July 1, 2010 at 10:10 am

    #1187769

  • RE: Row Layout and Char vs. Varchar Tradeoffs

    Bill Nicolich (7/1/2010)

    Any thoughts on how the ordinal position of char vs varchar might affect indexes?

    Ordinal position in the index or in the base table?

    For ordinal position in 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

    July 1, 2010 at 10:04 am

    #1187764

  • RE: Restore without having a backup

    Sorry, no backup, no rollback. To undo a change, you need a backup from before the change that you're trying to undo.

    If the DB has not been backed up, I'd...

    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

    July 1, 2010 at 9:56 am

    #1187758

  • RE: script to grant execute permission if missing

    Why check first? Granting permission doesn't fail if the user already has permission.

    If you really want, you should be able to hack up a query based on sys.database_principals and sys.database_permissions

    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

    July 1, 2010 at 9:33 am

    #1187739

Viewing 15 posts - 32,056 through 32,070 (of 49,552 total)