Forum Replies Created

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

  • RE: the use of CTEs

    erics44 (1/6/2016)

    Alan.B (1/6/2016)

    This is just silly. Every MVP and Certified Master whose article and/or book I have read uses CTEs. And I use them and I know how to design...

    "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 6, 2016 at 2:40 pm

    #1850042

  • RE: Are the posted questions getting worse?

    Jeff Moden (1/6/2016)

    Alan.B (1/5/2016)

    SQLBill (1/5/2016)

    Lynn Pettis (1/4/2016)

    SQLBill (1/4/2016)

    Lynn Pettis (1/4/2016)

    SQLBill (1/4/2016)

    I stayed up way longer than normal during the holiday break, but I forced myself to get in the bed...

    "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 6, 2016 at 12:33 pm

    #1849992

  • RE: the use of CTEs

    Sergiy (1/5/2016)

    Alan.B (1/5/2016)[hrWhat I was demonstrating was in response to the OP's original question and is why someone would use a CTE instead of doing a direct update... especially when...

    "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 6, 2016 at 11:41 am

    #1849969

  • RE: Are the posted questions getting worse?

    SQLBill (1/5/2016)

    Lynn Pettis (1/4/2016)

    SQLBill (1/4/2016)

    Lynn Pettis (1/4/2016)

    SQLBill (1/4/2016)

    I stayed up way longer than normal during the holiday break, but I forced myself to get in the bed (and sleep) on...

    "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 11:15 am

    #1849618

  • 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

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