<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Times New Roman","serif";
color:black;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='color:black'>Sorry all. Moderator error.<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu] <b>On Behalf Of </b>CORREIA Marc<br><b>Sent:</b> Thursday, October 03, 2013 6:21 PM<br><b>To:</b> 'sap-wug@mit.edu'<br><b>Subject:</b> SWWCNTP0 very large compared to SWWIHEAD<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue'>Hi I send this through but it has not been posted, can you tell me why please?</span><o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue'>Thanks</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue'>Marc.</span><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div class=MsoNormal align=center style='text-align:center'><hr size=2 width="100%" align=center></div><p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> CORREIA Marc <br><b>Sent:</b> Wednesday, 2 October 2013 1:53 PM<br><b>To:</b> 'sap-wug@mit.edu'<br><b>Subject:</b> SWWCNTP0 very large compared to SWWIHEAD</span><o:p></o:p></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Hi all</span><o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Table SWWCNTP0 is way bigger than SWWIHEAD in our production SRM system. Can you advise if this is normal behaviour? Its seems to be considerably larger if you consider that SWWIHEAD is only 2.9 Gig, yet SWWCNTP0 is 23 gig.</span><o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Can you advise what strategies could be adopted to manage the size. Is there anything I can do to help manage the growth, or prevent it somehow? The solution has only been live for just over a year, so I would not have anticipated the table growing quite this quickly.</span><o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Any advice would be greatly appreciated. The organisation does not have an archiving strategy in place yet, so for now I don't think that archiving is an option, </span><o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Regards</span><br><br><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Marc Correia</span></b><span style='font-size:10.0pt'> </span><br><img width=141 height=3 id="_x0000_i1026" src="cid:image001.png@01CEC0DB.CE587EC0"><br><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Workflow Developer</span><o:p></o:p></p></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Service Operations and Support <br>City of Gold Coast <br><br><b>T:</b> 5581 6611 <b>M:</b> 0422 632 696 <br>PO Box 5042 Gold Coast Mail Centre Qld 9729<br><b><a href="http://www.cityofgoldcoast.com.au/"><span style='color:black'>cityofgoldcoast.com.au</span></a></b><br><br><img border=0 width=141 height=3 id="_x0000_i1027" src="cid:image001.png@01CEC0DB.CE587EC0"><br><img border=0 width=168 height=42 id="_x0000_i1028" src="cid:image002.png@01CEC0DB.CE587EC0"></span><o:p></o:p></p><div><p class=MsoNormal> <o:p></o:p></p></div><p><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Tell us about an unsung hero... Nominations are open for City of Gold Coast's 2014 Australia Day Awards. The awards recognise individuals and groups who have made an outstanding contribution to our community.</span></b><o:p></o:p></p><p><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Visit cityofgoldcoast.com.au/australiadayawards for information. Nominations close 15 November 2013.</span></b><o:p></o:p></p><p><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'> </span></b><o:p></o:p></p><p style='margin-bottom:12.0pt'><o:p> </o:p></p><p><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Council of the City of Gold Coast / Gold Coast City Council - confidential communication</span></b><o:p></o:p></p><p><span style='font-size:8.0pt;font-family:"Arial","sans-serif"'>This email and any files transmitted with it are confidential and are intended solely for the use of the addressee. If you are not the intended recipient be advised that you have received this email in error and that any use, dissemination, forwarding, printing or copying of this email and any file attachments is strictly prohibited. If you have received this email in error, please immediately notify us. You must destroy the original transmission and its contents. Before opening or using attachments, check them for viruses and defects. The contents of this email and its attachments may become scrambled, truncated or altered in transmission. Please notify us of any anomalies. Our liability is limited to resupplying the email and attached files or the cost of having them resupplied.</span><o:p></o:p></p><p><span style='font-size:8.0pt;font-family:"Arial","sans-serif"'> </span><o:p></o:p></p></div></body></html>