Viewing 15 posts - 1 through 15 (of 38 total)
Did check the data, in Domino and Oracle looks same : '0200-10-29' and their type is date as well. As far as I know they are not converting it...
November 13, 2013 at 8:35 am
Data type in SQL Server is date in both cases. Previous data flow was Domino->Oracle->SQL Server, now getting direct Domino->SQL Server
November 12, 2013 at 11:52 pm
No it was not. Randomly stops connecting while Node B is active, anybody have any suggestions? I've run out ideas.
There is another package that imports data from Oracle. That...
October 23, 2013 at 10:36 pm
Finally fixed, it was third party firewall blocking the connection
October 23, 2013 at 12:31 am
I thought finally found SQL Server bug π but no, it was another package that was messing with my end table. So, Dwain, it's safe to use Money type.
Thanks...
September 12, 2013 at 10:59 pm
I thought you'd never ask! #Lady from Glee π
INSERT INTO [IPTS_Staging].[dbo].[FactSectorKPIHist]
([Prospect]
...
September 11, 2013 at 7:25 am
Here you go:
Creating table:
---==Create table
CREATE TABLE [dbo].[MDCS_GPS_LOG_RECV](
[Msg_ID] [varchar](50) NULL,
[Callsign] [varchar](50) NULL,
[Timestamp] [varchar](50) NULL,
[Msg_Content] [varchar](2500) NULL
) ON [PRIMARY]
GO
Sample rows:
INSERT INTO [dbo].[MDCS_GPS_LOG_RECV]
...
August 14, 2013 at 3:48 am
We've been doing some performance testing for Columnstore indexing using 160 mln rows, 400 mln rows with different kind of reporting queries. The purpose of test was, if it was...
August 14, 2013 at 2:26 am
I've included few of them in attachment.
I've 2 index on Salesdate table, both of them are non-clustered, one is for DateID and another one is for Short_SKU which is...
August 13, 2013 at 8:46 pm
You have to go through some tutorial or books on how to build the cubes. You can't directly browse normal database using ssas. You will need to build the cube...
April 29, 2013 at 11:00 pm
Even though I was taught first way, I always use the second way as well π as I have data consistency issue with the first way in many cases. Your...
April 29, 2013 at 10:41 pm
@cstg85 Good idea, would be great if it worked... But in reality it won't I think, as your query needs 2 different type of data source in one...
April 12, 2013 at 1:19 am
I sense long list of code π I've list of tables that I need. 1400 tables are actually 100 tables with 14 different schema. From every schema I use 40...
March 31, 2013 at 9:29 pm
You might want to check Datamicron's Performa, but it's not free I guess.
March 26, 2013 at 4:44 am
I heard Datamicron's Performa is a good tool for such things. It doesn't depend on SharePoint, it is standalone application, and connects to SSAS cubes and PPivot as well. No...
March 20, 2013 at 11:00 pm
Viewing 15 posts - 1 through 15 (of 38 total)