Viewing 15 posts - 271 through 285 (of 1,999 total)
I think I found the issue, not sure why , but the "instead of" trigger on that table seems to be re-firing itself
I turned the "allow triggers to fire triggers"...
February 19, 2020 at 4:42 pm
I managed to track down the code in the trigger (using print statements on my 2019 dev kit)
INSERT INTO order_line
(
account_code,
...
February 19, 2020 at 3:44 pm
yes,
there is also a begin tran/try catch/commit/rollback in the calling proc
I know the proc should be handling the transaction, but someone has been a bit "slap happy" with XACT_ABORT and...
February 19, 2020 at 2:54 pm
Ultimately memory optimised tables end up having to be persisted to disk and lord alone I've never tested them with bulk inserts and data manipulation
Are you maybe talking about using...
February 19, 2020 at 2:39 pm
apologies - I read "truncate table" as "truncate log" my mistake
February 18, 2020 at 3:15 pm
additionally were you running previously in simple recovery mode? the database may have been changed to full recovery and there is no t-log backup job..... just guessing.
you could also try...
February 18, 2020 at 2:49 pm
just for clarification (before I give you the wrong advice) - You mentioned Replication and CDC (change data capture)
which one are you using? they are very different things
February 18, 2020 at 2:42 pm
I think you are right, Mike. I'm certain that in my position I don't have the clout to effect change. Developers and DBAs are viewed as people who keep...
February 18, 2020 at 8:46 am
gotta disagree with frederico on this one... if the software is licenced to the client and the client owns the server then they can do what the heck they want...
February 18, 2020 at 8:45 am
I told them when they hired me that I can be a walking HR violation and that they should seat me near people that are not easily offended when I...
February 17, 2020 at 4:49 pm
NUMERIC(18,0) for an Age column.
Jeff???? really - you have an age column? whoever did that needs a beating - even as a 16 year old (a long...
February 17, 2020 at 3:00 pm
NUMERIC(18,0) for an Age column.
Jeff???? really - you have an age column? whoever did that needs a beating - even as a 16 year old (a long time ago)...
February 17, 2020 at 9:39 am
This article, Kendra, comes at a critical time for my work, which in the last 18 months had begun to adopt a more agile approach to software development. We...
February 17, 2020 at 9:32 am
Sorry to jeff, but i'm going to make light of the split functionality, it ends up in a function that goes RBAR - Use a TVP...
February 17, 2020 at 9:25 am
filegroups in a database can be used for a few things (filestream, memory optimised tables etc etc) but splitting your storage is your main gain.. (perhaps a tiny improvement if...
February 14, 2020 at 3:58 pm
Viewing 15 posts - 271 through 285 (of 1,999 total)