Forum Replies Created

Viewing 15 posts - 8,116 through 8,130 (of 8,760 total)

  • RE: Cardinality Regression

    d. There is nothing you can do except update your resume

    Smells like irony...:-P

    😎

  • RE: Cardinality Regression

    TomThomson (6/1/2014)


    When I saw this, I found myself wondering if this were the documentation bug again or not? It could be a trick question, where the "correct" answer was...

  • RE: Cardinality Regression

    Igor Micev (6/1/2014)


    Confusion!?

    2312 - http://support.microsoft.com/kb/2801413

    Use when running SQL Server 2014 with database compatibility level 110, which is the compatibility level for SQL Server 2012. Trace flag 2312 forces the query...

  • RE: SSIS PROBLEM

    Have you implemented the changes suggested by myself and Steve?

    Few questions:

    1. Do you use variable(s) to hold the date and time value during the processing of each file?

    2. Are you...

  • RE: SQL Server error handling

    Check out this article XML Schema validation in SQL Server[/url], the last part demonstrates similar error handling.

    😎

  • RE: Cardinality Regression

    Good question, thanks Steve.

    😎

    Still some confusion in the documentation at support.microsoft.com:

    The following plan affecting trace flags are available in Microsoft SQL Server 2014:

    9481

    Use when running SQL Server 2014 with the...

  • RE: SSIS PROBLEM

    baddulas (5/31/2014)


    Hi Eirikur Eiriksson,

    I am using Hours and Minutes and Seconds that's why it is changing.

    If you look at the error message, it says

    D:\ZIPPINGFILE\20140528_225754.txt.zipD:\FLATFILEGENERATE\20140528_225754

    when it should be

    D:\ZIPPINGFILE\20140528_225754.txt.zip D:\FLATFILEGENERATE\20140528_225754

    Add as space...

  • RE: Sp & parameters

    ramana3327 (5/31/2014)


    Hi thanks for your reply.

    Code is confidential. So I am unable to provide the execution plan but I can explain what is the problem.

    I have a Stored procedure and...

  • RE: Vulnerability scan report

    You have to look at which kind of threats these vulnerabilities are! If it is a local one, normally you would have more problems already as the attacker would need...

  • RE: SSMS 2014 - anything new and noteworthy over SSMS 2012?

    The most noticeable thing so far is that it is ......:arrow:faster!

    😎

  • RE: SSIS PROBLEM

    baddulas (5/31/2014)


    Hi Steve,

    I am getting following error.

    [Execute Process Task] Error: In Executing "C:\Program Files\WinRAR\Rar.exe" "a D:\ZIPPINGFILE\20140528_225754.txt.zipD:\FLATFILEGENERATE\20140528_225754" at "D:\FLATFILEGENERATE\", The process exit code was "9" while the expected was "0".

    Looks like...

  • RE: Sp & parameters

    Quick question, can you provide the procedure source code and the execution plans? As Jeff said earlier, without further information it is hard to tell what is going on?

    Furthermore do...

  • RE: Sp & parameters

    Jeff Moden (5/30/2014)


    Eirikur Eiriksson (5/30/2014)


    Unfortunately that's not too useful, it will show if the parameter is nullable but that's about it.

    I just love fully documented and supposedly supported features that...

  • RE: Sp & parameters

    Jeff Moden (5/30/2014)


    ramana3327 (5/30/2014)


    Hi,

    I am working with SP. How can we find out values of parameters when the SP is executed with the default values?

    If I understand your question correctly,...

  • RE: Sp & parameters

    ramana3327 (5/30/2014)


    Hi,

    I am working with SP. How can we find out values of parameters when the SP is executed with the default values?

    You will have to dissect the procedure as...

Viewing 15 posts - 8,116 through 8,130 (of 8,760 total)