Viewing 15 posts - 46 through 60 (of 194 total)
In my opinion this article was written by ChatGPT or another KI tool with no real knowlegde. Besides the errors mentioned by Uwe Ricken it is not more than a...
God is real, unless declared integer.
January 10, 2024 at 8:51 am
Regarding the fact, that people are fired but other companies can't find candidates:
Besides the skill mismatch problem it may be a quality problem too. The IT was booming the last...
God is real, unless declared integer.
January 5, 2024 at 11:33 am
Regarding:
However, if I were carrying around data that was more important than the work I do now or data worth a lot of money, I don't know I'd ever enable...
God is real, unless declared integer.
December 11, 2023 at 11:40 am
we have a ton of stuff local saved (as developer), but the disks of our notebooks are encrypted. Of course this is not 100% secure, if the police storms my...
God is real, unless declared integer.
October 20, 2023 at 12:34 pm
2 minutes is too few in my opinion - it happens regularly that I do something else than typing / moving the mouse (even seeing a training video could theoretical...
God is real, unless declared integer.
October 18, 2023 at 10:49 am
take the database offline (or at least ensure, that nobody writes to it by executing another RESTORE DATABASE on it) and make a file copy / backup of it and...
God is real, unless declared integer.
September 29, 2023 at 8:33 am
Very old article / discussion, but I disagree with the tip to set another database than master as default too
God is real, unless declared integer.
August 13, 2023 at 5:16 pm
My colleague uses this in a database where the analysts could run several simulations.
Each analyst has his own user + schema (which is the default schema for this user) with...
God is real, unless declared integer.
July 27, 2023 at 3:15 pm
Nice advertising article, but I (as SQL but no BI guy) have still absolute no idea, what it is for and how I could use it (or for what).
Can I...
God is real, unless declared integer.
July 27, 2023 at 2:48 pm
I agree, that it could be a valid solution too (depending on your real workload).
But you should change your query a bit to make it faster (place alias of the...
God is real, unless declared integer.
July 12, 2023 at 11:47 am
this may work for a customer + the last order but there are tons of other scenarios where the updates comes much more often or it is not worth the...
God is real, unless declared integer.
July 12, 2023 at 7:35 am
just did a small performance test (SQL 2022 Dev.):
SET STATISTICS TIME, IO ON;
DROP TABLE IF EXISTS #tmp1
DROP TABLE IF EXISTS #tmp2
SELECT TOP 2000000 o.name, LEFT(CAST(NEWID() AS VARCHAR(36)),...
God is real, unless declared integer.
May 24, 2023 at 12:58 pm
The script will be *SLOW*, because it uses a scalar function and will be called Row-By-Agonizing-Row, multiple million times on a real database.
UPDATE tbl SET name =...
God is real, unless declared integer.
May 24, 2023 at 12:10 pm
watashiato - n. curiosity about the impact you’ve had on the lives of the people you know, wondering which of your harmless actions or long-forgotten words might have altered the plot...
God is real, unless declared integer.
May 19, 2023 at 1:28 pm
The Social Security Number may be theoretical unique per natural person, but there are people without (e.g. foreign customers). And as in any systems there are "holes" where people got...
God is real, unless declared integer.
May 15, 2023 at 1:00 pm
Viewing 15 posts - 46 through 60 (of 194 total)