Forum Replies Created

Viewing 15 posts - 241 through 255 (of 394 total)

  • RE: NOSQL and RDBMSs

    Very interesting article. I've had my eyes opened quite a bit lately concerning NoSQL environments and I've reached the following conclusions:

    1. NoSQL solutions definitely have their shining moments and...

  • RE: Is Skynet Coming?

    I know that there is a lot of concern and even some fear about the capabilities of AI, however I don't think that we have to worry about it for...

  • RE: Identify sets of rows

    Jacob Wilkins (7/15/2015)


    If I understand what you want, you don't need to partition the result, since you want the number sequence to persist across all the values, based solely on...

  • RE: Naming Confusion

    While there is added security through obscurity by using coded names and numeric sequences, it becomes very difficult for people to remember them or to distinguish them one from another....

  • RE: SQL Server syntax in one document

    Sean Lange (4/24/2015)


    My guess is that if you had a single document stripped down like your example it would also take a lot of time to find the statement you...

  • RE: SQL Server syntax in one document

    Sean Lange (4/24/2015)


    All of the syntax available for sql server??? Are you kidding??? The document would be too big to read. That is why technet has it across so many...

  • RE: First Episodes

    Michael Valentine Jones (3/31/2015)


    It amazes me when they make a movie of an old TV series that I thought was terrible even when I was a kid.

    Lost in Space

    The Brady...

  • RE: CTE Syntax

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


    Koen Verbeeck (3/30/2015)


    Such a bad habit to start a CTE with

    ;WITH

    I hate it 😀

    Nice question though, thanks Steve.

    I agree. I've started to try this:

    ;

    WITH myCTE...

  • RE: CTE Syntax

    Koen Verbeeck (3/30/2015)


    Such a bad habit to start a CTE with

    ;WITH

    I hate it :-D/quote]

    I totally agree! This leads to sloppy code development and debugging nightmares. Besides, it's ANSI standard...

  • RE: First Episodes

    Gary Varga (3/23/2015)


    He had extremely fond memories of it and felt that watching the series again, but a quarter of a century on and though adult eyes this time, would...

  • RE: Limitations of MongoDb

    David.Poole (3/10/2015)


    Years ago I raised the point that NOSQL actually meant NO-RDBMS and got shot down in flames. With the adoption of CQL, N1QL, AQL and lots of things...

  • RE: Limitations of MongoDb

    Andrew..Peterson (3/10/2015)


    cdesmarais 49673 (3/10/2015)


    I currently support Mongo, SQL Server, MySQL, and increasingly PostGres, which offers an interesting hybrid document db datastore on top of a relational db.

    Great, so...

  • RE: Limitations of MongoDb

    It all comes down to this: use the right tool for the right job. NoSQL databases have their uses and function well in that space just as RDBMS databases...

  • RE: SOME rows

    Brian Hibbert (1/30/2015)


    SOME and ANY are operators rather than standalone functions even though they look like functions.

    I believe that this is consistent in style with operators such as IN.

  • RE: SOME rows

    Good introduction Steve! I've never used the SOME function before.

    I think it's also pertinent to point out that the reason all 8 rows returned was because of the use...

Viewing 15 posts - 241 through 255 (of 394 total)