Forum Replies Created

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

  • Reply To: MDS Add-in for Excel Office 365 - Error

    Hi Anthony,

     

    Thanks for your response.

     

    I am exactly trying the same now -- x86 plugin. It's not reflecting in Excel yet, reckon needs a system reboot.

     

     

    January 31, 2020 at 11:42 am

    #3721959

  • Reply To: MDS Add-in for Excel Office 365 - Error

    Hi Frederico,

     

    Just checked and it is --  Microsoft Excel for Office 365 MSO 32-bit

    Does that mean, incompatibility between 32-bit MS Office and 64-bit MDS is the actual cause of this...

    • This reply was modified 4 years, 9 months ago by  ranitb.

    January 31, 2020 at 9:28 am

    #3721928

  • RE: Clustered PK perf -

    June 21, 2018 at 12:55 am

    #1994772

  • RE: get starting to last specific string valuesin sql server

    Phil Parkin - Wednesday, June 20, 2018 6:30 AM

    REVERSE() is an expensive operation and your code is way more complex than...

    June 20, 2018 at 6:48 am

    #1994622

  • RE: get starting to last specific string valuesin sql server

    Something like this ?
    ;with t(txt) as (
        select 'ab_re_uk_u_20101001' union all
        select 'ax_by_us_19991001' union all
        select 'abc_20181002'
    )
    select    txt,
            REVERSE(txt) tmp1,
            CHARINDEX('_',REVERSE(txt)) tmp2,
            LEN(txt) tmp3,

    June 20, 2018 at 6:15 am

    #1994607

  • RE: Clustered PK perf -

    All - Thank you so much for those wonderful suggestions. Great learning!

    I will analyze all of them and come back with further doubts, if any.

    -RB.

    June 20, 2018 at 6:04 am

    #1994603

  • RE: Top 2 records with range

    Does this help ?

    select top 2 *
    from (
        select max(u.iduser) iduser, max(u.score) score, s.rangename name
        from    #Users u
                left join #scorerange s on (u.score...

    June 20, 2018 at 5:21 am

    #1994591

  • RE: SELECT or GROUP BY LIKE

    Something like this ?

    ;with your_table_name(txt) as
    (
    select 'Corning Precision Lens Incorporated' union all
    select 'Corning Precision Materials Co., Ltd.' union all
    select...

    June 20, 2018 at 5:05 am

    #1994589

  • RE: Clustered PK perf -

    You really should strongly consider defining the clus index before loading the table if at all possible
    > do u mean I should create the index immediately after creating the table structure...

    June 19, 2018 at 12:58 pm

    #1994524

  • RE: SQL Server | Architecture design -

    GilaMonster - Tuesday, April 18, 2017 6:00 AM

    GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON schema::Sales TO <database role>

    That's the basic principal of...

    April 18, 2017 at 6:23 am

    #1938486

  • RE: SQL Server | Architecture design -

    whenriksen - Tuesday, April 11, 2017 2:51 PM

    I actually prefer using schemas to segregate objects because I find it easier to manage...

    April 18, 2017 at 4:54 am

    #1938473

  • RE: SQL Server | Architecture design -

    chuck.forbes - Monday, April 3, 2017 9:25 AM

    I feel that if I don't mention something here, that it might come across...

    April 4, 2017 at 6:30 am

    #1936506

  • RE: SQL Server | Architecture design -

    chuck.forbes - Friday, March 31, 2017 2:14 PM

    Having come from an Oracle shop, I liken databases in SQL Server, to Schemas in...

    March 31, 2017 at 5:07 pm

    #1936094

  • RE: SQL Server | Architecture design -

    Thanks Chris.

    Reg. RBAR - Same was also suggested by experts while working on Oracle dB. It also works best with set-based techniques.

    Another thing I miss from...

    March 31, 2017 at 5:04 pm

    #1936093

  • RE: SQL Server | Architecture design -

    Thanks a lot for your response, Grant. You gave lot of pointers to play further with SQL Server. 
    I will try them out and come with further questions on...

    March 31, 2017 at 1:03 pm

    #1936064

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