Viewing 15 posts - 1 through 15 (of 789 total)
*** sorry for the spoilers; but my comment didn't make sense to me without them ***
I debated with myself between "Zero records" and the more comprehensive "Returns distinct rows...
June 8, 2022 at 2:26 pm
Carlo Romagnano wrote:Of course the isolation level of the database should be as in the image
Of course! That's obviously clear from the questionđŸ˜‹
The question is about the...
June 8, 2022 at 2:15 pm
Of course the isolation level of the database should be as in the image
June 8, 2022 at 7:40 am
I ran the query and see zero rows only, please verify your answer.
If the query returns no row, it means that there are not uncommitted data (inserted or modified).
June 8, 2022 at 6:54 am
For debug, I used this query to return all rows inserted or changed in all open transaction.
How to reproduce the scenario:
Start a transaction in one session, insert or modify data...
June 8, 2022 at 6:51 am
If you assume that the string always starts with '\1\' (as the original post) and you do not know then length of text then you can use STUFF instead of...
April 15, 2022 at 1:32 pm
WITH ctePC
AS ( SELECT expression
FROM
( VALUES
...
April 11, 2022 at 8:39 am
Good catch!
Thanks.
September 29, 2021 at 7:10 am
From your link:
Compression can allow more rows to be stored on a page, but does not change the maximum row size of a table or index.
So, the "Compression can allow...
September 10, 2021 at 7:22 am
Please, post an example with RANGE!
I tried this one, so the right answer is PARTITION BY:
SELECT SUM(object_id)OVER()
,SUM(object_id)OVER(PARTITION BY NULL)
FROM sys.objects
WHERE object_id < 100
May 31, 2021 at 7:35 am
I use this function with recursion and @top of 1000000 is enough for me, but I don't n know if it performs better:
-- by Carlo.Romagnano
CREATE FUNCTION dbo.fn_tally(@top INT)
RETURNS TABLE
AS
RETURN WITH...
April 22, 2021 at 7:52 am
Explanation doesn't match with the "pseudo correct" answer.
From documentation:
The "radix" method generally outperforms the other methods, especially for character vectors and small integers. Compared to quick sort, it is slightly...
April 14, 2021 at 7:17 am
Little typo: newletters vs new_letters
newletters<- c("q","w", "e", "r", "t", "y", "u", "i", "o", "p", "q", "w", "e" )
> which (new_letters=="q")
March 31, 2021 at 6:53 am
"In this code, the SET IMPLICIT TRANSACTIONS ON sets a @@trancount of 1. I am not sure why this occurs, but it means that after the COMMIT, there is still...
March 18, 2021 at 9:05 am
-- correct
declare @d tinyint = NULL
RAISERROR(' %s is the current value', 1, 0, @d)
-- incorrect
declare @d tinyint = 1
RAISERROR(' %s is the current value', 1, 0, @d)
March 9, 2021 at 9:58 am
Viewing 15 posts - 1 through 15 (of 789 total)