PASS Pro Now Available

Welcome to the next evolution of PASS. Unlock exclusive training, discounts, and networking opportunities designed to accelerate your data career. Learn More >

The official PASS Blog is where you’ll find the latest blog posts from PASS community members and the PASS Board. Contributors share their thoughts and discuss a wide variety of topics spanning PASS and the data community.

What Are the Different Types of User Defined Functions in SQL Server?

A few years ago, I did quite a few query tuning engagements. Many of my clients were small software companies who typically did not have a SQL Server DBA on staff. I looked for several anti-patterns, or what I like to call “red flags,” to help find ways that I could help improve performance. One common pattern I saw was the use of user defined functions (UDF).

Just the mention of UDFs in the SQL Server community makes folks cringe. UDFs can be “bad things,” and, to the optimizer, they are often black boxes. It’s also not easy to tell when they are bad by looking at the typical tools used for query tuning like execution plans. In fact, the bad UDFs hide what is really going on from the plan.

Read more

PASS Summit: A Big Part of My Life

I attended my first PASS Summit in Seattle in 2003 after about eighteen months in my job as a DBA. SQL Server Central had a post about a price increase coming up for Summit, and I showed the information to my manager not really thinking she would approve. Attending the conference meant a week away from the office as well as the expense of the conference and travel so I was thrilled when she said yes.

Read more

RSS

Theme picker

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids