Forum Replies Created

Viewing 15 posts - 5,896 through 5,910 (of 8,753 total)

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (3/30/2015)


    Jeff Moden (3/27/2015)


    BWAAA-HAAA!!!!! SPAM REPORTED!!! ๐Ÿ˜€

    Ha, you're jealous because I ignored Detroit.

    Nah, he knows better;-)

    ๐Ÿ˜Ž

  • RE: CTE Syntax

    Steve Jones - SSC Editor (3/30/2015)


    It's only to let someone easily cut/paste code and exclude the semi-colon.

    I do try to provide good code samples with semi-colons in them to help...

  • RE: The Worst Comments

    Nevyn (3/30/2015)


    -- Do some magic

    This reminded me of a comment I used to use as an "off-limits marker" in the old days

    /* HC SVNT DRACONES */

    ๐Ÿ˜Ž

  • RE: Tally OH! An Improved SQL 8K โ€œCSV Splitterโ€ Function

    Tossing in my 2 Cents, I feel the NULL/Nothing/Unknown/Empty discussion is digressing towards the ancient NULL debate.

    ๐Ÿ˜Ž

    Given the un-pivotal nature of the function, which produces a pseudo table with...

  • RE: Tally OH! An Improved SQL 8K โ€œCSV Splitterโ€ Function

    TomThomson (3/30/2015)


    Jeff Moden (3/30/2015)


    I understand that many languages and products treat NULLs differently and that we have to jump whatever hoop is held up for us in that area but...

  • RE: How to quickly update/insert 3M records in a large table?

    Jeff Moden (3/30/2015)


    Jason-299789 (3/30/2015)


    I would also suggest that the key on both the destination table is clustered it should make the process significantly faster. so something like.

    "It Depends". Unless...

  • RE: CTE Syntax

    Luis Cazares (3/30/2015)


    Eirikur Eiriksson (3/30/2015)


    ;With due respect, additional and extra semicolons between statements will not cause any problems and CTE statements will run, without the semicolon it will not.

    ๐Ÿ˜Ž

    I beg...

  • RE: CTE Syntax

    ;With due respect, additional and extra semicolons between statements will not cause any problems and CTE statements will run, without the semicolon it will not.

    ๐Ÿ˜Ž

  • RE: SSAS Tabular Model

    imrannimran (3/29/2015)


    Hi everyone;

    I am trying to learn building SSAS tabular model. While following a tutorial I need to add a column to an existing table but for some reason the...

  • RE: SQL 2012: SP2 CU5 will not install

    SQL_ME_RICH (3/29/2015)


    Hello -

    I am in the midst of testing out a migration for SQL 2012 servers from SP1 to SP2, and am trying to get them to CU5, but...

  • RE: Adding Minutes(varchar) to a datetime field

    Jeff Moden (3/29/2015)


    From your example, it would appear that this is more of a risk in explicit conversions than the implicit ones, in this case.

    I know I'm not doing a...

  • RE: CTE Syntax

    Thanks for the question Steve!

    Now I can see yet another discussion on Terminators vs. Beginingnators coming, must say I'm with the latter as my muscle memory punches a semicolon whenever...

  • RE: Unable to Connect To SQL Server DB Instance if Port Number is not Included

    Check if UDP port 1434 is open in the firewall.

    ๐Ÿ˜Ž

  • RE: Not able to install SQL 2005 on Windows 7 (SQL server 2008 is already installed)

    pallav.sheth (3/27/2015)


    Hi,

    I am trying to install SQL server 2005 Ent edition "en_sql_2005_ent_x64_dvd.iso"(downloaded from MSDN). I am getting and error

    "Error 193 Installing .NET Framework 2.0" when installing.

    On this machine

    1. there...

  • RE: Importing Excel data, with more than 255 Characters

    Check out this excellent article by Koen Verbeeck Whatโ€™s the deal with Excel & SSIS?[/url]

    ๐Ÿ˜Ž

Viewing 15 posts - 5,896 through 5,910 (of 8,753 total)