Forum Replies Created

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

  • RE: sql 2005 install on Windows 2008

    It's interesting, a Google search does not return any useful info. Apparently Microsoft has pulled anything abut 2005. Another reason to upgrade I suppose.

    All I can say is, give 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

    May 5, 2016 at 6:13 pm

    #1877001

  • RE: How do you refresh the query used for a report?

    I have had this exact same problem before. If you're developing the report in SSDT then restarting SSDT then trying again sometimes resolves the problem. Sometimes the only thing you...

    "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 5:44 pm

    #1876999

  • RE: Left Outer Join in SSAS Tabular

    This may help: https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/%5B/url%5D

    "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 1:37 pm

    #1876969

  • RE: Trouble with using a list with new columns

    No problem. Glad to help.

    "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:08 pm

    #1876940

  • 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

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