Are reports rendered faster in 2012 than 2008 r2?

Question

Hi im trying to make the business case to my manager to upgrade to SQL 2012 - I know one thing that would sway him is if reports ran faster.

Does anyone know if this is the case?

Thanks,

Zoe

 

Answer 1

Hi Zoe,

I dont think so...though i too have used reports both in SSRS 2008 R2 and SQL 2012, and both have moreless similar performance..

---

Amit
Please mark as answer if helpful
http://fascinatingsql.wordpress.com/

Answer 2

Hi im trying to make the business case to my manager to upgrade to SQL 2012 - I know one thing that would sway him is if reports ran faster.

Not automatically.

But Columnstore indexes in data warehouse database are nothing short of miracle.  "They are faster than a speeding bullet!"

Columnstore indexes are for static (second-hand dw) tables only, not for dynamic OLTP tables.

Articles:

Columnstore Indexes

http://www.sqlusa.com/sql-server-2012-new-features/

---

Kalman Toth SQL SERVER 2012 & BI TRAINING

Answer 3

I think the main reason to do the upgrade, is not just due to run reports faster but other features of 2012 edition. Read this

http://newtech.about.com/od/databasemanagement/a/Sql-Server-2011-Denali.htm

---

Many Thanks & Best Regards, Hua Min