Viewing 15 posts - 1 through 15 (of 476 total)
Would you post your splitter, please?
Sadly that requires more time than I have readily available to sanitise and remove any naming etc. that is "internal" ... which in turn...
March 7, 2021 at 2:03 pm
maybe some analysis of what proportion of the Email Body are Small,. Medium and Big in size. Something like this
SELECTSUM(CASE WHEN LEN(Body) <= 1000 THEN 1 ELSE...
March 6, 2021 at 4:22 pm
the table is relatively small with only 97500 records but the data size for the table exceeds 2.5Gb
That's an average of 3.5 Pages of text (assuming Nvarchar) PER message....
March 6, 2021 at 4:09 pm
You probably know this, but Paul Randal is an avid history reader and he seems to manage to get through a huge number of books each year. He publishes a...
March 6, 2021 at 7:47 am
Or you could just add a WHERE clause to filter them out as it's a table valued function.
Yes ... but my Splitter returns an Item No, and if I...
March 6, 2021 at 7:04 am
My Splitter function takes 3 parameters - data, delimiter and ValueForBlanks - typically empty string or NULL, but the value '[[DELETE]]' then completely removes any blank entries
March 5, 2021 at 8:44 pm
After the: inherited-but-awful % strings in RAISERROR ...
Short of using CamelCase seems a bit non-standard to only have one "E" ... other such reserve words have "_" separator ...
March 3, 2021 at 4:06 pm
I can't see how presence of existing TEMP table would cause a problem as
CREATE TABLE #ReportResults (dateStamp dateTime NOT NULL, dataInterval int)
would then fail.
longshot : But ... maybe it is...
March 3, 2021 at 1:44 pm
Thanks for taking the time to type that Brain, all very informative 🙂
Tricks for updates that drop objects - I like to use DLM Dashboard ...
For 3rd party database...
March 3, 2021 at 5:57 am
ISNULL has another quirk, as well... if the 2nd operand is actually a SELECT or a function or any other type of executable, it will be executed even if...
March 3, 2021 at 5:44 am
March 3, 2021 at 5:36 am
Did you change the Compatibility Level when upgrading from SQL 2014? (e.g. from 120 to 150)
If so maybe try it back at 120 just as a test for this query?
March 3, 2021 at 5:25 am
From what I've read, at least, the STRING_AGG performs well.
First result I found in Google :
March 2, 2021 at 9:26 pm
STRING_AGG()? I'm really looking forward to that when we shift our boxes at work to 2017+. That'll be one (like ROW_NUMBER(), etc) that they'll need to pry from my...
March 2, 2021 at 8:02 pm
Defensive programming: if the possibility exists that a future change would require ...
It doesn't, that's the point. More correctly "It is unheard of" rather than just "Fairly unlikely"...
March 2, 2021 at 8:00 pm