Viewing 15 posts - 2,461 through 2,475 (of 2,646 total)
it has to do with your server/session collation.
I'm not even sure which collation the link you supplied is.
In order to determine the values for your current collation...
July 6, 2017 at 1:27 pm
Without having access to the views and underlying tables/index its impossible to give a good answer.
not knowing the data also doesn't help.
You will need to get your...
July 4, 2017 at 1:55 am
Straight combination of sql server agent job with 2 steps
step 1 - execute command file - issue the ftp command to get the file onto a local folder and...
June 30, 2017 at 5:20 pm
when checking that the data is stored on the db do convert to varbinary to confirm. A x00 value will truncate the output on SSMS so its not a valid...
June 20, 2017 at 10:36 am
June 11, 2017 at 9:14 am
I would revise that approach - most likely you only need to do that for the fact table, not the dimensions as those should be by their own nature smaller.
June 10, 2017 at 4:06 am
CRM can be a pain for this.
I assume that this CRM database is either OnPrem or Cloud PaaS.
If not then no access to the database will be...
June 8, 2017 at 2:19 pm
a option that I like is as follows.
requires 3 tables
1 - main table
2 - staging table
3 - intermediary table to allow for alter table switch...
June 8, 2017 at 1:45 pm
in order to link to 8i max oracle client version is 10g
see http://www.dba-oracle.com/t_oracle_client_versions_higher_lower_database_release.htm for full compatibility list - may be outdated but for your purpose it is enough
June 6, 2017 at 6:29 am
By Using SSIS I presume you are aware that it is a licensed SQL Server tool that requires the computer where it is being executed to be fully licensed? meaning...
May 29, 2017 at 5:18 am
Do read the following paper https://download.microsoft.com/download/9/C/6/9C6EB70A-8D52-48F4-9F04-08970411B7A3/SQL_Server_2016_Licensing_Guide_EN_US.pdf.
It does go into detail on how the whole licensing works. And even after reading it you should confirm with Microsoft so ensure...
May 18, 2017 at 12:04 pm
error is quite clear - did you install the ACE driver on the server where you are running the package? and if it is a server why not install and...
May 15, 2017 at 11:40 am
With standard even if you set max memory higher it will only use the 128 so do not worry about that aspect. So the correct thing to do here is...
May 11, 2017 at 2:25 pm
128GB is max that SQL Server instance will use for its buffer pool - and this is per instance.
but as there are other things that can use the...
May 11, 2017 at 12:52 pm
Lets assume the following example
Standard process would be
- dataflow -
Input file to Final table
Approach I am suggesting is
-...
May 9, 2017 at 4:14 pm
Viewing 15 posts - 2,461 through 2,475 (of 2,646 total)