Viewing 15 posts - 31 through 45 (of 157 total)
Very nice and informative article, but I miss one important point:
Unix timestamps are based on the UTC timezone (this may be clear for you but not for a random junior...
September 15, 2022 at 1:35 pm
I wonder, where it would really help me.
The usual business logic (as total = amount * single_price or gross_price = net_price * (1 + tax_rate)) does not really be needed...
September 2, 2022 at 2:08 pm
This article was wrongly linked under the topic "Columnstore Indexes are Finally Sorted in SQL Server 2022" in the newsletter from 20th July 2022.
I didn't find Steve Jones article with...
July 20, 2022 at 10:17 am
@Emmit:
why do you not use
DATEFROMPARTS(YEAR(cd.BirthDate), MONTH(cd.BirthDate), ABS(CHECKSUM(NEWID())) % (DAY(EOMONTH(cd.BirthDate))) + 1) AS new_birth_date
It would return random dates from month first to the month's last day.
June 24, 2022 at 3:57 pm
why should this a problem? Random is random and each rule you add reduces the "complexity". If I know, that it must not be the original birth date, there are...
June 24, 2022 at 3:39 pm
Just to refer to the orginal problem:
The root problem of the big log file could be fixed / prevented, if you would partition your tables. Ola's script would in this...
May 9, 2022 at 12:46 pm
when you are working with dynamic SQL and particularly, when it uses varchar-parameters and adds it to the dynamic code, you have always to use QUOTENAME(), otherwise someone could call...
November 29, 2021 at 9:26 am
@hmbacon: you could either do 6 Updates each joining the base table or - if the select of the base table is slow / difficult - write the...
October 20, 2021 at 9:24 am
The DELETE WHERE id IN (SELECT TOP x) is still a very bad solution. You wrote that it makes a table scan in your first example, so I assume that...
October 15, 2021 at 9:26 am
@dave_rogers: I disagree with your "rule". It is often much easier to query a log table (even if it will be never joined to whatever) than to read / search...
October 8, 2021 at 11:47 am
ok, theoretical you could for the cursor "problem" declare an additional variable, increase it inside the loop and write a WHILE @i < 999999999 instead of 1=1
But what, if someone...
September 22, 2021 at 4:03 pm
Did you just click onto the link and tried it out? It is only a simple database / table on a webserver and a web frontend where you could enter...
August 6, 2021 at 3:29 pm
Nice, but it would be nicer, if I could also search for
...
August 6, 2021 at 12:35 pm
@jeff - but both it is linked together 🙂
@Jeffrey: of course I'd cluster your table by PatientID, DocID too. But when you are not a very new hospital...
June 17, 2021 at 8:24 am
Stupid question, but why are some people use a low fill factor as 70 or 80%, I'm usually fine with something as 95-98 (or even 100 if it is on...
June 16, 2021 at 1:06 pm
Viewing 15 posts - 31 through 45 (of 157 total)