Re: SQL Query question
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 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
RE: SQL Query question
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-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
Those stripes make good camouflage! -Jeff Steward On Wed, Oct 20, 2010 at 12:24 PM, Bob Fronk b...@btrfronk.com 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-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
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
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.commailto: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
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.commailto: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.commailto: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
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 b...@btrfronk.com 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
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.commailto: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.commailto: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
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
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-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
