Before making any changes to the CPU settings, read the following.

http://msdn.microsoft.com/en-us/library/ms187104.aspx

http://msdn.microsoft.com/en-us/library/ms186255(v=sql.90).aspx

To set max and min memory for SQL Instances, read below documentation:

http://msdn.microsoft.com/en-us/library/ms191144.aspx

http://msdn.microsoft.com/en-us/library/ms178067.aspx

Keep in mind, there are other considerations when...

Not sure if you configured the TNSnames yet?

a few guides below:

http://www.ideaexcursion.com/2009/01/05/connecting-to-oracle-from-sql-server/

http://support.microsoft.com/kb/280106

http://www.sqlmag.com/article/sql-server/setting-up-an-oracle-linked-server49687

Please read through this:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

The above guidelines will enable us to assist you better and faster.

But none of this helped.I dont see the oraoledb.oracle driver in the Linked servers providers list.I am able to connect the Oracle client with the Oracle DB.

Please advice what could...

To agree and add to what Koen said.

Build a solution, and write down any error you can think of, from Data Source, Data Source View, Data Flow Source, Destination,...

Nice one, thanks. No room for error there.

http://www.connectionstrings.com/

This should guide you.

Confirm the following checks from your side:

1. Reportserver & ReportServerTempDB databases are present in the instance

2. All configurations have been done and error free in Reporting Services Configuration Manager

3. Open...

You can do the same SQL CAST/CONVERT to the desired datetime in the DSV, but instead of using a table or view, a SQL Query.

In the DSV, right Click, "New...

Artoo22 (3/19/2012)

I don't need assistance today, but I have a comment. Why doesn't Microsoft use T-SQL coding standards?

Whenever I script a system stored proc the code looks like a dogs...

Do they belong to different Roles? Sounds like the 2 users have explicit permissions in the cube to access certain data....

GilaMonster (3/16/2012)

Why use NoUnload? It's an option only valid if the backup is on tape. For backups on disk that option...

There are some templates installed by default with the Development Studio (Data Tools).

Yep, here is some info on AlwaysOn and HA:

http://www.infotechguyz.com/SQLServer2012/NewFeaturesinSQLServer2012.html

RESTORE HEADERONLY

FROM DISK = N'C:\AdventureWorks2008R2-FullBackup.bak'

WITH NOUNLOAD;

GO

Have you downloaded and installed SQL2012 RTM/RC0 yet? with it, SQL Data Tools (development studio) will install as well if chosen.

There are templates for Windows 7...