Viewing 15 posts - 616 through 630 (of 747 total)
Very good question. You've given me something to consider. Like many, I tend to tack on such metadata/tracking columns w/o question. But as they are all part of the clustered...
September 20, 2021 at 2:27 pm
September 16, 2021 at 6:05 pm
AFAIK, S3 is your only viable option for RDS external file access.
September 14, 2021 at 4:45 pm
So what does the following (w/o the casts) return?
It's probable that one or more of those INFO values still contains non-numeric characters, is decimal, or is even bigger than a...
September 8, 2021 at 8:41 pm
Probably Elasticsearch using Ingest Attachment Processor or Apache Tika.
Otherwise, if you're happy with iFilter, pay FoxIt. Elasticsearch is very powerful, but the costs to develop & implement the new approach...
September 8, 2021 at 1:31 pm
Do you really have 500-character IDs? Such a long ID seems unusual and non-ideal. At 500 bytes, only a few rows will fit in an 8K database page. If so,...
August 31, 2021 at 8:16 pm
What is the datatype/size of tbl_File.MetaData? (wondering why are you casting the type in the replace statement)?
Do you have MetaData column values that contain "Category=" that do not have a...
August 25, 2021 at 9:33 pm
Share what you found, and help others learn.
Sooner or later ,someone else out there will be struggling with a similar problem, and your experience may help them.
August 24, 2021 at 8:43 pm
This is precisely what foreign keys are for.
Is ItemNumber in the transaction table equivalent to the ProductId in the master table?
August 19, 2021 at 10:05 pm
It's not a csv. There is no single, consistent delimiter. This is invalid json. json keys/names should be enclosed in quotes. Those that contain delimiters must be enclosed in quotes.
If this...
August 19, 2021 at 3:27 pm
Be methodical. Understand the relationships and data.
Look for obvious contradictions in the where clauses -- where StartDate > '2021-08-19' AND StartDate < '2021-08-01' will filter out everything.
Then look for typos...
August 19, 2021 at 1:22 pm
I'm guessing you meant a UDF (user-defined function) or more specifically, an ITVF (inline-table valued function) rather than a CTE, since a common table expression doesn't really seem to enhance...
August 17, 2021 at 7:20 pm
You need to wrap
(SELECT COUNT(*) FROM .[dbo].[Stage_SMSLog]
with (NOLOCK) WHERE datestamp = CONVERT(nvarchar(10), GetDate(),120))
in CAST or CONVERT when concatenating into nvarchar (or varchar) string using "+"
(CONCAT function...
August 12, 2021 at 6:06 pm
Removed inaccurate response.
August 2, 2021 at 9:48 pm
Viewing 15 posts - 616 through 630 (of 747 total)