Forum Replies Created

Viewing 15 posts - 1,036 through 1,050 (of 1,419 total)

  • Reply To: Choosing Sequences Over Identity

    jcelko212 32090 wrote:

    You keep trolling this forum with things that indicate either youth or ignorance.

    If you could point out some specific examples I would truly appreciate it.

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Choosing Sequences Over Identity

    jcelko212 32090 wrote:

    No, it is not a Ferrari. It is a database engine aimed at a particular market niche. It does it very nicely in many ways, but it is not...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Choosing Sequences Over Identity

    jcelko212 32090 wrote:

    After I get it working (working first, optimize later), then I can tuned it, attach add-ons or whatever. If you can find a good book on it, in the...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Self join / row_number() partition number generation based multiple status

    drop table if exists #data;
    create table #data(
    id int primary key not null,
    name_id int,
    ...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Self join / row_number() partition number generation based multiple status

    ravisankar wrote:

    Whenever there is a change in Status or Comment for name_id then we need to consider that record

    The table could be altered so it becomes a "System-Versioned" temporal table. ...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Update duplicate values to 0

    jcelko212 32090 wrote:

    When you set something to zero like this, you're changing the data,you're destroying the fact which Chris Date and I think most other RDBMS experts feel is a really...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Choosing Sequences Over Identity

    jcelko212 32090 wrote:

    By analogy, it is like the parking space in the garage in your car is the data element.

      So a 2D piece of physical capital is the best analogy...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Choosing Sequences Over Identity

    jcelko212 32090 wrote:

    The SEQUENCE and IDENTITY are two very different things. The IDENTITY table property is a very proprietary, totally non-relational, feature in SQL Server. By analogy, it is like the...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Choosing Sequences Over Identity

    Eric M Russell wrote:

    ... I should have just gone with the ubiquitous INT IDENTITY(1,1).

    bingo

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Convert VBA function to SQL function

    trunglm wrote:

    Dear scdecade,

    Your function can not use in my database, my database running on SQL server 2014 and can not support JSON.

    Pls help me fix it.

    Thank you.

    According to this article,...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: Convert VBA function to SQL function

    The REPLACE function can do many things in SQL Server.  It's not really documented well and I usually have to experiment with it.  When the REPLACE function is itself called...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: EF Code-First

    Just to add more history here.  For application developers using SQL Server db's there used to be something called the Microsoft Enterprise Library.  Among other things it included tools and...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: EF Code-First

    Jeff Moden wrote:

    Are you saying that no one has created designs that exploit the inherent advantages of using stored procedures?

    From a SQL perspective I'm not saying that at all.  SQL developers...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: EF Code-First

    Jeff Moden wrote:

    I'm talking about people using the front end designers to create tables.  Some people do it right but, for the most part, it's done by people that have no...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • Reply To: EF Code-First

    Jeff Moden wrote:

    I could be wrong but I'm pretty sure that's not what the OP is talking about.  I believe he's talking about the front-end Developers creating the tables on the...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

Viewing 15 posts - 1,036 through 1,050 (of 1,419 total)