Forum Replies Created

Viewing 15 posts - 1 through 15 (of 46 total)

  • RE: The Multilingual Programmer

    1. FORTRAN
    2. BASIC
    3. Pascal
    4. Forth (a little for one specific project)
    5. Prolog (very little, quickly became too much trouble for what was trying to be done, or I just didn't understand it well enough)
    6. dBase
    7. FoxPro
    8. C/C++
    9. VB/ASP
    10. T-SQL
    11. VB.NET
    12. C#.NET
    13. ASP.NET

    Anything that I...

  • RE: Round averages

    morlindk (9/29/2016)


    I think 'None of these queries' is correct.

    (i) Table has Score, queries reference TestScore => Error

    (ii) Even option 3 produces '9', not '9.0'

    /morten

    +1

  • RE: Proper Storage and Handling of Personal Names

    Stephanie Giovannini (8/4/2016)


    I would settle for having my last name properly spelled. There's some low-hanging fruit.

    +1

  • RE: Proper Storage and Handling of Personal Names

    Allow me to propose an alternative. One of the primary reasons Western databases store names in multiple fields (given_name, surname, title, etc.) is to allow for the generation of...

  • RE: Good Stories

    In the late 90’s, I was working for an engineering company in project management not in IT support (we didn’t have dedicated IT support at remote worksites). Without going...

  • RE: Bias, the Serial Killer of Diversity

    The article referenced by David Poole is excellent, although probably not politically correct. 😉

  • RE: Bias, the Serial Killer of Diversity

    In the interests of full disclosure, I am a white male in my 50's. I've worked my entire career in the USA and later Canada. I've been on...

  • RE: Noise

    kapil_kk (10/15/2012)


    As sql server version was not specified so I selected NoiseList but got wrong...

    I think version should be mentioned in question..

    learn new thing today.......

    +1

  • RE: Dog Food

    I work for a medium sized engineering company which only has a couple of applications that are used outside of the company. And both of those were actually developed...

  • RE: GO Part 2

    Followed my usual practice of looking through the documentation, got briefly sidetracked by focusing on the two variable declarations (thinking that I needed to find a way to force the...

  • RE: Using Sparse Columns with SELECT ... INTO

    Thanks for the quick answer! I suspected that I would get an answer here before I had time to try to find it myself!:-D

  • RE: Using Sparse Columns with SELECT ... INTO

    From http://msdn.microsoft.com/en-us/library/ms174979.aspx:

    SPARSE

    Indicates that the column is a sparse column. The storage of sparse columns is optimized for null values. Sparse columns cannot be designated as NOT NULL. For...

  • RE: Snapshots

    palotaiarpad (7/19/2012)


    I'm not agree with the "right" answer. I can revert to any undamaged snapshot:

    Step 1: delete all other snapshot

    Step 2: revert to the selected

    The answer would be right only...

  • RE: DBCC CHECKDB WITH TRY/CATCH

    Very interesting question. But MS should have made the answer easier to find, IMHO. Learned something = good day!:-D

  • RE: Database size in SQL Server 2012

    Hugo Kornelis (6/20/2012)


    Ernie Schlangen (6/20/2012)


    So the real question to me is whether the 524 PB limit is imposed by SQL Server regardless of the file system in use. If...

Viewing 15 posts - 1 through 15 (of 46 total)