Author |
Topic |
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-13 : 16:02:46
|
so true!EDIT:unfortunatly the link doesn't work anymore, so i've removed it.if i find it again i'll re-post itEDIT 2:found it on youtube:http://www.youtube.com/watch?v=bm96X5nyB9M_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
nandan
Starting Member
10 Posts |
Posted - 2007-09-13 : 16:35:51
|
Hi ThereI tried using Statistics IO ONbut i want to know when u execute the query it will display u cpu time elasped time and duration timewhich are the options that need to be considered and if u use execution plan what are the options that need to be considered like estimated rows,actual rows, index seek, index scan and joins |
 |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-13 : 16:46:06
|
this is a job for the hell desk! [hell desk transforms to super hell desk]quote: Originally posted by nandan Hi ThereI tried using Statistics IO ONbut i want to know when u execute the query it will display u cpu time elasped time and duration timewhich are the options that need to be considered and if u use execution plan what are the options that need to be considered like estimated rows,actual rows, index seek, index scan and joins
--------------------keeping it simple... |
 |
|
Zoroaster
Aged Yak Warrior
702 Posts |
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-14 : 04:31:09
|
huh?it downloaded the video for me just fine..._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-09-14 : 04:47:17
|
quote: Originally posted by spirit1 huh?it downloaded the video for me just fine..._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp
No it is not MadhivananFailing to plan is Planning to fail |
 |
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-14 : 04:53:17
|
heh... yeah.. i viewed it yesterday...today the link doesn't seem to work...and yes it looks like it's hosted on a porn site... oh well... i might as well remove it... bummer... it was funny._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-09-14 : 05:06:25
|
Thanks. Nice oneMadhivananFailing to plan is Planning to fail |
 |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-09-14 : 05:22:39
|
quote: Originally posted by madhivanan Thanks. Nice oneMadhivananFailing to plan is Planning to fail
Which one are you referring to ? KH[spoiler]Time is always against us[/spoiler] |
 |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-09-14 : 05:29:03
|
quote: Originally posted by khtan
quote: Originally posted by madhivanan Thanks. Nice oneMadhivananFailing to plan is Planning to fail
Which one are you referring to ? KH[spoiler]Time is always against us[/spoiler]
Youtube MadhivananFailing to plan is Planning to fail |
 |
|
Kristen
Test
22859 Posts |
Posted - 2007-09-14 : 05:51:06
|
"unfortunatly the link doesn't work anymore, so i've removed it....found it on youtube:"Hooray. Things that just link to MOV files are pants compared to the slick way that YouTube streams them ...I gave up waiting for the download of the first link you posted after about 2 seconds ... |
 |
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|