Forum Replies Created

Viewing 15 posts - 751 through 765 (of 2,458 total)

  • RE: Talking baseball

    roryp 96873 (5/5/2016)

    Ray K (5/5/2016)

    I can well imagine!

    Just heed the warning of history! It's only May. Bigger collapses have happened in only a short period of 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

    May 5, 2016 at 12:05 pm

    #1876938

  • RE: Talking baseball

    This feels good for a change...

    "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

    May 5, 2016 at 9:44 am

    #1876892

  • RE: TSQL to create multiple lines in result set

    Something like this perhaps (I'm just guessing on the rank)...

    -- Sample data

    DECLARE @table TABLE ([Year] int, Region varchar(20));

    INSERT @table VALUES (2013, 'South'), (2014, 'North'), (2015, 'South'), (2015, 'North');

    --Review:

    --SELECT * FROM...

    "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

    May 5, 2016 at 8:38 am

    #1876874

  • RE: How to update a report object on multiple reports

    There are two ways to look at that question and, since I was not there I can't say for sure what they were asking.

    If they wanted to know how...

    "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

    May 5, 2016 at 8:23 am

    #1876860

  • RE: sql 2005 install on Windows 2008

    I think you can (go to msdn.com to find out for sure.

    SQL 2005 has been retired fyi.

    "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

    May 4, 2016 at 3:53 pm

    #1876734

  • RE: SSIS package failure

    A couple things here.

    First, the message is pretty clear. The SSIS package is failing because the login for SA, inside at least one of your SSIS connection managers is...

    "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

    May 4, 2016 at 3:47 pm

    #1876733

  • RE: How to generate new Int ID for multiple columns

    drew.allen (5/4/2016)

    Alan.B (5/4/2016)

    ROW_NUMBER does not take ties into consideration, RANK and DENSE_RANK do.

    I would phrase that differently. They all take ties into consideration: RANK and DENSE_RANK treat ties...

    "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

    May 4, 2016 at 2:08 pm

    #1876724

  • RE: how to trim away the first 'x' and last 'y number of characters from a string

    Another way. And this will work for multiple trailing numbers or when there aren't any.

    DECLARE @strings TABLE (LoginID VARCHAR(100))

    INSERT INTO @strings

    VALUES ('adventure-works\peter0'), ('Northwind\mary009'), ('Test\mark');

    SELECT SUBSTRING(p, 1, ISNULL(NULLIF(PATINDEX('%[0-9]%',p),0),8000)-1)

    FROM

    (

    ...

    "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

    May 4, 2016 at 1:03 pm

    #1876709

  • RE: How to generate new Int ID for multiple columns

    Is there a reason to use Row_number instead of dense_rank on the first column. It appears dense_rank did the same thing.

    ROW_NUMBER does not take ties into consideration, RANK and DENSE_RANK...

    "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

    May 4, 2016 at 12:56 pm

    #1876706

  • RE: Multiple Months Data

    Note that, unless you ABSOLUTELY need it for some reason, you should get rid of that final ORDER BY statement. It will only slow down your query and does not...

    "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

    May 4, 2016 at 12:46 pm

    #1876703

  • RE: Why STUFF

    Lynn Pettis (5/4/2016)

    Do this so many times I didn't catch that the STUFF function was missing. Got it right without it there.

    Me too.

    "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

    May 4, 2016 at 10:12 am

    #1876662

  • RE: Hide or Disable parameters in SSRS 2005

    Yusuf Bhiwandiwala (9/18/2009)

    tmacs33,

    The question is : How do we grey out a report parameter (date type or not)?

    If greying out can be achieved, the SSRS world would be a happier...

    "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

    May 4, 2016 at 9:18 am

    #1876633

  • RE: Potential presentation idea: Knowing your limits: are you in over your head?

    Eirikur Eiriksson (5/3/2016)

    Alan.B (5/3/2016)

    Eirikur Eiriksson (5/3/2016)

    Alan.B (5/3/2016)

    I think this is a common problem in the data world for sure.

    It all comes down to self-awareness and communication. Knowing your strengths,...

    "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

    May 3, 2016 at 2:14 pm

    #1876430

  • RE: Potential presentation idea: Knowing your limits: are you in over your head?

    Eirikur Eiriksson (5/3/2016)

    Alan.B (5/3/2016)

    I think this is a common problem in the data world for sure.

    It all comes down to self-awareness and communication. Knowing your strengths, weaknesses and limitations,...

    "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

    May 3, 2016 at 1:27 pm

    #1876416

  • RE: Index

    You'll find some scripts that you can alter as needed here as well.

    "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

    May 3, 2016 at 12:37 pm

    #1876391

Viewing 15 posts - 751 through 765 (of 2,458 total)