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.
| Author |
Topic |
|
Vinothkumar
Starting Member
8 Posts |
 Posted - 2013-03-04 : 22:26:09
|
| I have 3 Questions1. 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 RegardsVinoth |
|
|
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 design2. Lots seehttp://msdn.microsoft.com/en-us/library/cc645577.aspx3. Improvement on what? query performance?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
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 RegardsVinoth |
|
|
|
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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
Vinothkumar
Starting Member
8 Posts |
Posted - 2013-03-05 : 05:47:25
|
| yes,i m trying to change design...Could you help me? |
|
|
|
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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
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 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-05 : 06:35:29
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Sql Server 2008 R2 using 2012