Viewing 15 posts - 1,726 through 1,740 (of 2,645 total)
February 13, 2019 at 4:19 am
February 12, 2019 at 9:20 am
I defined a virtual (unbound) recordset based...
February 12, 2019 at 8:54 am
February 12, 2019 at 7:47 am
February 11, 2019 at 2:28 pm
I would write a script to delete the rows in small defined batches, something like this:
DECLARE @Batchsize INT
SET @Batchsize = 5000; /* Change to whatever...
February 11, 2019 at 10:56 am
February 7, 2019 at 7:05 am
I think this is the link you want:
https://docs.microsoft.com/en-us/sql/integration-services/lesson-1-4-adding-package-configurations?view=sql-server-2017
February 6, 2019 at 7:48 am
February 5, 2019 at 1:30 pm
February 5, 2019 at 8:29 am
February 5, 2019 at 7:28 am
I can't see a way of speeding up the comparisons on the CUSTOM columns.
It might be possible to improve the performance of the left join to your view....
February 5, 2019 at 4:53 am
Is the message always of the form 'message [CLIENT: nnn.nnn.nnn.nnn]' ?
If so this will do it:DECLARE @SearchStringForStart varchar(100)='CLIENT: '
DECLARE @LenSearchStringForStart int = LEN(@SearchStringForStart)
DECLARE @SearchStringForEnd...
February 4, 2019 at 1:42 pm
You probably have a long running query.
Execute this to see what's running and how long it's been running for:SELECT sqltext.TEXT,
req.status,
...
February 4, 2019 at 5:12 am
Viewing 15 posts - 1,726 through 1,740 (of 2,645 total)