Forum Replies Created

Viewing 15 posts - 1,066 through 1,080 (of 2,458 total)

  • RE: Stupid SSIS Question, I Need Help!

    SQLMark2012 (1/5/2016)

    Ok, I opened Visual Studio 2013

    File > New > Templates ...

    and yes, no "Business Intelligence" and hence no "Integration Services Project"

    following that, per your suggestion I went out and...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 5, 2016 at 9:54 am

    #1849581

  • RE: Longest Common Substring in an ITVF

    Very slick Chris.:-)

    I'm buried today but will play with this later tonight and report back.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 5, 2016 at 9:16 am

    #1849569

  • RE: Stupid SSIS Question, I Need Help!

    SQLMark2012 (1/5/2016)

    Ok, I have Visual Studio 2013 Installed, working and ready.

    What do I need to do next?

    Go to File > New >

    then...

    Templates > Business Intelligence > Integration Services Project

    If...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 5, 2016 at 9:11 am

    #1849566

  • RE: the use of CTEs

    Rich Mechaber (1/5/2016)

    Alan.B (1/4/2016)

    Except for recursive CTEs, CTEs and Subqueries are basically the same thing. I prefer CTEs for a couple things:

    First, for nested queries. CTEs make nested queries much...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 5, 2016 at 9:03 am

    #1849559

  • RE: Why Scalar Functions Can Be Costly

    Eirikur Eiriksson (1/4/2016)

    Alan.B (1/4/2016)

    I been banging my head trying to beat that mTVF for several months :hehe:

    Anything to ease the pain cause that got to hurt:-D

    😎

    I created a new thread...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 5, 2016 at 6:13 am

    #1849494

  • RE: the use of CTEs

    erics44 (1/4/2016)

    Yeah I agree, you don't need a cte

    And I can't see why you would use a cte in that situation, just adds a level of complexity

    Nobody said that...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 4, 2016 at 3:15 pm

    #1849385

  • RE: Why Scalar Functions Can Be Costly

    Eirikur Eiriksson (1/4/2016)

    Alan.B (1/4/2016)

    Eirikur Eiriksson (1/4/2016)

    Worse still are the multi-statement table-valued functions, in fact there is no excuse or justification for using those.

    I agree with this 99.9999% of the time...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 4, 2016 at 2:13 pm

    #1849363

  • 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...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 4, 2016 at 1:56 pm

    #1849353

  • RE: the use of CTEs

    erics44 (1/4/2016)

    Alan.B (1/4/2016)

    Except for recursive CTEs, CTEs and Subqueries are basically the same thing. I prefer CTEs for a couple things:

    First, for nested queries. CTEs make nested queries much more...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 4, 2016 at 12:39 pm

    #1849321

  • RE: Salary vs contract rate?

    If the FTE salary for my area is $130,000 to $140,000 for a senior level DBA, that would be about $65 (W2) per hour based on 2,000 hours per year....

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 4, 2016 at 12:30 pm

    #1849317

  • RE: Why Scalar Functions Can Be Costly

    patrickmcginnis59 10839 (1/4/2016)

    TheSQLGuru (1/4/2016)

    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...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 4, 2016 at 12:17 pm

    #1849308

  • RE: Why Scalar Functions Can Be Costly

    Phil Parkin (1/4/2016)

    Alan.B (1/4/2016)

    --

    For me, that's been the 0.0001% exception.

    Wow. That suggests you have written/tested 10,000 (or more) TVFs :w00t:

    I've been busy 😉

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 4, 2016 at 12:08 pm

    #1849307

  • RE: the use of CTEs

    Except for recursive CTEs, CTEs and Subqueries are basically the same thing. I prefer CTEs for a couple things:

    First, for nested queries. CTEs make nested queries much more readable and...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 4, 2016 at 12:05 pm

    #1849304

  • RE: Why Scalar Functions Can Be Costly

    Eirikur Eiriksson (1/4/2016)

    Worse still are the multi-statement table-valued functions, in fact there is no excuse or justification for using those.

    I agree with this 99.9999% of the time but I did...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 4, 2016 at 11:16 am

    #1849292

  • RE: Return N rows

    You can also take a peek at this:

    http://m.sqlmag.com/t-sql/avoid-unnecessary-lookups-when-using-rownumber-paging

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    January 4, 2016 at 7:31 am

    #1849219

Viewing 15 posts - 1,066 through 1,080 (of 2,458 total)