Forum Replies Created

Viewing 15 posts - 61 through 75 (of 937 total)

  • RE: Free Encryption

    None of the XPs here were distributed as 64 bit. SQL 2000 doesn't have built-in encryption.

    Thanks

    Mike C

    October 7, 2010 at 7:07 pm

    #1233999

  • RE: Free Encryption

    Hi David,

    This was actually created for SQL 2000--before we had the max data types. There could be a chance the XP API (extended proc API) won't handle max data...

    October 7, 2010 at 2:36 pm

    #1233941

  • RE: NULL Equals NULL?

    DataDog (1/13/2010)

    I haven't seen mention of this important NULL topic anywhere:

    select 1

    where 1 = 1 or datediff(hour, null, getdate()) > 4

    TSQL seems to work like this:

    where True OR NULL =...

    August 9, 2010 at 3:34 pm

    #1204434

  • RE: The Joy of Numbers

    _ms65g_ (5/28/2010)

    Remove duplicate side-by-side characters from a string

    New approach using numbers table

    CREATE FUNCTION dbo.fnRemoveDupesI (@String VARCHAR(8000)) 

    RETURNS VARCHAR(8000) 

    AS

    BEGIN

        DECLARE @result VARCHAR(8000) = '';

       

       ;WITH DataOrder

       AS

       (

          SELECT ID, Data

                 ,ROW_NUMBER() OVER (PARTITION BY Data ORDER BY ID) AS RowNum

            FROM (SELECT SUBSTRING(@String, nbr, 1), nbr 

                    FROM Nums 

                   WHERE nbr <= LEN(@String)

                 ) D(data, ID)

       )

      

      SELECT @result = @result + Data

        FROM (SELECT ID, Data

                     ,DENSE_RANK() OVER (ORDER BY ID - RowNum) As [Rank]

                FROM DataOrder

             )D

       GROUP BY Data, [Rank]

       ORDER BY MIN(ID)

       RETURN @result

    END;

    Be careful with the multirow concatenation thing you got going on there. You might be better off using...

    August 9, 2010 at 3:30 pm

    #1204433

  • RE: SQL 2000 DBA Toolkit Part 1

    homebrew01 (4/5/2010)

    Will BlowFish or TwoFish work with image data ?? I downloaded the latest SQL toolkit and Tried running TwoFish after modifying it to handle image data converted to...

    August 9, 2010 at 3:25 pm

    #1204429

  • RE: SQL 2000 DBA Toolkit Part 1

    Mark Salvador (2/3/2010)

    I am also having the same problem. I used the web site to encrypt/decryt credit card details but when i checked it with other machine, for example in...

    August 9, 2010 at 3:14 pm

    #1204425

  • RE: Some minor problems with grammar.

    mceitlin (5/31/2010)

    Hi Mike, great code!

    It works fine for me in general but I´m having problems when a word begins with "and" or with "or" like "orthopedics".

    I´ve change, in...

    August 9, 2010 at 3:11 pm

    #1204421

  • RE: Free Encryption

    IIRC you were looking specifically for the blowfish or twofish encryption, correct? If so I have .net/clr versions that would be better to run on 2005/2008 (32 or 64...

    August 9, 2010 at 10:27 am

    #1204279

  • RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

    Jeff Moden (7/23/2010)

    Mike C (7/22/2010)

    Jeff Moden (7/22/2010)

    Mike C (7/22/2010)

    Jeff Moden (7/22/2010)

    Mike C (7/22/2010)

    Obviously the so-called "buggy" execution plan requires the developer to be more careful, but gracefully handling invalid function...

    July 23, 2010 at 6:44 am

    #1197465

  • RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

    Tom.Thomson (7/22/2010)

    Mike C (7/22/2010)

    Sorry to hear you're leaving T-SQL :crying: Unfortunately you probably won't find much love in any dialect of SQL. The problem (?) is that the...

    July 22, 2010 at 9:16 pm

    #1197312

  • RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

    Jeff Moden (7/22/2010)

    Mike C (7/22/2010)

    Jeff Moden (7/22/2010)

    Mike C (7/22/2010)

    Obviously the so-called "buggy" execution plan requires the developer to be more careful, but gracefully handling invalid function parameter and divide-by-zero errors...

    July 22, 2010 at 4:58 pm

    #1197262

  • RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

    Jeff Moden (7/22/2010)

    Mike C (7/22/2010)

    Obviously the so-called "buggy" execution plan requires the developer to be more careful, but gracefully handling invalid function parameter and divide-by-zero errors are not new problems...

    July 22, 2010 at 4:17 pm

    #1197247

  • RE: SQL CLR Data Types and Performance

    Cool, glad it worked well for you. Another optimization you might try is using the t-sql "returns null on null input" option, which allows sql server to short-circuit null...

    July 22, 2010 at 3:22 pm

    #1197220

  • RE: SQL CLR Data Types and Performance

    Oh yeah, almost forgot to mention, your performance difference between the version with global constants and the one with no global constants is probably due to implicit conversions from Decimal...

    July 22, 2010 at 2:19 pm

    #1197180

  • RE: SQL CLR Data Types and Performance

    You should be able to access the SqlDecimal values directly using the .Value property of the SqlDecimal variables. The reason people recommend using SqlDecimal instead of "native" .NET Decimal...

    July 22, 2010 at 1:58 pm

    #1197167

Viewing 15 posts - 61 through 75 (of 937 total)