Read my First Article in SQL Server Magazine – Oct 2007 [Articles are relocated so links are disabled]
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
SQL SERVER – UDF vs. Stored Procedures and Having vs. WHERE
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.
6 Comments. Leave new
Congradulations Dave,
Getting pulished in SQL Server Magazine is quite an accomplishment. With all the work you do for the community, you deffinately deserve it!
– Shawn
Dave,
I enjoy reading the article. Wonderfully written.
TC
Divang
Dave,
I will tell you what people will like most : articles about SQL Profiler. Think why? There is always long articles. Write simple and write to the point. DBA will love you.
Cheers,
S G
Pinal,
Could you address the differences between UDFs and SPs with regard to DML statements like INSERT, DELETE, UPDATE, etc?
It appears that UDFs cannot perform these operations, while SPs can.
Is that true?
Thanks,
Ted
Yes it is true
Hi Pinal…
your articles are very useful…I am an sql server database beginner.
I read that “we can change environment variables using sp’s ,but can’t with udf’s ” from one of your article -stored procedure vs udf.
My doubt is:
How to set environment variables using stored procedures.i did not know how to get those env var values ti t-sql.So,please give me an example to do this.It may be useful for beginners like me..
thanks,
durga.