What I do now in such cases is I determine the average of dependant rows per dependant table for one parent row and adjust the top-statement. I also document this...

thanks for the feedback

Nice article.

What I would like to do is to profile a sqlservers activities, store that trace-info in a table on another sqlserver and viewing only the latest hour of activity...

Is there any advantage of doing so ?

- The avatar is my ntv650 easy riding with a bit of curves-fun.

The blade is like a wet dream with all these speedtraps they are implementing in Belgium(Flanders-part)

Books Online (BOL)

You can also search this site (sqlservercentral.com) for usefull scripts

Don't know where I got it from, but I 've modified it a bit to be suitable for virtual servers.

-- This script will get the listening port of the

--...

Maybe you should take locking into consideration.

Your methode will do fine, but when used with big volumes, the delete might lockout the table. You could avoid this by using...

the double quotes should be single quotes in this query. Then it should work just fine.

select [id], [desc], convert(float,Sum_Total) / convert(float,Sum_GTotal)

from (

SELECT [id], [desc], SUM(case flag when "Total" then [count] else 0 end ) as Sum_Total, SUM(case flag when "GTotal" then [count] else 0 end...

1 - not yet my domain

2 - t-sql your full query with "show execution plan" / "show estimated execution plan"

3 - no...

from BOL :

-h headers

Specifies the number of rows to print between column headings. The default is to print headings one time for each set of query results. Use -1...

C:\>isql /?

isql: unknown option ?

usage: isql              [-U login id]          [-P password]

  [-S server]            [-H hostname]          [-E trusted connection]

  [-d use database name] [-l login timeout]     [-t query timeout]

  [-h headers]          ...

That's a T-sql option :

Tools\Options\Results uncheck the checkbox and apply.

Your applications will not have this by default.

- aparently I can only "reply with quotes". Normal reply does not have an accessable textbox.

- can you provide the toppic's subject in the reply-notifications-email  ?