Viewing 15 posts - 16 through 30 (of 157 total)
Very old article / discussion, but I disagree with the tip to set another database than master as default too
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...
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...
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...
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...
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)),...
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 =...
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...
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...
May 15, 2023 at 1:00 pm
I'd think it is better to really recompile all the procedures / triggers / views / functions etc. instead to hope, that the sys.dependencies-table is always 100% correct.
March 13, 2023 at 9:13 am
I use CONTEXT_INFO() regularly to "disable" triggers just for one session (e.g. migration scripts or bigger updates that should not touch the history tables / updated_at / _by columns or...
March 3, 2023 at 9:44 am
I agree - there is no real reason, to avoid MERGE. And if it seems to difficult to understand, you may need just some practice 🙂
I use it very often...
February 20, 2023 at 11:07 am
Short question: WHY should I backup direct from my local server to cloud storage?
Wouldn't it be much better / faster to create the backup locally and copy it to the...
January 30, 2023 at 9:28 am
December 27, 2022 at 12:04 pm
@Eirikur: of course it is possible to do the calculation with bit shifting, reversing, converting to binary etc., but WHY? Just because it is possible and makes some old assembler...
September 20, 2022 at 2:37 pm
Viewing 15 posts - 16 through 30 (of 157 total)