Mickey Stuewe

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 34 total)

RE: Why Scalar Functions Can Be Costly

gocheski (1/5/2016)
Good Article, Just I was wondering about scalar function, the difference between having read from table inside and don't. In the first example where you're using dbo.fn_SumRangeOfNumbers() I guess...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.

January 5, 2016 at 7:42 pm

#1849724
RE: Why Scalar Functions Can Be Costly

winkl (1/4/2016)
Thanks for the article, Mickey.
Have you tested your scalar UDF using schemabinding? We're testing that now to see if we can bring some of the cost...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.

January 4, 2016 at 9:53 pm

#1849445
RE: Why Scalar Functions Can Be Costly

lucien.jacquet (1/4/2016)My point is not to contradict your assertion that scalar functions "can be" expensive, but to suggest that your example is a worst-case scenario. Is it possible that your...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.

January 4, 2016 at 9:41 pm

#1849442
RE: Why Scalar Functions Can Be Costly

A few of you commented on the fact I stated the wrong edition of SQL that User Defined Scalar functions were introduced in. I apologize. I will have it corrected....
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.

January 4, 2016 at 8:36 pm

#1849438
RE: Why Scalar Functions Can Be Costly

Hi Eirikur,
Thank you for the SQL Example. I agree whole heartedly with you. This article is one of three articles. The first, focusing on User Defined Scalar Functions...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.

January 4, 2016 at 8:25 pm

#1849436
RE: Why Scalar Functions Can Be Costly

Hi Everyone,
Thank you for all the comments and questions. I'm swamped at work today, so I will reply this evening when I get home (California time).
Cheers!
Mickey
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.

January 4, 2016 at 4:41 pm

#1849412
RE: Logging Tables

This post has great timing. Just yesterday I sent my manager an analysis of a log table that was created a year ago that is massive. I'm hoping I can...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.

September 25, 2015 at 10:16 am

#1829568
RE: No More Foreign Keys?

ZZartin (8/31/2015)
Just out of curiosity, it seems like a lot of people are putting a lot of faith in foreign key constraints I'm wondering why?
The job of the Foreign Key...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.

August 31, 2015 at 11:08 pm

#1823544
RE: No More Foreign Keys?

The applications that I've seen that are missing foreign keys have (at least these) three issues.
1. Bad data in fields that should be clean.
2. Extra deployments of the...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.

August 31, 2015 at 10:50 am

#1823421
RE: The Problem Solver

I am such a HUGE problem solver. I still need to learn what not to fix. It's frustrating for me to see bad design, and bad practices.
Thank you for...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.

August 28, 2015 at 12:46 pm

#1823139
RE: Training Computer Scientists

Steve, I think this is a great discussion topic and it has always evoked a lot of passion for people, usually based on their own background.
I've worked with people...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.

July 1, 2015 at 11:36 am

#1809621
RE: Writing Better T-SQL: Top-Down Design May Not be the Best Choice – Part II

stephen.kratowicz (6/23/2015)
Agreed, sequelgarrett. It seems as though with that point, the author is assuming you will use
SELECT *
FROM [viewWithTooManyColumns]
...but if you instead use
SELECT SomeColumnIReallyNeed, SomeOtherColumnIReallyNeed
FROM [viewWithTooManyColumns]
...then the...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.

June 23, 2015 at 7:07 pm

#1807606
RE: Writing Better T-SQL: Top-Down Design May Not be the Best Choice – Part II

sequelgarrett (6/23/2015)
Do the number of columns in the definition of the view really matter from a performance perspective? I thought the columns returned from a view only matter when the...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.

June 23, 2015 at 7:02 pm

#1807603
RE: Writing Better T-SQL: Top-Down Design May Not be the Best Choice – Part II

ron.lee (6/23/2015)
Good article.
I seem to get dragged into the same argument over time about whether to use select table.* to form a generic query reusable across reports or to...
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.

June 23, 2015 at 6:50 pm

#1807601
RE: Writing Better T-SQL: Top-Down Design May Not be the Best Choice

Thanks Jeff. I plan on it. 🙂
Mickey
Mickey Stuewe
Sr Database Developer
My blog
Follow me on twitter: @SQLMickey
Connect with me on LinkedIn
--------------------------------------------------------------------------
I laugh loudly and I laugh often. Just ask anyone who knows me.

June 3, 2015 at 11:00 pm

#1802869

Viewing 15 posts - 1 through 15 (of 34 total)