Create a table from select Queries.

Hi,

I wanted to know a query which will create a final result table from a combination of select queries.

The select query is like :
1. select col1 , col2 , null from table1
2. select null , col2 , null from table2
3. select null , null , col3 from table 3.

null are inserted as i wanted a single select query which will merge all the columns from all the tables and finally create a result table.

Thanks in advance.select *
into resulttable
from (
select col1 as col1,
col2 as col2,
null as col3
from table1
union all
select null ,
col2 ,
null
from table2
union all
select null ,
null ,
col3
from table3
) as tm

CR 6.0 multiple DSN queries and joins

Hi all, I'm new to this forum so will try to ask only relevant questions on point. What I am looking to do is query multiple DSN sources and join the results in a consolidated report using CR 6.0. Does anyone know if I can query multiple DSN's with CR 6.0 and if so what might the connection string look like?

Thanks in advance.

Cheers

DanSKIf the DSNs point to different database, I think it is not possible. Export the tables in single database and link them

CPU Using - Audit Logout

I have a VP app. that uses some queries from SQL Server 2000.
I'm noticing in SQL Profiler that the event "Audit Logout" is using alot of
cpu at times.
How can I decrease these CPU times ?Keep the connection open.
"Tahir Ozmen" <tahirozmen(at)hotmail.com> wrote in message
news:O9QSMS9wDHA.1996@.TK2MSFTNGP12.phx.gbl...
> I have a VP app. that uses some queries from SQL Server 2000.
> I'm noticing in SQL Profiler that the event "Audit Logout" is using alot
of
> cpu at times.
> How can I decrease these CPU times ?
>|||> Keep the connection open.
i cant keep the connection open.
Is there any other solution for this problem.
> "Tahir Ozmen" <tahirozmen(at)hotmail.com> wrote in message
> news:O9QSMS9wDHA.1996@.TK2MSFTNGP12.phx.gbl...
> > I have a VP app. that uses some queries from SQL Server 2000.
> >
> > I'm noticing in SQL Profiler that the event "Audit Logout" is using alot
> of
> > cpu at times.
> > How can I decrease these CPU times ?
> >
> >
>|||My guess is that it is cleaning up a lot of server side cursors when it
spikes the cpu. Can you tell if the times when it happens if any of the
queries used server side over client side?
--
Andrew J. Kelly SQL MVP
"Tahir Ozmen" <tahirozmen(at)hotmail.com> wrote in message
news:O9QSMS9wDHA.1996@.TK2MSFTNGP12.phx.gbl...
> I have a VP app. that uses some queries from SQL Server 2000.
> I'm noticing in SQL Profiler that the event "Audit Logout" is using alot
of
> cpu at times.
> How can I decrease these CPU times ?
>|||We have a VB application. Over Timer control, we have run SQL queries. These
query types are, sometimes SELECT sometimes UPDATE. Everty time that app.
run, these queries executed. Every Connecion's Cursor Location is Client
Side. When we check SQL Profiler, Audit Logout events's CPU has been
increased. I think this is caused for operating systems CPU usage. How can
we decrease that high CPU usage or How can we decrease Audit Logout usage ?
Thanks a lot.
"Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
news:OFpNTl%23wDHA.1908@.TK2MSFTNGP10.phx.gbl...
> My guess is that it is cleaning up a lot of server side cursors when it
> spikes the cpu. Can you tell if the times when it happens if any of the
> queries used server side over client side?
> --
> Andrew J. Kelly SQL MVP
>
> "Tahir Ozmen" <tahirozmen(at)hotmail.com> wrote in message
> news:O9QSMS9wDHA.1996@.TK2MSFTNGP12.phx.gbl...
> > I have a VP app. that uses some queries from SQL Server 2000.
> >
> > I'm noticing in SQL Profiler that the event "Audit Logout" is using alot
> of
> > cpu at times.
> > How can I decrease these CPU times ?
> >
> >
>|||The logout is probably not using much time at all. More of a total. I know
this is true of duration, and I am pretty sure it is true of CPU. It is not
a perfect addition of all of the other rows, so I might be wrong, but I am
sure that the logout operation is not one of the more costly operations.
However, if applications are making and breaking too many connections, it
can become an issue.
--
----
--
Louis Davidson (drsql@.hotmail.com)
Compass Technology Management
Pro SQL Server 2000 Database Design
http://www.apress.com/book/bookDisplay.html?bID=266
Note: Please reply to the newsgroups only unless you are
interested in consulting services. All other replies will be ignored :)
"Tahir Ozmen" <tahirozmen(at)hotmail.com> wrote in message
news:O9QSMS9wDHA.1996@.TK2MSFTNGP12.phx.gbl...
> I have a VP app. that uses some queries from SQL Server 2000.
> I'm noticing in SQL Profiler that the event "Audit Logout" is using alot
of
> cpu at times.
> How can I decrease these CPU times ?
>|||But it's a cumulative count of the resources used for the lifetime of the
connection so whilst it may appear high it should be roughly the sum of the
CPU the connection used executing queries etc. Thus it being high or low
does not mean much, it's generally more interesting to look at those
statements that consumed most of the resources during the lifetime of the
connection if you see what I mean
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Tahir Ozmen" <tahirozmen(at)hotmail.com> wrote in message
news:O9QSMS9wDHA.1996@.TK2MSFTNGP12.phx.gbl...
> I have a VP app. that uses some queries from SQL Server 2000.
> I'm noticing in SQL Profiler that the event "Audit Logout" is using alot
of
> cpu at times.
> How can I decrease these CPU times ?
>|||Yes as Jasper points out this is a cumlative counter and will increase over
time as expected.
--
Andrew J. Kelly SQL MVP
"Tahir Ozmen" <tahirozmen(at)hotmail.com> wrote in message
news:%23L1$80%23wDHA.2316@.TK2MSFTNGP10.phx.gbl...
> We have a VB application. Over Timer control, we have run SQL queries.
These
> query types are, sometimes SELECT sometimes UPDATE. Everty time that app.
> run, these queries executed. Every Connecion's Cursor Location is Client
> Side. When we check SQL Profiler, Audit Logout events's CPU has been
> increased. I think this is caused for operating systems CPU usage. How can
> we decrease that high CPU usage or How can we decrease Audit Logout usage
?
>
> Thanks a lot.
>
>
> "Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
> news:OFpNTl%23wDHA.1908@.TK2MSFTNGP10.phx.gbl...
> > My guess is that it is cleaning up a lot of server side cursors when it
> > spikes the cpu. Can you tell if the times when it happens if any of the
> > queries used server side over client side?
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "Tahir Ozmen" <tahirozmen(at)hotmail.com> wrote in message
> > news:O9QSMS9wDHA.1996@.TK2MSFTNGP12.phx.gbl...
> > > I have a VP app. that uses some queries from SQL Server 2000.
> > >
> > > I'm noticing in SQL Profiler that the event "Audit Logout" is using
alot
> > of
> > > cpu at times.
> > > How can I decrease these CPU times ?
> > >
> > >
> >
> >
>|||Ok. Firstly, Thank you very much. From Now on, what sholud we do ? Have you
any idea ?
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:O8v2zj$wDHA.1500@.TK2MSFTNGP12.phx.gbl...
> But it's a cumulative count of the resources used for the lifetime of the
> connection so whilst it may appear high it should be roughly the sum of
the
> CPU the connection used executing queries etc. Thus it being high or low
> does not mean much, it's generally more interesting to look at those
> statements that consumed most of the resources during the lifetime of the
> connection if you see what I mean
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Tahir Ozmen" <tahirozmen(at)hotmail.com> wrote in message
> news:O9QSMS9wDHA.1996@.TK2MSFTNGP12.phx.gbl...
> > I have a VP app. that uses some queries from SQL Server 2000.
> >
> > I'm noticing in SQL Profiler that the event "Audit Logout" is using alot
> of
> > cpu at times.
> > How can I decrease these CPU times ?
> >
> >
>

CPU Usage(%), Logical IO Performed (%) Usage for Adhoc Queries is 90%

Hello, When I am seeing SQL Server 2005 Management studio Server Dashboard> I am seeing my(USERS) databases and msdb database usage is very small % of in CPU Usage(%), Logical IO Performed (%) Usage pie chart.

90% of Total cpu usage is showing for Adhoc Queries. what excatly this means in Dashboard? if application uses more than it would have shown in Database level or not?

sicerely this dashboard is good, if any one is watching daily, please advice their experiences here.

Thanks in advance. Hail SQL Server!

This means that of all the CPU and I/O performed 90% is coming from Adhoc Queries, it does not mean 90% CPU usage.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

Counting total number of queries executed within the page

Hi everyone,

Does exist an easy way to count the actually number of queries executed within a page?

I've searched here and in google but found anything...

Thanks in advance!

If SQL Server is your backend database, you can use SQL Profiler to run a trace on the statements executed.

|||

The db is sql server 2000, but it's on a shared server.. can I use the profiler in a shared environment too?

In case I can use it, does it aggregate someqhat the queries per ASP.NET page executed?

Thanks!

|||

>can I use the profiler in a shared environment too?
You can limit it by database.

>In case I can use it, does it aggregate someqhat the queries per ASP.NET page executed?
Given the right option it will report each query run.