Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
 Posted - 2011-01-31 : 14:41:51
|
| Hi i have a script which takes some time (dependent to the amount of data). is there any way through which i can calculate the amount of data processed in terms of time (for the front end of an application or in the Messages Tab of the SSMS): total time, Ramining Time, Time elapsed etc or In terms of Percentage out of 100%. Many thanks! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-02-10 : 15:04:32
|
No. Unless you are doing a WHILE LOOP in which you can useRAISERROR('This is percentage %d.', 10, 1, @Percentage) WITH NOWAIT
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-11 : 00:03:18
|
this was an interview question for the post of database developer  ... any how thanks peso for confirming what i responded at that time! |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-02-11 : 08:09:34
|
Progress bars tell the world "my code is slow and I'm unable to speed it up". Tell them you prefer to write code that doesn't need them, and can't use them anyway because it runs so fast.  |
|
|
|
|
|
|
progress bar