Viewing 15 posts - 121 through 135 (of 2,855 total)
Sounds like an SPN issue. Did you configure the SPN's?
September 4, 2024 at 5:47 pm
As a guess - I would say you have no explicit transactions, right? If so, then the commit will happen as soon as the command completes. What I mean is...
September 4, 2024 at 5:45 pm
My opinion - don't use activity monitor. It is a performance suck on the server and long term runs can cause issues in SSMS too. Plus, some of the metrics...
September 3, 2024 at 2:55 pm
main thing is not to use native SSMS to deploy - either use VS deploy or T-SQL
The risk with a VS deploy though is if you have multiple SSIS...
August 30, 2024 at 4:16 pm
There might be some fair overhead to getting the current length of a text column. If you really have to have that, add a column to...
August 30, 2024 at 3:34 pm
There might be some fair overhead to getting the current length of a text column. If you really have to have that, add a column to the...
August 30, 2024 at 3:27 pm
I just wanted to point out that it also depends on how you deploy.
If you deploy using SSMS, the SSMS version MUST be the same as the SSIS version. I've...
August 30, 2024 at 3:20 pm
Just my 2 cents but it feels like you are trying to treat the symptoms and not the problem. What is causing the network hiccups? I would work on addressing...
August 30, 2024 at 3:15 pm
yeah, that's what I'd expect... why'd you use the grater than operator on a string?
Because I told him to. 😉 It works just fine on MAX datatypes. It...
August 29, 2024 at 7:46 pm
yeah, that's what I'd expect... why'd you use the grater than operator on a string?
August 29, 2024 at 5:13 pm
if checking for NULL is faster, why not use that combined with if the value is an empty string?
WHERE r.resolution_text IS NOT NULL and r.resolution_text != ''
Same net result without...
August 29, 2024 at 5:00 pm
I think it is one of those "it depends" situations.
The cert would need a static name, but the subject alternate names (SAN's) can allow you to use the cert for...
August 29, 2024 at 3:52 pm
the $ at the end of the username makes me think that is a local machine account. I'd recommend checking if the SQL services (SSIS, SQL Server, and SQL Agent......
August 27, 2024 at 8:55 pm
heh, so Scott confirmed what I was assuming, but also clarified which way things would go (read from old table, not be a deadlock victim).
But, my advice when questions like...
August 27, 2024 at 8:50 pm
The anonymous login is likely due to either incorrect SPN configuration or delegation being disabled. At least that is my guess as we can't see your system.
I suppose the next...
August 27, 2024 at 5:54 pm
Viewing 15 posts - 121 through 135 (of 2,855 total)