December 2, 2014 at 6:03 pm
Dear SQLServerCentral administrators and members:
Hello, a pleasant day to everyone.
I have been developing RDL (and it uses stored procedure to get data) for quite sometime in this company I am working for. Our previous database administrator is the one who checked my stored procedure and advises me to make some changes if my stored procedure needed enhancement. And a year later he resigned. 🙁
And came this new database admin, now he wants me to revise all of my stored procedure specif. those stored procedures having an [font="Courier New"]ORDER BY[/font] clause.:angry:
He said just sort it in the report/RDL, because it will somehow unload some overhead in the database, which, will make my report to generate data faster. Is his reason valid? Is there additional reading I could read to validate this? Or it is just a simple rule of thumb? (As he said, no ORDER BY clause, and no formatting (example on dates, time, etc.) in stored procedure, do all the formatting/sorting in the RDL. I am still halfway to go of my changes but I want to learn more about on what he's keep on instructing. Please advise.
Thank you and more power to all.:-)
Very truly Yours,
Mark Squall
________________________________
"Listen to advice and accept instruction, and in the end you will be wise." -Proverbs 19:20
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply