Hello,

->What are the current bottlenecks on the new server? (wait_stats)

Can you use the new vhdx format instead of vhd?

You mention the upgrade of the sql server, did the OS of...

Does OPENQUERY work?

What driver did you use? OraOleDB?

Congratulations Jack & Jason

(1) how important, performance-wise, is it to separate out these files?

->it is easier for management in case you decide to reorganize storage. Logfiles have mostly sequential reads, datafiles are...

You can specify an upper limit for the sql server instance buffer pool (not all memory, but a great deal)

Apperantly reportingservices has also a kind of memory policy

Leave 4 GB...

You might consider to explore the relatively new replay markup language RML.

Thanks for all the great 😎 sessions on sqlserverday BE, for the crew, sponsors and the famous :crazy: people who decided to attend. I hope you like the fries, beer,...

You could use tools that generate extra redundancy like quickpar[/url].

The extra redundant files helps to "repair" the copy if parity is off (due corruption), by reading doublechecking it with the...

Are you using the union operator in SSIS or in the sourcequery itself?

Sure that you retrieve all rows in sqldeveloper?

Looking forward to sqlserverdays at the end of september.

Barn, report builder 3 (web-SSRS) doesn't allow selfjoins or joining a table twice because it can't alias tables properly (common dimensions?)

Kindly vote...

Do you have the oracle client installed on the server (especially the oledb driver) and rebooted?

Synonyms work in Oracle, anxious to test them out in MS SQL Server.

I miss the advanced query designer of Access in SharePoint reportbuilder, where you can actually modify sql text and verify it graphically; instead of "oops, you modified the sql-statement, no...

There is an upgrade path from 2008 to 2012.

Not sure if the converted ssis-packages will run out of the box.

Found this link about upgrading ssis to 2012

Thanks for the response.

I was hoping on some magic as the graphical query designer in Report Builder 3 doesn't alias tables nor accepts modifications in the sql.