Re: SQL Query question

2010-10-20 Thread Jeff Steward 
Those stripes make good camouflage!

-Jeff Steward

On Wed, Oct 20, 2010 at 12:24 PM, Bob Fronk  wrote:

> We didn't notice the issue until the application / SQL upgrade.  However,
> the fix listed for the "Excel file growing issue" did reduce the file back
> to the original 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
>
> 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 of excel related topics.
>
> --Tigran
>
> On Tuesday, October 19, 2010, Ryan Finnesey <
> ryan.finne...@harrierinvestments.com> wrote:
> > Can anyone recommend a good SQL List?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 now
> > has 20 columns, because the upgraded version stores new stuff. The
> > suggestion that the application now uses Unicode is also a good one
> > (that would double the size of the data). However a 4x increase does
> > seem very large. CheersKen 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 a
> > SQL 2005 box and mount the old database, but this isn't my first
> > choice for many reasons. It is quite possible that available data in
> > the tables goes back further, but the queries are only looking at
> > specific periods, so this part isn't any "Larger" than before. (
> > Example:  Pulling AR data from a table for the current month. )  Are
> > you saying that ALL the data from the table is pulled into Excel, but
> > only the requested data is displayed?  Where would the "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 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, if you
> > can recreate the previous environment from a backup, then use SQL
> > Profiler to see what queries are being run before/after and what data
> > sets are being returned. CheersKen From: Bob Fronk
> > [mailto:b...@btrfronk.com]
> > Sent: Tuesday, 19 October 2010 11:57 PM
> > To: NT System Admin Issues
> > Subject: SQL Query question Good morning list! I am by no means a SQL
> > expert and especially not a query expert.  However, I have been asked
> > to review a problem that I believe has something to do with changing from
> SQL 2005 to SQL 2008R2. Brief background: The accounting system is industry
> specific and backend is SQL.  Recent version upgrade required conversion to
> SQL 2008.  A new SQL install to new hardware and all data migrated. Since
> the conversion, Excel queries of tables in the SQL database create
> substantially larger files than before.  In one instance a query of same
> table(s) went from 3300kb to 131500kb.  The data is the same, the queried
> tables are the same, but somehow the E This message is for the designated
> recipient only and may contain privileged, proprietary, or otherwise private
> information. If you have received it in error, please notify the sender
> immediately and delete the original. Any other use of the email by you is
> prohibited ~ Finally, powerful endpoint security that ISN'T a resource hog!
> ~
> > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>
> > ~
> >
> > ---
> > To manage subscriptions click here:
> http://lyris.sunbelt-software.com/read/my_forums/
> > or send an email to listmana...@lyris.sunbeltsoftware.com
> > with the body: unsubscribe ntsysadmin
> >
>
> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <
> http://www.sunbeltsoftware.com/Business/VIPRE-Enterpris

RE: SQL Query question

2010-10-20 Thread Bob Fronk 
We didn't notice the issue until the application / SQL upgrade.  However, the 
fix listed for the "Excel file growing issue" did reduce the file back to the 
original 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

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 of excel related topics.

--Tigran

On Tuesday, October 19, 2010, Ryan Finnesey 
 wrote:
> Can anyone recommend a good SQL List?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 now 
> has 20 columns, because the upgraded version stores new stuff. The 
> suggestion that the application now uses Unicode is also a good one 
> (that would double the size of the data). However a 4x increase does 
> seem very large. CheersKen 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 a 
> SQL 2005 box and mount the old database, but this isn't my first 
> choice for many reasons. It is quite possible that available data in 
> the tables goes back further, but the queries are only looking at 
> specific periods, so this part isn't any "Larger" than before. ( 
> Example:  Pulling AR data from a table for the current month. )  Are 
> you saying that ALL the data from the table is pulled into Excel, but 
> only the requested data is displayed?  Where would the "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 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, if you 
> can recreate the previous environment from a backup, then use SQL 
> Profiler to see what queries are being run before/after and what data 
> sets are being returned. CheersKen From: Bob Fronk 
> [mailto:b...@btrfronk.com]
> Sent: Tuesday, 19 October 2010 11:57 PM
> To: NT System Admin Issues
> Subject: SQL Query question Good morning list! I am by no means a SQL 
> expert and especially not a query expert.  However, I have been asked 
> to review a problem that I believe has something to do with changing from SQL 
> 2005 to SQL 2008R2. Brief background: The accounting system is industry 
> specific and backend is SQL.  Recent version upgrade required conversion to 
> SQL 2008.  A new SQL install to new hardware and all data migrated. Since the 
> conversion, Excel queries of tables in the SQL database create substantially 
> larger files than before.  In one instance a query of same table(s) went from 
> 3300kb to 131500kb.  The data is the same, the queried tables are the same, 
> but somehow the E This message is for the designated recipient only and may 
> contain privileged, proprietary, or otherwise private information. If you 
> have received it in error, please notify the sender immediately and delete 
> the original. Any other use of the email by you is prohibited ~ Finally, 
> powerful endpoint security that ISN'T a resource hog! ~
> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  
> ~
>
> ---
> To manage subscriptions click here: 
> http://lyris.sunbelt-software.com/read/my_forums/
> or send an email to listmana...@lyris.sunbeltsoftware.com
> with the body: unsubscribe ntsysadmin
>

~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ 
<http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin


~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

Re: SQL Query question

2010-10-20 Thread Jeff Steward 
Not a list but the forums on http://www.simple-talk.com/community/forums might
be helpful.

-Jeff Steward

On Wed, Oct 20, 2010 at 12:54 AM, Ryan Finnesey <
ryan.finne...@harrierinvestments.com> wrote:

> 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 upgrade, the table now has 20 columns, because the upgraded version
> stores new stuff. The suggestion that the application now uses Unicode is
> also a good one (that would double the size of the data).
>
>
>
> However a 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 a SQL 2005 box and mount the old database, but
> this isn’t my first choice for many reasons.
>
>
>
> It is quite possible that available data in the tables goes back further,
> but the queries are only looking at specific periods, so this part isn’t any
> “Larger” than before. ( Example:  Pulling AR data from a table for the
> current month. )  Are you saying that ALL the data from the table is pulled
> into Excel, but only the requested data is displayed?  Where would the
> “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 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, if you can recreate the previous environment from a backup,
> then use SQL Profiler to see what queries are being run before/after and
> what data sets are being returned.
>
>
>
> Cheers
>
> Ken
>
>
>
> *From:* Bob Fronk [mailto:b...@btrfronk.com]
> *Sent:* Tuesday, 19 October 2010 11:57 PM
> *To:* NT System Admin Issues
> *Subject:* SQL Query question
>
>
>
> Good morning list!
>
>
>
> I am by no means a SQL expert and especially not a query expert.  However,
> I have been asked to review a problem that I believe has something to do
> with changing from SQL 2005 to SQL 2008R2.
>
>
>
> Brief background:
>
>
>
> The accounting system is industry specific and backend is SQL.  Recent
> version upgrade required conversion to SQL 2008.  A new SQL install to new
> hardware and all data migrated.
>
>
>
> Since the conversion, Excel queries of tables in the SQL database create
> substantially larger files than before.  In one instance a query of same
> table(s) went from 3300kb to 131500kb.  The data is the same, the queried
> tables are the same, but somehow the Excel file is much larger.  When
> comparing a previous Excel file with a new one, the rows and columns are the
> same, the data is substantially the same.  The users are using a data
> connector from Excel to access the tables an import the data.  This process
> didn’t change.
>
>
>
> Any DBAs out there have input?
>
>
>
> BF
>
>
>
> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~
>
> ---
> To manage subscriptions click here:
> http://lyris.sunbelt-software.com/read/my_forums/
> or send an email to listmana...@lyris.sunbeltsoftware.com
> with the body: unsubscribe ntsysadmin
>
> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~
>
> ---
> To manage subscriptions click here:
> http://lyris.sunbelt-software.com/read/my_forums/
> or send an email to listmana...@lyris.sunbeltsoftware.com
> with the body: unsubscribe ntsysadmin
>
> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~
>
> ---
> To manage subscriptions click here:
> http://lyris.sunbelt-software.com/read/my_forums/
> or send an email to listmana...@lyris.sunbeltsoftware.com
> with the body: unsubscribe ntsysadmin

Re: SQL Query question

2010-10-19 Thread Tigran K 
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 of excel related topics.

--Tigran

On Tuesday, October 19, 2010, Ryan Finnesey
 wrote:
> Can anyone recommend a good SQL List?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 now has 20 columns, 
> because the upgraded version stores new stuff. The suggestion that the 
> application now uses Unicode is also a good one (that would double the size 
> of the data). However a 4x increase does seem very large. CheersKen 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 a SQL 2005 box 
> and mount the old database, but this isn’t my first choice for many 
> reasons. It is quite possible that available data in the tables goes back 
> further, but the queries are only looking at specific periods, so this part 
> isn’t any “Larger” than before. ( Example:  Pulling AR data from a table for 
> the current month. )  Are you saying that ALL the data from the table is 
> pulled into Excel, but only the requested data is displayed?  Where would the 
> “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 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, if you can recreate the previous environment 
> from a backup, then use SQL Profiler to see what queries are being run 
> before/after and what data sets are being returned. CheersKen From: Bob Fronk 
> [mailto:b...@btrfronk.com]
> Sent: Tuesday, 19 October 2010 11:57 PM
> To: NT System Admin Issues
> Subject: SQL Query question Good morning list! I am by no means a SQL expert 
> and especially not a query expert.  However, I have been asked to review a 
> problem that I believe has something to do with changing from SQL 2005 to SQL 
> 2008R2. Brief background: The accounting system is industry specific and 
> backend is SQL.  Recent version upgrade required conversion to SQL 2008.  A 
> new SQL install to new hardware and all data migrated. Since the conversion, 
> Excel queries of tables in the SQL database create substantially larger files 
> than before.  In one instance a query of same table(s) went from 3300kb to 
> 131500kb.  The data is the same, the queried tables are the same, but somehow 
> the E
> This message is for the designated recipient only and may contain privileged, 
> proprietary, or otherwise private information. If you have received it in 
> error, please notify the sender immediately and delete the original. Any 
> other use of the email by you is prohibited
> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~
>
> ---
> To manage subscriptions click here: 
> http://lyris.sunbelt-software.com/read/my_forums/
> or send an email to listmana...@lyris.sunbeltsoftware.com
> with the body: unsubscribe ntsysadmin
>

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

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 upgrade, the table now has 20 columns, because the upgraded
version stores new stuff. The suggestion that the application now uses
Unicode is also a good one (that would double the size of the data).

 

However a 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 a SQL 2005 box and mount the old
database, but this isn't my first choice for many reasons.

 

It is quite possible that available data in the tables goes back
further, but the queries are only looking at specific periods, so this
part isn't any "Larger" than before. ( Example:  Pulling AR data from a
table for the current month. )  Are you saying that ALL the data from
the table is pulled into Excel, but only the requested data is
displayed?  Where would the "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 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, if you can recreate the previous environment from a
backup, then use SQL Profiler to see what queries are being run
before/after and what data sets are being returned.

 

Cheers

Ken

 

From: Bob Fronk [mailto:b...@btrfronk.com] 
Sent: Tuesday, 19 October 2010 11:57 PM
To: NT System Admin Issues
Subject: SQL Query question

 

Good morning list!

 

I am by no means a SQL expert and especially not a query expert.
However, I have been asked to review a problem that I believe has
something to do with changing from SQL 2005 to SQL 2008R2.

 

Brief background:

 

The accounting system is industry specific and backend is SQL.  Recent
version upgrade required conversion to SQL 2008.  A new SQL install to
new hardware and all data migrated.

 

Since the conversion, Excel queries of tables in the SQL database create
substantially larger files than before.  In one instance a query of same
table(s) went from 3300kb to 131500kb.  The data is the same, the
queried tables are the same, but somehow the Excel file is much larger.
When comparing a previous Excel file with a new one, the rows and
columns are the same, the data is substantially the same.  The users are
using a data connector from Excel to access the tables an import the
data.  This process didn't change.

 

Any DBAs out there have input?

 

BF

 

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin


~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

RE: SQL Query question

2010-10-19 Thread Ken Schaefer 
It was just a thought - your old table might have had 10 columns. After the 
product upgrade, the table now has 20 columns, because the upgraded version 
stores new stuff. The suggestion that the application now uses Unicode is also 
a good one (that would double the size of the data).

However a 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 a SQL 2005 box and mount the old database, but this 
isn't my first choice for many reasons.

It is quite possible that available data in the tables goes back further, but 
the queries are only looking at specific periods, so this part isn't any 
"Larger" than before. ( Example:  Pulling AR data from a table for the current 
month. )  Are you saying that ALL the data from the table is pulled into Excel, 
but only the requested data is displayed?  Where would the "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 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, if you can recreate the previous environment from a backup, then 
use SQL Profiler to see what queries are being run before/after and what data 
sets are being returned.

Cheers
Ken

From: Bob Fronk [mailto:b...@btrfronk.com]
Sent: Tuesday, 19 October 2010 11:57 PM
To: NT System Admin Issues
Subject: SQL Query question

Good morning list!

I am by no means a SQL expert and especially not a query expert.  However, I 
have been asked to review a problem that I believe has something to do with 
changing from SQL 2005 to SQL 2008R2.

Brief background:

The accounting system is industry specific and backend is SQL.  Recent version 
upgrade required conversion to SQL 2008.  A new SQL install to new hardware and 
all data migrated.

Since the conversion, Excel queries of tables in the SQL database create 
substantially larger files than before.  In one instance a query of same 
table(s) went from 3300kb to 131500kb.  The data is the same, the queried 
tables are the same, but somehow the Excel file is much larger.  When comparing 
a previous Excel file with a new one, the rows and columns are the same, the 
data is substantially the same.  The users are using a data connector from 
Excel to access the tables an import the data.  This process didn't change.

Any DBAs out there have input?

BF



~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to 
listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com>
with the body: unsubscribe ntsysadmin

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to 
listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com>
with the body: unsubscribe ntsysadmin

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

Re: SQL Query question

2010-10-19 Thread Andrew S. Baker 
Perhaps the data is Unicode?  (although that doesn't seem like it would be
*that* large of a difference)

Is it possible for you to run a new report which contains the same data as
one of your old reports and export both from Excel to CSV to determine if
the data is in fact identical?

It could be something about how the data is being formatted in Excel.


*ASB *(My XeeSM Profile) <http://XeeSM.com/AndrewBaker>
*Exploiting Technology for Business Advantage...*
* *



On Tue, Oct 19, 2010 at 12:06 PM, Bob Fronk  wrote:

> Recreating the previous environment isn’t possible due to licensing, etc.
> I could potentially create a SQL 2005 box and mount the old database, but
> this isn’t my first choice for many reasons.
>
>
>
> It is quite possible that available data in the tables goes back further,
> but the queries are only looking at specific periods, so this part isn’t any
> “Larger” than before. ( Example:  Pulling AR data from a table for the
> current month. )  Are you saying that ALL the data from the table is pulled
> into Excel, but only the requested data is displayed?  Where would the
> “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 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, if you can recreate the previous environment from a backup,
> then use SQL Profiler to see what queries are being run before/after and
> what data sets are being returned.
>
>
>
> Cheers
>
> Ken
>
>
>
> *From:* Bob Fronk [mailto:b...@btrfronk.com]
> *Sent:* Tuesday, 19 October 2010 11:57 PM
> *To:* NT System Admin Issues
> *Subject:* SQL Query question
>
>
>
> Good morning list!
>
>
>
> I am by no means a SQL expert and especially not a query expert.  However,
> I have been asked to review a problem that I believe has something to do
> with changing from SQL 2005 to SQL 2008R2.
>
>
>
> Brief background:
>
>
>
> The accounting system is industry specific and backend is SQL.  Recent
> version upgrade required conversion to SQL 2008.  A new SQL install to new
> hardware and all data migrated.
>
>
>
> Since the conversion, Excel queries of tables in the SQL database create
> substantially larger files than before.  In one instance a query of same
> table(s) went from 3300kb to 131500kb.  The data is the same, the queried
> tables are the same, but somehow the Excel file is much larger.  When
> comparing a previous Excel file with a new one, the rows and columns are the
> same, the data is substantially the same.  The users are using a data
> connector from Excel to access the tables an import the data.  This process
> didn’t change.
>
>
>
> Any DBAs out there have input?
>
>
>
> BF
>
>
>
> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~
>
> ---
> To manage subscriptions click here:
> http://lyris.sunbelt-software.com/read/my_forums/
> or send an email to listmana...@lyris.sunbeltsoftware.com
> with the body: unsubscribe ntsysadmin
>
> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~
>
> ---
> To manage subscriptions click here:
> http://lyris.sunbelt-software.com/read/my_forums/
> or send an email to listmana...@lyris.sunbeltsoftware.com
> with the body: unsubscribe ntsysadmin
>

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

RE: SQL Query question

2010-10-19 Thread Michael B. Smith 
Ken is much more knowledgeable about SQL than I, but I think you may be running 
into a change between "simple data" and "fully described/decorated data". I 
don't have access to my lab right now, but you might take a look at the export 
format you chose.

Regards,

Michael 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 
could potentially create a SQL 2005 box and mount the old database, but this 
isn't my first choice for many reasons.

It is quite possible that available data in the tables goes back further, but 
the queries are only looking at specific periods, so this part isn't any 
"Larger" than before. ( Example:  Pulling AR data from a table for the current 
month. )  Are you saying that ALL the data from the table is pulled into Excel, 
but only the requested data is displayed?  Where would the "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 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, if you can recreate the previous environment from a backup, then 
use SQL Profiler to see what queries are being run before/after and what data 
sets are being returned.

Cheers
Ken

From: Bob Fronk [mailto:b...@btrfronk.com]
Sent: Tuesday, 19 October 2010 11:57 PM
To: NT System Admin Issues
Subject: SQL Query question

Good morning list!

I am by no means a SQL expert and especially not a query expert.  However, I 
have been asked to review a problem that I believe has something to do with 
changing from SQL 2005 to SQL 2008R2.

Brief background:

The accounting system is industry specific and backend is SQL.  Recent version 
upgrade required conversion to SQL 2008.  A new SQL install to new hardware and 
all data migrated.

Since the conversion, Excel queries of tables in the SQL database create 
substantially larger files than before.  In one instance a query of same 
table(s) went from 3300kb to 131500kb.  The data is the same, the queried 
tables are the same, but somehow the Excel file is much larger.  When comparing 
a previous Excel file with a new one, the rows and columns are the same, the 
data is substantially the same.  The users are using a data connector from 
Excel to access the tables an import the data.  This process didn't change.

Any DBAs out there have input?

BF



~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to 
listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com>
with the body: unsubscribe ntsysadmin

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to 
listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com>
with the body: unsubscribe ntsysadmin

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

RE: SQL Query question

2010-10-19 Thread Bob Fronk 
Recreating the previous environment isn't possible due to licensing, etc.  I 
could potentially create a SQL 2005 box and mount the old database, but this 
isn't my first choice for many reasons.

It is quite possible that available data in the tables goes back further, but 
the queries are only looking at specific periods, so this part isn't any 
"Larger" than before. ( Example:  Pulling AR data from a table for the current 
month. )  Are you saying that ALL the data from the table is pulled into Excel, 
but only the requested data is displayed?  Where would the "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 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, if you can recreate the previous environment from a backup, then 
use SQL Profiler to see what queries are being run before/after and what data 
sets are being returned.

Cheers
Ken

From: Bob Fronk [mailto:b...@btrfronk.com]
Sent: Tuesday, 19 October 2010 11:57 PM
To: NT System Admin Issues
Subject: SQL Query question

Good morning list!

I am by no means a SQL expert and especially not a query expert.  However, I 
have been asked to review a problem that I believe has something to do with 
changing from SQL 2005 to SQL 2008R2.

Brief background:

The accounting system is industry specific and backend is SQL.  Recent version 
upgrade required conversion to SQL 2008.  A new SQL install to new hardware and 
all data migrated.

Since the conversion, Excel queries of tables in the SQL database create 
substantially larger files than before.  In one instance a query of same 
table(s) went from 3300kb to 131500kb.  The data is the same, the queried 
tables are the same, but somehow the Excel file is much larger.  When comparing 
a previous Excel file with a new one, the rows and columns are the same, the 
data is substantially the same.  The users are using a data connector from 
Excel to access the tables an import the data.  This process didn't change.

Any DBAs out there have input?

BF



~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to 
listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com>
with the body: unsubscribe ntsysadmin

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

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, if you can recreate the previous environment from a backup, then 
use SQL Profiler to see what queries are being run before/after and what data 
sets are being returned.

Cheers
Ken

From: Bob Fronk [mailto:b...@btrfronk.com]
Sent: Tuesday, 19 October 2010 11:57 PM
To: NT System Admin Issues
Subject: SQL Query question

Good morning list!

I am by no means a SQL expert and especially not a query expert.  However, I 
have been asked to review a problem that I believe has something to do with 
changing from SQL 2005 to SQL 2008R2.

Brief background:

The accounting system is industry specific and backend is SQL.  Recent version 
upgrade required conversion to SQL 2008.  A new SQL install to new hardware and 
all data migrated.

Since the conversion, Excel queries of tables in the SQL database create 
substantially larger files than before.  In one instance a query of same 
table(s) went from 3300kb to 131500kb.  The data is the same, the queried 
tables are the same, but somehow the Excel file is much larger.  When comparing 
a previous Excel file with a new one, the rows and columns are the same, the 
data is substantially the same.  The users are using a data connector from 
Excel to access the tables an import the data.  This process didn't change.

Any DBAs out there have input?

BF



~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~   ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin