Forum Replies Created

Viewing 15 posts - 361 through 375 (of 380 total)

  • RE: What will convert return?

    Jeff Moden (7/11/2013)


    Even though the explanation of exceeding the max INT value is completely wrong, I'm absolutely amazed that more than 1/3 of the people that answered this question got...

  • RE: What will convert return?

    Bajrang (7/10/2013)


    Comments posted to this topic are about the item <A HREF="/questions/Convert/100444/">What will convert return?</A>

    Good Question but your explination nees work.

    declare @value int

    set @value = 2147483647

    PRINT @value

    PRINT CONVERT(varchar(6), @value)

    set...

  • RE: SSIS error when configuring data flow task with .xls file

    JoshuaT (7/10/2013)


    I want to first thank everyone for your time and assistance. I really appreciate it!

    I recreated my package and .xls file and in doing so I found that my...

  • RE: SQL Server 2012 Concat

    Nice question. On of the first editions of the .NET data libraries had NULL value operator and could not read or assign NULL to a value.

    IMHO - NULL values...

  • RE: Login failure to SQL instance in 2012

    Check the steps in this article on execution with Proxy for just xp_cmdshell:

    http://msdn.microsoft.com/en-us/library/ms175046.aspx/css

    Just turning on xp_cmdshell is not enough on 2012.

    You should look at these articles also:

  • RE: SSIS error when configuring data flow task with .xls file

    I would recomend a reinstall or install of the SSDT for VS 2010 at this point. Also is this the server or your development system that this is occuring...

  • RE: Login failure to SQL instance in 2012

    What happens if you drop and recreate the account?

    When you create an Account the SID gets imported from AD, could be something in AD or the SQL instance changed and...

  • RE: SSIS error when configuring data flow task with .xls file

    JoshuaT (7/8/2013)


    The file is valid. I can open in Excel on a local machine without an issue.

    I receive the error in the "Excel Source Editor" when clicking on "Columns"....

  • RE: DATABASE SLOW

    I have the perfect answer for your question as you asked it.

    Find a DBA and have them look at it.

    Your question and the way it was asked is like...

  • RE: Back to basics

    Wow... One thing about Bitwise operaters is certain.

    It is easy to read these posts and know who understands them completely and who is lost.

    This would make for a great Article......

  • RE: Quickly Copy Data

    Michael Valentine Jones (6/7/2013)


    Jeff Moden (6/7/2013)


    PHYData DBA (6/7/2013)


    Does this count as using compression?

    using rar instead of xcopy to speed up the network transfer?

    Once we had to move an entire JDE...

  • RE: Quickly Copy Data

    Does this count as using compression?

    using rar instead of xcopy to speed up the network transfer?

    Once we had to move an entire JDE 8.X database with 12 years of data...

  • RE: Quickly Copy Data

    I think this falls under not normal.

    I have had to resolve this for a number of DB solutions and reasons.

    Ever since SQL 2005 was new I used publishing...

  • RE: Assigning categories to values 1

    srienstr (5/15/2013)


    I agree completely on the semantic meaning, and lack of a compelling reason for that difference. That said, we don't want to let semantic English creep into SQL...

  • RE: Assigning categories to values 1

    Hugo Kornelis (5/15/2013)


    Hate SQL Server? Me?

    Oh no, not at all. I love it! I'm sorry if I come across as thrasing it, that's not my intention at all! 😉

    To answer...

Viewing 15 posts - 361 through 375 (of 380 total)