Forum Replies Created

Viewing 15 posts - 7,591 through 7,605 (of 8,760 total)

  • RE: Trying to do an update to SQL 2012 Server database

    Quick thought, check the parameters, columns and the values data types as this is a datatype conversion error.

    😎

  • RE: difference in SSIS of standard and enterprise edition sql 2008

    Tara-1044200 (8/4/2014)


    is there any difference in features that don't get by purchasing standard edition?

    The main difference would be some components like fuzzy matching and grouping are Enterprise only, everything else...

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (8/4/2014)


    Lynn Pettis (8/4/2014)


    Whom ever has the Great Mystical Crystal Ball, you are needed here.

    I am afraid I have left it in my other coat...

    I'm relying on the ESP...

  • RE: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'INFORMATION_SCHEMA.Columns

    suresh0534 (8/4/2014)


    Hi,

    Below is the Exception:

    System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'INFORMATION_SCHEMA.Columns'.

    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

    ...

  • RE: Generating Hex on Insert

    mike 57299 (8/4/2014)


    Hi all...

    I am trying to generate a hex value automatically at time of insert. The column used for the hex # is an identity column. ...

  • RE: DBA vs Developer

    SQLRNNR (8/3/2014)


    Eirikur Eiriksson (8/3/2014)


    Jeff Moden (8/3/2014)


    TomThomson (8/3/2014)


    Jeff Moden (8/2/2014)


    Grant Fritchey (7/16/2014)


    You mean you didn't flip the infinity switch on your tempdb? That developer is right, you have it configured incorrectly.

    Heh......

  • RE: Converting Hour and Minute to Decimal

    Jeff Moden (8/2/2014)


    Eirikur Eiriksson (8/2/2014)


    The datetime format is still the same upto and including 2014.

    😎

    Thanks Eirikur. I've never looked at it but figured it might be so. That...

  • RE: DBA vs Developer

    Jeff Moden (8/2/2014)


    Grant Fritchey (7/16/2014)


    You mean you didn't flip the infinity switch on your tempdb? That developer is right, you have it configured incorrectly.

    Heh... what's really cool about Grant is...

  • RE: DBA vs Developer

    Jeff Moden (8/3/2014)


    TomThomson (8/3/2014)


    Jeff Moden (8/2/2014)


    Grant Fritchey (7/16/2014)


    You mean you didn't flip the infinity switch on your tempdb? That developer is right, you have it configured incorrectly.

    Heh... what's really cool...

  • RE: indexing a table having million of records

    LutzM (8/3/2014)


    after a semi-internal discussion the answer we agreed on is:

    Yes.

    If you need a more detailed answer please provide a more detailed question.

    Seriously? I thought that this time it was...

  • RE: How to replace null value in a query

    Please to read the links Lynn provided, it makes things so much easier if one has a proper structure and data sample.

    For the fun of it (and feeling lucky...

  • RE: Resume font ?

    If the appearance of the resume adds a value to it then selecting a font isn't enough. One should properly layout the document using the likes of Scribus, InDesign or...

  • RE: Are the posted questions getting worse?

    Where was that Crystal Ball again when one needs it, certain I've seen it somewhere...

    😎

  • RE: How to replace null value in a query

    Further on Lutz's last post, the solution to your problem is down to the actual, literal and exact data, at this point without the actual, literal and exact data...

  • RE: How to replace null value in a query

    The only modification I made to Lutz's code was to add the NULLIF, set to return NULL (Empty/Unknown) if the string value 'NULL' (four letter word) appears in the column.

    😎

Viewing 15 posts - 7,591 through 7,605 (of 8,760 total)