[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How to Denormalize a Table with SQL Server Query

Posted on 2009-12-28
2
Medium Priority
?
720 Views
Last Modified: 2012-05-08
I have a table I need to denormalize and would like to do this with a sql query. Each row within the table contains a parameter and a job name. I want capture the parameters for each job on one row.

Can this be done with sql?
0
Comment
Question by:iBinc
  • 2
2 Comments
 
LVL 5

Accepted Solution

by:
sureshchsahu earned 2000 total points
ID: 26135990
The below link give you the clear picture how to denormalize and denormalize guidelines.

http://www.craigsmullins.com/ssu_1200.htm
0
 
LVL 5

Expert Comment

by:sureshchsahu
ID: 26135999
Below is one more link which will guide you to Denormalize for increasing the performance.

http://www.sqlteam.com/article/denormalize-for-performance
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question