I realized that you probably know your database a lot better than TrImp. I don't know why he has such a hardon for SQL.I understand but its a lot easier for me just to make a script although its fun to think about this I guess.
I understand but its a lot easier for me just to make a script although its fun to think about this I guess.
or you could just write a view and save it, then call the view up once a month...If you can write something in all SQL without using cursors its generally much faster.
You can just save the query in a sproc and then next month you just come along and type EXEC sp_get_most_ignored_users and there it is.
I realized that you probably know your database a lot better than TrImp. I don't know why he has such a hardon for SQL.
I mean SQL is nifty and all, but you have to use the best tool for the job.
or you could just write a view and save it, then call the view up once a month...
maybe his priority was how easy/fast he could create it, not how efficient it would be?It took his script over 20 minutes to run. There are only about (edit) 50,000 rows in this table (one for each user). Hardly the best tool for the job.
the script runs in less than a second, I just had to find it.It took his script over 20 minutes to run. There are only about (edit) 50,000 rows in this table (one for each user). Hardly the best tool for the job.
mm, good point.Sure. I just hesitate to put that kind of thing in a view since its computationally intensive... you dont want people writing queries against it without realizing what they are doing and calling on it all the time.
the script runs in less than a second, I just had to find it.
thats straight pathetic.
especially coming from this forum.... one of the last places on the net where one can say what they want.
amazing!
It took his script over 20 minutes to run. There are only about (edit) 50,000 rows in this table (one for each user). Hardly the best tool for the job.