SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Other SQL Server 2012 Topics
 Sql Server 2008 R2 using 2012
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Vinothkumar
Starting Member

India
8 Posts

Posted - 03/04/2013 :  22:26:09  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 03/04/2013 :  22:46:37  Show Profile  Reply with Quote
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

India
8 Posts

Posted - 03/05/2013 :  02:25:31  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 03/05/2013 :  03:56:23  Show Profile  Reply with Quote
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

India
8 Posts

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

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 03/05/2013 :  06:05:03  Show Profile  Reply with Quote
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

India
8 Posts

Posted - 03/05/2013 :  06:13:29  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 03/05/2013 :  06:35:29  Show Profile  Reply with Quote
welcome

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

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000