Viewing 15 posts - 61 through 75 (of 283 total)
Something along the lines of
Select convert(datetime, N'30-07-2007', 105)
June 3, 2011 at 10:19 am
Putting Reporting Services on a separate server will help performance, particularly is the reports are large. It also means that server resources on the database server are not shared...
June 1, 2011 at 3:35 pm
This can be done directly by creating a data source against the Oracle database. You'll need to install some Oracle drivers on your Analysis Services server first - these...
May 6, 2011 at 3:25 pm
Shared tools are things like drivers and management studio - these need to be on each node and go on the c: drive.
The Instance folder contains the instance specific files...
April 9, 2011 at 12:38 am
Are you able to run a query in Oracle to get the min and max dates for that column? We had similar issues where SQL server can not store the...
April 8, 2011 at 12:04 am
You can't turn it into a clustered version, you'll have to install another instance of Analysis Services into the cluster. You don't have to remove the existing standalone one...
April 7, 2011 at 11:53 pm
AWE should be enabled as you've got a 32bit server. You'll need to leave 2 or 3 Gb for the OS to use, so the maximum memory setting for...
April 6, 2011 at 5:50 am
Can you provide us with the query you are running?
April 6, 2011 at 5:46 am
Nothing specific but the following may help:
April 5, 2011 at 1:55 pm
SQL 2005: you can add analysis services to an existing instance in the cluster or add it as a new instance in the cluster.
SQL2008: You can add analysis services...
April 5, 2011 at 1:19 pm
Is it a 32bit or 64bit server? How much memory does the server have? Are there any other apps on the server?
April 5, 2011 at 11:38 am
That's right. It will allow you to select the instance and then you can select the features to remove or you can remove the whole instance. It shows...
April 5, 2011 at 11:26 am
The Oracle software will need to be installed on each node of the cluster and have the same configuration (eg: the same tnsnames.ora). When a failover occurs, SQL Server...
April 4, 2011 at 3:56 pm
I don't know why you are getting the Unicode conversion errors but have you tried setting the agent job to run in 32 bit mode? Is there any other...
April 2, 2011 at 1:56 am
Viewing 15 posts - 61 through 75 (of 283 total)