In need of a complex query

[Tison]

I am trying to write a query that I can use to test server response times.
I have a simple table (Name char(8),Txt char(8), Number numeric(8))
This query does not do enough work ;
select name,txt,max(number) from steve_test
group by name
order by txt desc

Any ideas ?

 

[foxdev]

How many rows in the table?
Can you augment it with a second (or even third) table that is joinable?
Are you seeking to exercise the CPU or the disk I/O? --------------

http://www.art-factory-outlet.com

 

[Tison]

The table only has 100 rows.
I would not like to add other tables because I want a simple solution that I can copy to other servers.
I would like to exercise both cpu and io but at different runs.

 

[msi15]

Try this and give me ur feed back
select name,txt,max(number),substring(txt, 1,3), charindex(txt, "x&quot from steve_test
where (select count(*) from steve_test
group by name)
group by name
order by txt desc

Pls note: The reason for using substring and charindex is just to put load on the server (and also chk the syntax of the charindex thing)