Viewing 15 posts - 1,021 through 1,035 (of 1,403 total)
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...
May 12, 2020 at 6:53 pm
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...
May 12, 2020 at 1:25 pm
drop table if exists #data;
create table #data(
id int primary key not null,
name_id int,
...
May 11, 2020 at 2:56 pm
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. ...
May 11, 2020 at 12:52 pm
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...
May 11, 2020 at 12:01 pm
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...
May 11, 2020 at 11:06 am
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...
May 11, 2020 at 11:03 am
... I should have just gone with the ubiquitous INT IDENTITY(1,1).
bingo
May 11, 2020 at 10:46 am
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,...
May 3, 2020 at 2:33 pm
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...
April 30, 2020 at 4:10 pm
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...
April 29, 2020 at 3:41 pm
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...
April 27, 2020 at 9:04 pm
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...
April 27, 2020 at 7:26 pm
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...
April 27, 2020 at 12:39 pm
That's freaking amazing. It's awesome to see real in depth analysis. Thank you for doing this.
Shifting gears a bit, since the Nested Sets method has most of...
April 27, 2020 at 11:58 am
Viewing 15 posts - 1,021 through 1,035 (of 1,403 total)