Viewing 15 posts - 166 through 180 (of 8,760 total)
Strongly suggest that you calculate the dates beforehand, insert the dates in a table and have the job check if the date exists in the table.
😎
From now until the 1st...
January 3, 2023 at 3:17 pm
Happy new year everyone! 😎 May the source be with you 😉
Same to you, ol' friend. Glad I got to know you and others from this site. ...
January 3, 2023 at 2:39 pm
Deleted: a bug in the forum caused a duplicate post.
😎
January 1, 2023 at 3:05 pm
Happy new year everyone!
😎
May the source be with you 😉
January 1, 2023 at 3:02 pm
Unfortunately, if the text includes 0, this method will fail.
😎
declare @String varchar(30)
select @String = 'X01TEST00001234'
select
case
when ISNUMERIC(@String) = 0 then SUBSTRING (@String,0,CHARINDEX('0',@String)) + SUBSTRING(REPLACE(@String,SUBSTRING (@String,0,CHARINDEX('0',@String)),''), PATINDEX('%[^0]%',...
December 27, 2022 at 3:19 pm
Excuse the pun, but -40 is F**C cold 😉
😎
December 23, 2022 at 5:32 pm
Just a rant really. I'm used to lambda, DynamoDB etc, but got access to sandbox account at work and wanted to learn Apache Kafka. Turns out serverless version is...
December 23, 2022 at 4:59 pm
Fascinating discussions, but what was "wrong" with my solution? I heard stuff like it is not usable except on SQL 2022, but this IS the SQL 2022 forum, is...
December 21, 2022 at 11:23 am
20 core (8 + 8 + 4) and 64GB RAM, 2 SSD disk.
And the SQL Server instance specs?
😎
December 19, 2022 at 6:53 pm
No, because I do not have a lot of users on my Laptop! But the scripts shows that even when executing with only 3 users, data are not read...
December 19, 2022 at 5:35 pm
Be aware that the EXCEPT method adds a stream aggregate operator that is more costly...
December 19, 2022 at 5:05 pm
@Eirikur That works, of course, but SQL Server won't be able to use any index for that query.
Using indices is not necessarily the same as having better...
December 19, 2022 at 4:58 pm
Just putting the money where the mouth is 😉
😎
Test result sets:
-----------------------------------------------------------------------------------------------------------------
With non-clustered indices on both columns
-----------------------------------------------------------------------------------------------------------------
T_TXT ...
December 19, 2022 at 4:41 pm
@Eirikur That works, of course, but SQL Server won't be able to use any index for that query.
Using indices is not necessarily the same as having better performance, this...
December 19, 2022 at 2:06 pm
Just a quick thought, if one uses ISNULL one can lessen the internal cardinality from the NOT IN subquery that are pushed into the nested loop.
😎
Here is an example:
December 18, 2022 at 1:54 pm
Viewing 15 posts - 166 through 180 (of 8,760 total)