Viewing 15 posts - 3,076 through 3,090 (of 7,609 total)
Scott, I appreciate your...
October 26, 2018 at 9:13 am
For only 1 to 5 rows, then it should'n take long at all.
I don't see why SERIALIZABLE would be needed at all for this UPDATE. SQL will...
October 26, 2018 at 8:22 am
Yes, SERIALIZABLE is the most restrictive level there is, so it could lead to blocking.
Is the main table indexed in some way on col3?
October 25, 2018 at 4:31 pm
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[TriggerUpdateInsert]
ON [dbo].[TABLE_SOURCE]
AFTER INSERT, UPDATE
AS
SET NOCOUNT ON;
UPDATE TD
SET FIELD_1...
October 25, 2018 at 3:59 pm
I think a well-written function might still be the best choice. The logic could get very complex to implement trying to use a table structure. If necessary for performance, make...
October 25, 2018 at 3:52 pm
October 25, 2018 at 9:49 am
October 24, 2018 at 5:06 pm
I'd use a cross tab within the CROSS APPLY to reduce overhead (I would think).
IF OBJECT_ID('tempdb.dbo.#your_table') IS NOT NULL
DROP TABLE #your_table;
October 24, 2018 at 2:48 pm
Look for function (ITVF) dbo.DelimitedSplit8K,
October 24, 2018 at 1:51 pm
October 23, 2018 at 10:13 am
October 23, 2018 at 9:43 am
October 23, 2018 at 9:32 am
Viewing 15 posts - 3,076 through 3,090 (of 7,609 total)