cpu & memory usage on large, long-running query

Hi there
I'm not a SQL Server developer or power-user, mostly I do statistical and
similar analysis on large datasets and use SQL Server to manage the
underlying data.
I notice that, on my IBM workstation, my CPU utilization doesn't rise much
above 50% and my PF usage doesn't rise above 40% on large, long-running
queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
Can I whip up the speed a bit, or if not what's the limiting factor?
Best regards
Loane
If you aren't hitting any resource bottlenecks then look at
the execution plan for the queries and work on tuning the
queries themselves. One of the biggest factors will be use
of indexes. You can find a lot of information on performance
tuning at:
http://www.sql-server-performance.com/
-Sue
On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
<look_sharp_not@.hotmail.com> wrote:

>Hi there
>I'm not a SQL Server developer or power-user, mostly I do statistical and
>similar analysis on large datasets and use SQL Server to manage the
>underlying data.
>I notice that, on my IBM workstation, my CPU utilization doesn't rise much
>above 50% and my PF usage doesn't rise above 40% on large, long-running
>queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
>Can I whip up the speed a bit, or if not what's the limiting factor?
>Best regards
>Loane
>
|||Thanks Sue, will press on ...
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b2uk81lvrq2ekiq8fvgeug1f40ujnq5em9@.4ax.com...
> If you aren't hitting any resource bottlenecks then look at
> the execution plan for the queries and work on tuning the
> queries themselves. One of the biggest factors will be use
> of indexes. You can find a lot of information on performance
> tuning at:
> http://www.sql-server-performance.com/
> -Sue
> On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
> <look_sharp_not@.hotmail.com> wrote:
>

Coverting Access data to SQL query

Hi There
im try to find out if there is a way, of converting an Access db to a .SQL extension file.

I have some web space with a MySQL db attached, and i use phpMyAdmin to update, drop etc the database (i have no direct contact with it). I want all the data in my Access db onto my MySQL db without having to enter each row in. phpMyAdmin can use .SQL files to populate db, but i need to export the Access data into an SQL file format.
CAN ANYONE HELP?

AzureI'd suggest that you use an ETL tool. That makes this process much easier, although it assumes that you can get progmatic access to both of the databases.

If you can get ODBC access to both databases (MS-Access is a "gimme", the MySQL database could be easy or a challenge), then you have lots of choices at very low cost.

You can generate an SQL script from an Access database progmatcially, but it is often quite a bit of work. I'd strongly suggest that you investigate other choices first.

-PatP