Hello new world!

  • Robert Chipperfield (Redgate)

    Ten Centuries

    Points: 1380

    Just checking out the new forums...

  • Robert Chipperfield (Redgate)

    Ten Centuries

    Points: 1380

    And replies.

  • HappyGeek

    SSCoach

    Points: 18670

    Struggling to logon using mobile device, getting asked to re-register?

    ...

  • Robert Chipperfield (Redgate)

    Ten Centuries

    Points: 1380

    @happygeek any chance of a screenshot of the error, and which device you're using? I assume you logged on OK on desktop with the same credentials?

    (Long shot: it's not autocorrect / auto-caps or something like that is it?)

  • HappyGeek

    SSCoach

    Points: 18670

    Can now logon with mobile device after two hours of trying str ifii trytto  redit text itvjust addsarandom lettersl or duplcatesd!! VeryVodd thisthi this is

    ...

  • HappyGeek

    SSCoach

    Points: 18670

    Can now logon with mobile device after two hours of trying str ifii trytto  redit text itvjust addsarandom lettersl or duplcatesd!! VeryVodd thisthi this is

    ...

  • HappyGeek

    SSCoach

    Points: 18670

    Should I stop using mobile device?

    ...

  • Robert Chipperfield (Redgate)

    Ten Centuries

    Points: 1380

    We should definitely make sure it works on mobile :-). If you could give us a few more details, that'd help us track down the problem though:

    • What device and OS version are you using when you have the problem?
    • Does it work OK for your used on a different device, like a desktop PC?
    • Do you see random characters being entered as you're typing, or do they just appear later?

    Thanks,

    Rob

  • Jeff Moden

    SSC Guru

    Points: 994921

    Just testing for Copy'n'Paste from SSMS to the forum..

    /****** Object:  UserDefinedFunction [dbo].[fnTally]    Script Date: 03/30/2019 20:45:59 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    ALTER FUNCTION [dbo].[fnTally]
    /**********************************************************************************************************************
    Purpose:
    Return a column of BIGINTs from @ZeroOrOne up to and including @MaxN with a max value of 10 Quadrillion.

    Usage:
    --===== Syntax example
    SELECT t.N
    FROM dbo.fnTally(@ZeroOrOne,@MaxN) t
    ;

    Notes:
    1. This code works for SQL Server 2005 and up.
    2. Based on Itzik Ben-Gan's cascading CTE (cCTE) method for creating a "readless" Tally Table source of BIGINTs.
    Refer to the following URL for how it works. http://sqlmag.com/sql-server/virtual-auxiliary-table-numbers
    3. To start a sequence at 0, @ZeroOrOne must be 0 or NULL. Any other value that's convertable to the BIT data-type
    will cause the sequence to start at 1.
    4. If @ZeroOrOne = 1 and @MaxN = 0, no rows will be returned.
    5. If @MaxN is negative or NULL, a "TOP" error will be returned.
    6. @MaxN must be a positive number from >= the value of @ZeroOrOne up to and including 10 Quadrillion. If a larger
    number is used, the function will silently truncate after 10 Quadrillion. If you actually need a sequence with
    that many values, you should consider using a different tool. 😉
    7. There will be a substantial reduction in performance if "N" is sorted in descending order. If a descending
    sort is required, use code similar to the following. Performance will decrease by about 27% but it's still
    very fast especially compared with just doing a simple descending sort on "N", which is about 20 times slower.
    If @ZeroOrOne is a 0, in this case, remove the "+1" from the code.

    DECLARE @MaxN BIGINT;
    SELECT @MaxN = 1000;
    SELECT DescendingN = @MaxN-N+1
    FROM dbo.fnTally(1,@MaxN);

    8. There is no performance penalty for sorting "N" in ascending order because the output is explicity sorted by
    ROW_NUMBER() OVER (ORDER BY (SELECT NULL))

    Revision History:
    Rev 00 - Unknown - Jeff Moden
    - Initial creation with error handling for @MaxN.
    Rev 01 - 09 Feb 2013 - Jeff Moden
    - Modified to start at 0 or 1.
    Rev 02 - 16 May 2013 - Jeff Moden
    - Removed error handling for @MaxN because of exceptional cases.
    Rev 03 - 07 Sep 2013 - Jeff Moden
    - Change the max for @MaxN from 10 Billion to 10 Quadrillion to support an experiment.
    This will also make it much more difficult for someone to actually get silent truncation in the future.
    **********************************************************************************************************************/
    (@ZeroOrOne BIT, @MaxN BIGINT)
    RETURNS TABLE WITH SCHEMABINDING AS
    RETURN WITH
    E1(N) AS (SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL
    SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1) --up to 10 rows
    , E4(N) AS (SELECT 1 FROM E1 a, E1 b, E1 c, E1 d) --up to 10 Thousand rows
    ,E16(N) AS (SELECT 1 FROM E4 a, E4 b, E4 c, E4 d) --up to 10 Quadrillion rows
    SELECT N = 0 WHERE ISNULL(@ZeroOrOne,0)= 0 --Conditionally start at 0.
    UNION ALL
    SELECT TOP(@MaxN) N = ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) FROM E16
    ;

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • Jeff Moden

    SSC Guru

    Points: 994921

    Jeff Moden wrote:

    Just testing for Copy’n’Paste from SSMS to the forum..

    /****** Object:  UserDefinedFunction [dbo].[fnTally]    Script Date: 03/30/2019 20:45:59 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    ALTER FUNCTION [dbo].[fnTally]
    /**********************************************************************************************************************
    Purpose:
    Return a column of BIGINTs from @ZeroOrOne up to and including @MaxN with a max value of 10 Quadrillion.
    Usage:
    --===== Syntax example
    SELECT t.N
    FROM dbo.fnTally(@ZeroOrOne,@MaxN) t
    ;
    Notes:
    1. This code works for SQL Server 2005 and up.
    2. Based on Itzik Ben-Gan's cascading CTE (cCTE) method for creating a "readless" Tally Table source of BIGINTs.
    Refer to the following URL for how it works. http://sqlmag.com/sql-server/virtual-auxiliary-table-numbers
    3. To start a sequence at 0, @ZeroOrOne must be 0 or NULL. Any other value that's convertable to the BIT data-type
    will cause the sequence to start at 1.
    4. If @ZeroOrOne = 1 and @MaxN = 0, no rows will be returned.
    5. If @MaxN is negative or NULL, a "TOP" error will be returned.
    6. @MaxN must be a positive number from >= the value of @ZeroOrOne up to and including 10 Quadrillion. If a larger
    number is used, the function will silently truncate after 10 Quadrillion. If you actually need a sequence with
    that many values, you should consider using a different tool.
    7. There will be a substantial reduction in performance if "N" is sorted in descending order. If a descending
    sort is required, use code similar to the following. Performance will decrease by about 27% but it's still
    very fast especially compared with just doing a simple descending sort on "N", which is about 20 times slower.
    If @ZeroOrOne is a 0, in this case, remove the "+1" from the code.
    DECLARE @MaxN BIGINT;
    SELECT @MaxN = 1000;
    SELECT DescendingN = @MaxN-N+1
    FROM dbo.fnTally(1,@MaxN);
    8. There is no performance penalty for sorting "N" in ascending order because the output is explicity sorted by
    ROW_NUMBER() OVER (ORDER BY (SELECT NULL))
    Revision History:
    Rev 00 - Unknown - Jeff Moden
    - Initial creation with error handling for @MaxN.
    Rev 01 - 09 Feb 2013 - Jeff Moden
    - Modified to start at 0 or 1.
    Rev 02 - 16 May 2013 - Jeff Moden
    - Removed error handling for @MaxN because of exceptional cases.
    Rev 03 - 07 Sep 2013 - Jeff Moden
    - Change the max for @MaxN from 10 Billion to 10 Quadrillion to support an experiment.
    This will also make it much more difficult for someone to actually get silent truncation in the future.
    **********************************************************************************************************************/
    (@ZeroOrOne BIT, @MaxN BIGINT)
    RETURNS TABLE WITH SCHEMABINDING AS
    RETURN WITH
    E1(N) AS (SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL
    SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1) --up to 10 rows
    , E4(N) AS (SELECT 1 FROM E1 a, E1 b, E1 c, E1 d) --up to 10 Thousand rows
    ,E16(N) AS (SELECT 1 FROM E4 a, E4 b, E4 c, E4 d) --up to 10 Quadrillion rows
    SELECT N = 0 WHERE ISNULL(@ZeroOrOne,0)= 0 --Conditionally start at 0.
    UNION ALL
    SELECT TOP(@MaxN) N = ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) FROM E16
    ;

    Just testing quoted responses to coded posts.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • Jeff Moden

    SSC Guru

    Points: 994921

    Jeff Moden wrote:

    2167901 wrote:

    Just testing for Copy’n’Paste from SSMS to the forum..

    /****** Object:  UserDefinedFunction [dbo].[fnTally]    Script Date: 03/30/2019 20:45:59 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    ALTER FUNCTION [dbo].[fnTally]
    /**********************************************************************************************************************
    Purpose:
    Return a column of BIGINTs from @ZeroOrOne up to and including @MaxN with a max value of 10 Quadrillion.
    Usage:
    --===== Syntax example
    SELECT t.N
    FROM dbo.fnTally(@ZeroOrOne,@MaxN) t
    ;
    Notes:
    1. This code works for SQL Server 2005 and up.
    2. Based on Itzik Ben-Gan's cascading CTE (cCTE) method for creating a "readless" Tally Table source of BIGINTs.
    Refer to the following URL for how it works. http://sqlmag.com/sql-server/virtual-auxiliary-table-numbers
    3. To start a sequence at 0, @ZeroOrOne must be 0 or NULL. Any other value that's convertable to the BIT data-type
    will cause the sequence to start at 1.
    4. If @ZeroOrOne = 1 and @MaxN = 0, no rows will be returned.
    5. If @MaxN is negative or NULL, a "TOP" error will be returned.
    6. @MaxN must be a positive number from >= the value of @ZeroOrOne up to and including 10 Quadrillion. If a larger
    number is used, the function will silently truncate after 10 Quadrillion. If you actually need a sequence with
    that many values, you should consider using a different tool.
    7. There will be a substantial reduction in performance if "N" is sorted in descending order. If a descending
    sort is required, use code similar to the following. Performance will decrease by about 27% but it's still
    very fast especially compared with just doing a simple descending sort on "N", which is about 20 times slower.
    If @ZeroOrOne is a 0, in this case, remove the "+1" from the code.
    DECLARE @MaxN BIGINT;
    SELECT @MaxN = 1000;
    SELECT DescendingN = @MaxN-N+1
    FROM dbo.fnTally(1,@MaxN);
    8. There is no performance penalty for sorting "N" in ascending order because the output is explicity sorted by
    ROW_NUMBER() OVER (ORDER BY (SELECT NULL))
    Revision History:
    Rev 00 - Unknown - Jeff Moden
    - Initial creation with error handling for @MaxN.
    Rev 01 - 09 Feb 2013 - Jeff Moden
    - Modified to start at 0 or 1.
    Rev 02 - 16 May 2013 - Jeff Moden
    - Removed error handling for @MaxN because of exceptional cases.
    Rev 03 - 07 Sep 2013 - Jeff Moden
    - Change the max for @MaxN from 10 Billion to 10 Quadrillion to support an experiment.
    This will also make it much more difficult for someone to actually get silent truncation in the future.
    **********************************************************************************************************************/
    (@ZeroOrOne BIT, @MaxN BIGINT)
    RETURNS TABLE WITH SCHEMABINDING AS
    RETURN WITH
    E1(N) AS (SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL
    SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1) --up to 10 rows
    , E4(N) AS (SELECT 1 FROM E1 a, E1 b, E1 c, E1 d) --up to 10 Thousand rows
    ,E16(N) AS (SELECT 1 FROM E4 a, E4 b, E4 c, E4 d) --up to 10 Quadrillion rows
    SELECT N = 0 WHERE ISNULL(@ZeroOrOne,0)= 0 --Conditionally start at 0.
    UNION ALL
    SELECT TOP(@MaxN) N = ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) FROM E16
    ;

    Just testing quoted responses to coded posts.

    Nested quote + addition of an image..  rat's... can't copy image file (gif) from HD and paste.  Will try something else... not sure how to upload images at this point.  Tried click'n'drag.  No joy.  The insert/edit image works as an upload from HD.Test Image from HD

    Ok... that worked.

    • This reply was modified 7 months, 3 weeks ago by  Jeff Moden.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • Jeff Moden

    SSC Guru

    Points: 994921

    Dammit!  My animated avatar is gone and so are all of my subscriptions!

     

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • Jeff Moden

    SSC Guru

    Points: 994921

    Article counts are totally out of whack.  I don't have 75 articles and for other people, since when to blog entries count as articles?

    A lot of old clickable links don't work any more.  For example, the links in my signature line no longer work.  I realize that migrations to new systems are always going to be perfect but damn!  Well, at least code keeps it's indentation now.  That's the most important thing for me.

     

    • This reply was modified 7 months, 3 weeks ago by  Jeff Moden.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • Jeff Moden

    SSC Guru

    Points: 994921

    It would also appear that you cannot go back to a previously submitted post and edit it.

    Also, for article, you can no longer get a view count to see how an article is doing for views, which is important to an author to try to figure out what one may be doing right or wrong for future article submissions.

    And what the heck order are old articles listed in now?

     

    Getting back to editing previous replies, I was able to edit this reply... is there a time limit or something on which of one's own posts can be edited???

     

    Also, turns out that only one of the links in my signature are broken but that's bad enough.  Checking to see if the article still exists. 🙁

     

     

     

     

    • This reply was modified 7 months, 3 weeks ago by  Jeff Moden.
    • This reply was modified 7 months, 3 weeks ago by  Jeff Moden.
    • This reply was modified 7 months, 3 weeks ago by  Jeff Moden.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • Jeff Moden

    SSC Guru

    Points: 994921

    Yeah... guess there's a time limit for edits on posts... can't edit the previous post any more.

     

    Briefcase is making sucking sounds.  Had everything categorized by tags and all the tags are gone as are a lot of the briefcase items.

     

    Tried to edit one link in my signature section and it messed up the entire signature section.

     

    "Latest" forum posts are also not in order by latest descending date.

    • This reply was modified 7 months, 3 weeks ago by  Jeff Moden.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

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

You must be logged in to reply to this topic. Login to reply