Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Other SQL Server 2012 Topics
 Sql Server 2008 R2 using 2012

Author  Topic 

Vinothkumar
Starting Member

8 Posts

Posted - 2013-03-04 : 22:26:09
I have 3 Questions

1. How we can optimize the existing design on 2008 R2 using 2012.

2. What are the new features we can use, which will reduce the effort which we are putting to achieve any task.

3. Any improvement we can apply using 2012.



Can anyone help to me...

Thanks and Regards

Vinoth

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-03-04 : 22:46:37
1. By design do you mean database design? Is your DB an OLTP or an OLAP system? This is one of major factor in deciding on design
2. Lots
see
http://msdn.microsoft.com/en-us/library/cc645577.aspx

3. Improvement on what? query performance?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Vinothkumar
Starting Member

8 Posts

Posted - 2013-03-05 : 02:25:31
Hi
I was telling the DWH design and i am using OLTP System now.how we can improve the performance and optimizing the design

Thanks and Regards

Vinoth
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-03-05 : 03:56:23
DWH and OLTP are two different things. So are you trying to change design to adapt OLTP system to OLAP?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Vinothkumar
Starting Member

8 Posts

Posted - 2013-03-05 : 05:47:25
yes,i m trying to change design...Could you help me?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-03-05 : 06:05:03
So are you tables currently normalised? is the attempt to denormalise it based on how your report application needs it?
Its not a single step process. You need to identify your target users and their interested business entitites first. then define grain ie level of detail. Finally identify your facts and dimensions required for application.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Vinothkumar
Starting Member

8 Posts

Posted - 2013-03-05 : 06:13:29
ok,i ill do while i done let you know.thank you so much..

regards
vinoth
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-03-05 : 06:35:29
welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -