Viewing 15 posts - 16 through 30 (of 8,467 total)
Jeff,
As regards the CONVERT function, you make an excellent point. I use a dialect of T-SQL called sparkSQL (which comes from the world of Apache Spark.
I am trying...
March 12, 2022 at 4:34 pm
Eirikur, you're in the right ball park,
In typical pyspark I could do the following:
.withColumn("LAST_MODIFICATION_DT", to_timestamp(concat(col('LAST_MOD_DATE'), lit(' '), col('LAST_MOD_TIME')), 'yyyyMMdd HHmmss'))
But I'm not sure how to add that to sparkSQL.
I'm...
March 12, 2022 at 4:30 pm
So,
I managed to get the first half of the code to work in sparkSQL as follows:
select CAST(LAST_MOD_DATE AS STRING) AS expr1 from DmWo
I then try and...
March 12, 2022 at 10:23 am
We have a stored procedure (with many embedded procedures) that populates a a table with a lot of aggregated data. When populated this table is used to create a...
March 8, 2022 at 7:06 pm
In table 4000000 records .backup is not possible total database size is 1TB.
80 Gb / 4000000 rows states the answer, divide and conquer looks like the answer here. Question,...
March 8, 2022 at 7:01 pm
Could be a problem with the Window Function implied worktable in tempdb, you could try limit the column numbers in the select until it works and take it from there.
😎
Mind...
March 8, 2022 at 6:56 pm
My thought is that you'll need to break this question down to smaller chunks, quite a large ask here!
😎
Having assessed the information you posted (and more importantly what is not...
March 8, 2022 at 6:41 pm
Quick question, how many rows are in the table?
😎
Given the numbers, you would be much better off doing a backup onto a USB stick, walk over to the other server...
March 8, 2022 at 4:59 pm
March 7, 2022 at 6:56 pm
Couple of questions:
1. Did you run the setup as an Administrator?
2. What are the privileges of the account running the SQL Server Service?
😎
As a side note, I would prefer to...
March 7, 2022 at 6:52 pm
Quick question, do you need DATETIME2 or is DATETIME enough, I would guess the latter observing the data you posted?
😎
This problem can be sorted with some elementary bit-bashing that is...
March 7, 2022 at 6:03 pm
Just a quick question, what are the variations of the values in the first four columns?
😎
March 7, 2022 at 5:48 pm
You are trying to create a table with 1000 columns that exceeds the maximum 8060 page's byte limit!
😎
Conclusion: Redesign 😉
March 7, 2022 at 5:28 pm
Just a thought, start by importing the file as all character columns, then analyse the data and reconstruct the target table.
😎
I don't like the Import AND Export Wizard, pretty daft...
March 7, 2022 at 5:20 pm
Add a try-catch with error reporting in the inner procedure
😎
February 25, 2022 at 1:06 pm
Viewing 15 posts - 16 through 30 (of 8,467 total)