Forum Replies Created

Viewing 15 posts - 9,676 through 9,690 (of 49,552 total)

  • RE: Records suddenly disappear from fn_dblog in SQL Server 2008

    rani_rahbani (3/14/2014)

    In the mean while I am doing this because i am asked to check every night who made insert/update/delete to a certain table and check the old data (deleted...

    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

    March 14, 2014 at 5:15 am

    #1697085

  • RE: Records suddenly disappear from fn_dblog in SQL Server 2008

    Because the database has never had a backup, it's behaving as though it's in simple recovery model. A DB in full recovery requires a full backup to initialise the 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

    March 14, 2014 at 4:10 am

    #1697074

  • RE: SP tuning

    Table definitions, index definitions (both as create statements please), execution plan please, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Which queries in the procedure are the slowest?

    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

    March 14, 2014 at 2:48 am

    #1697057

  • RE: I need to delete 20 million rows from a table...

    Jeff Moden (3/13/2014)

    You're right of course. The problem is that a lot of folks in the field think that the term "fully logged" for TRUNCATE means the same as...

    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

    March 14, 2014 at 2:47 am

    #1697055

  • RE: Are the posted questions getting worse?

    Anyone for a game of 'guess what index is on which table'?

    http://www.sqlservercentral.com/Forums/Topic1550657-391-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

    March 14, 2014 at 2:46 am

    #1697054

  • RE: Are the posted questions getting worse?

    jcrawf02 (3/13/2014)

    Do any of you guys have random people endorse you for skills, that you know they have no idea if you can do?

    Yes, all too often. Worse, 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

    March 14, 2014 at 2:45 am

    #1697053

  • RE: Are the posted questions getting worse?

    andrew gothard (3/13/2014)

    -- long url--

    Any chance you could edit 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

    March 14, 2014 at 2:36 am

    #1697050

  • RE: Performance is slow

    yuvipoy (3/13/2014)

    Due business reasons i am unable to give u the entire table definitions

    You're really not helping yourself here. Obfuscate the table, change the column names, do the same...

    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

    March 14, 2014 at 2:31 am

    #1697049

  • RE: Reset memory cache for query tuning?

    MyDoggieJessie (3/13/2014)

    Or, if it's a procedure being executed, you could add "WITH RECOMPILE" - so an entirely new execution plan is generated each time. I would only use 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

    March 13, 2014 at 8:31 am

    #1696818

  • RE: Performance is slow

    yuvipoy (3/13/2014)

    can u peoples help on urgent basis

    If you posted what was asked, maybe.

    Table definitions please, index definitions and the xml plan would make things a hell of a lot...

    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

    March 13, 2014 at 8:10 am

    #1696801

  • RE: Suspect Databases

    Suspect status occurs when SQL encounters corrupt or damaged pages in the database during a rollback or crash recovery. It could be that some of the writes which SQL had...

    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

    March 13, 2014 at 7:48 am

    #1696776

  • RE: Indexes query

    zedtec (3/13/2014)

    If you have a heap table which has non-clustered indexes, does this mean it will always do a full table scan?

    No.

    What if you had a primary key in your...

    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

    March 13, 2014 at 7:35 am

    #1696770

  • RE: Performance is slow

    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

    March 13, 2014 at 7:08 am

    #1696755

  • RE: Deadlocks - SQL Server Monitors for Deadlocks Right?

    MyDoggieJessie (3/12/2014)

    If you want to see more detailed information on what caused the deadlock and which one was the deadlock victim, you can have them written to the error 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

    March 13, 2014 at 6:55 am

    #1696747

  • RE: Encrypt All Procedures At a Time

    Lowell's told you how to do it. If you want a script run once off to encrypt all procedures, write one up that does what he said.

    Why are you going...

    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

    March 13, 2014 at 5:16 am

    #1696700

Viewing 15 posts - 9,676 through 9,690 (of 49,552 total)