masri999
3/28/2007 5:05:00 AM
On Mar 28, 3:57 am, Ramesh Subramaniyan
<RameshSubramani...@discussions.microsoft.com> wrote:
> hi all ,
> if i have table that contains 50 columns and 120 rows (data's ) .
> if i m executing a (select / insert /update) query . i have some server
> specification and client specification , and n/w specification . i want
> calculate time , that select query should take , update query should take . i
> need calculation based on table size , n/w size/ server size without using
> sql function ( set explain plan all , datediff) , i need calculation method
just before select capture getdate() intot a table or variable --
beforetime
after execution of select do the same thing --aftertime
find the difference in time with datediff(ms, beforetime,aftertime )
will give you time in milliseconds for select execution