Re: SQL Query question

2010-10-20 Thread Jeff Steward
al size. > > We may have been looking for a Horse and ignored the Zebra. > > BF > > > -Original Message- > From: Tigran K [mailto:tigr...@gmail.com] > Sent: Wednesday, October 20, 2010 1:12 AM > To: NT System Admin Issues > Subject: Re: SQL Query question &g

RE: SQL Query question

2010-10-20 Thread Bob Fronk
K [mailto:tigr...@gmail.com] Sent: Wednesday, October 20, 2010 1:12 AM To: NT System Admin Issues Subject: Re: SQL Query question Did you change excel versions as well? This might be an excel issue. Take a look at http://www.google.com/search?q=excel+file+growing+in+size There seems to be a lot o

Re: SQL Query question

2010-10-20 Thread Jeff Steward
gt; > > > *From:* Ken Schaefer [mailto:k...@adopenstatic.com] > *Sent:* Tuesday, October 19, 2010 9:43 PM > > *To:* NT System Admin Issues > *Subject:* RE: SQL Query question > > > > It was just a thought – your old table might have had 10 columns. After the > p

Re: SQL Query question

2010-10-19 Thread Tigran K
ist?CheersRyan  From: Ken Schaefer > [mailto:k...@adopenstatic.com] > Sent: Tuesday, October 19, 2010 9:43 PM > To: NT System Admin Issues > Subject: RE: SQL Query question It was just a thought – your old table might > have had 10 columns. After the product upgrade, the table

RE: SQL Query question

2010-10-19 Thread Ryan Finnesey
Can anyone recommend a good SQL List? Cheers Ryan From: Ken Schaefer [mailto:k...@adopenstatic.com] Sent: Tuesday, October 19, 2010 9:43 PM To: NT System Admin Issues Subject: RE: SQL Query question It was just a thought - your old table might have had 10 columns. After the product

RE: SQL Query question

2010-10-19 Thread Ken Schaefer
4x increase does seem very large. Cheers Ken From: Bob Fronk [mailto:b...@btrfronk.com] Sent: Wednesday, 20 October 2010 12:07 AM To: NT System Admin Issues Subject: RE: SQL Query question Recreating the previous environment isn't possible due to licensing, etc. I could potentially create

Re: SQL Query question

2010-10-19 Thread Andrew S. Baker
*From:* Ken Schaefer [mailto:k...@adopenstatic.com] > *Sent:* Tuesday, October 19, 2010 12:02 PM > > *To:* NT System Admin Issues > *Subject:* RE: SQL Query question > > > > If the application has changed, are you sure that the underlying tables > haven’t changed? If the ta

RE: SQL Query question

2010-10-19 Thread Michael B. Smith
l B. Smith Consultant and Exchange MVP http://TheEssentialExchange.com From: Bob Fronk [mailto:b...@btrfronk.com] Sent: Tuesday, October 19, 2010 12:07 PM To: NT System Admin Issues Subject: RE: SQL Query question Recreating the previous environment isn't possible due to licensing, etc. I

RE: SQL Query question

2010-10-19 Thread Bob Fronk
ot;hidden" data be? From: Ken Schaefer [mailto:k...@adopenstatic.com] Sent: Tuesday, October 19, 2010 12:02 PM To: NT System Admin Issues Subject: RE: SQL Query question If the application has changed, are you sure that the underlying tables haven't changed? If the tables have change

RE: SQL Query question

2010-10-19 Thread Ken Schaefer
If the application has changed, are you sure that the underlying tables haven't changed? If the tables have changed, and Excel is pulling in all data from the relevant tables, it may be possible that the tables have additional columns now, and this is resulting in increased size. Alternatively,