Forum Replies Created

Viewing 15 posts - 19,141 through 19,155 (of 49,552 total)

  • RE: Msg 257, Level 16, State 3, Procedure procReceiveDeadLock_Graph, Line 28 Implicit conversion from data type xml to nvarchar(max) is not allowed. Use the CONVERT function to run this query.

    To start, this is line 28 (the line that the error message indicates)

    INSERT dbo.tblDeadLock_Log (DeadLock_Detected, DeadLock_Graph)

    VALUES (@event_datetime, @deadlock_graph)

    So, check the data types of the columns in the table, check 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

    April 13, 2012 at 1:30 pm

    #1473460

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/13/2012)

    GilaMonster (4/13/2012)

    Someone to keep an eye on: http://www.sqlservercentral.com/Forums/UserInfo953430.aspx

    Any particular reason or just general principles?

    Just a feeling. Vagueish questions, little response to replies...

    Not saying there's a problem, but might...

    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

    April 13, 2012 at 1:26 pm

    #1473457

  • RE: Update a column value for system table

    Pink123 (4/13/2012)

    Thanks but if I want to set the update date as some date in past ,how do I do that?

    Short of playing with the machine date (which will likely...

    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

    April 13, 2012 at 1:24 pm

    #1473456

  • RE: Are the posted questions getting worse?

    Someone to keep an eye on: http://www.sqlservercentral.com/Forums/UserInfo953430.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

    April 13, 2012 at 1:02 pm

    #1473436

  • RE: Update a column value for system table

    You have to alter the login to change the date. The system tables cannot be directly updated.

    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

    April 13, 2012 at 12:11 pm

    #1473406

  • RE: fetching date from 1 sp to another

    Again, you cannot insert into a function.

    Insert the missing dates into the base table.

    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

    April 13, 2012 at 12:02 pm

    #1473402

  • RE: fetching date from 1 sp to another

    You can't insert into a function as you're trying here

    INSERT INTO fitem4 (@ReportData1)(IRRReal)

    SELECT IRR FROM fitem(@ReportData1)pb WHERE @DATE1 = pb.FromDate

    and ThruDate = DATEADD(MONTH,1,@DATE1)

    Your code has so many syntax errors 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

    April 13, 2012 at 11:53 am

    #1473391

  • RE: Update a column value for system table

    No, the system tables cannot be updated. Besides, syslogins is not a table, it's a view.

    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

    April 13, 2012 at 11:23 am

    #1473361

  • RE: Compatibility level

    Because the only thing that compatibility mode controls is how the query processor interprets some T-SQL constructs. It does not affect new features, it does not affect database structure.

    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

    April 13, 2012 at 10:17 am

    #1473335

  • RE: CAREER ADVICE: Applying for DBA Jobs?

    mtassin (4/13/2012)

    GilaMonster (4/12/2012)

    Henrico Bekker (4/12/2012)

    for your question on the ML pages -> Nasty....do they ever take a guess? 25, 125, 1025? do they ever mention BL mode for ML Pages?...

    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

    April 13, 2012 at 7:56 am

    #1473257

  • RE: Verifying Estimated Execution Plan results

    Without seeing the entire exec plan, no way to tell.

    Check what statistics IO and statistics time tell you. If the reads are down and the duration is down, the performance...

    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

    April 13, 2012 at 6:16 am

    #1473177

  • RE: Are the posted questions getting worse?

    Same reason the missing index DMVs see fit to recommend multiple duplicates and indexes including the entire table. They're solely about 'what's the absolute best index for this query'

    Also, so...

    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

    April 13, 2012 at 5:26 am

    #1473152

  • RE: How do i drop identity for a Column

    patelmohamad (4/13/2012)

    Koen Verbeeck (4/13/2012)

    Drop the identity column and add a simple integer column with the same name.

    Hi Koen,

    Please read my question then suggest some better solution,

    There isn't a 'better suggestion',...

    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

    April 13, 2012 at 4:30 am

    #1473122

  • RE: Faultfinding possible I/O issues

    What about the windows event logs?

    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

    April 13, 2012 at 4:14 am

    #1473119

  • RE: Faultfinding possible I/O issues

    Nothing in any of the error logs?

    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

    April 13, 2012 at 3:26 am

    #1473106

Viewing 15 posts - 19,141 through 19,155 (of 49,552 total)