Forum Replies Created

Viewing 15 posts - 31 through 45 (of 360 total)

  • RE: linked server issue

    MAS90 is a database engine on its own. Yes I have installed the OLEDB driver for it. True there are no issues related to provider/ driver because whenever i test...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    June 9, 2013 at 7:55 am

    #1622271

  • RE: linked server issue

    Experts I need your valuable advice. I am confused if I am missing something or is it a MAS90 issue.

    Thanks a ton in advance

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    June 7, 2013 at 12:02 pm

    #1622146

  • RE: Storage Modes in SSAS 2008R2 (MOLAP, ROLAP, HOLAP and InMemory)

    Default Storage mode is MOLAP.In this, data gets pulled from Relational DB and pushed to Analysis services after aggregations are created.It fetches only leaf level attributes. Super fast but consumes...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    May 30, 2013 at 10:09 am

    #1619777

  • RE: What do u mean by DB Refresh

    In somecases the developers request only the structural differences and least bothered about data (database refresh). In that case you need to compare the current copy of production database vs...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    May 30, 2013 at 9:50 am

    #1619768

  • RE: need help with trigger

    I think I was able to figure this out..

    http://mssqlnuggets.wordpress.com/

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    May 14, 2013 at 9:39 pm

    #1615265

  • RE: need help with trigger

    Sean Lange (5/14/2013)

    Seems a bit strange that you can put a trigger on a table but not a unique constraint. The constraint will perform better and is effectively doing the...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    May 14, 2013 at 11:20 am

    #1615114

  • RE: Time dimension...4 hour partition attributes...how to?

    Experts I need your inputs.

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    May 9, 2013 at 2:10 pm

    #1613967

  • RE: SQL Server Transaction Log Management by Tony Davis and Gail Shaw

    Cool...Do you think there will be a free ecopy for this book. Thanks

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    April 22, 2013 at 11:59 am

    #1608786

  • RE: Help with SQL code

    Thanks

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    April 17, 2013 at 1:49 pm

    #1607426

  • RE: Help with SQL code

    Lynn Pettis (4/16/2013)

    Sapen (4/16/2013)

    I am trying to convert into the below format

    week number,

    average of sunday,

    average of monday,

    average of tuesday,

    average of wednesday,

    average of thursday,

    average of friday,

    average of saturday,

    The averages are nothing...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    April 16, 2013 at 2:24 pm

    #1607045

  • RE: Help with SQL code

    I am trying to convert into the below format

    week number,

    average of sunday,

    average of monday,

    average of tuesday,

    average of wednesday,

    average of thursday,

    average of friday,

    average of saturday,

    The averages are nothing but average of...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    April 16, 2013 at 12:24 pm

    #1606980

  • RE: TSQL to get users and permissions

    Yes. Thanks.

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    April 4, 2013 at 12:13 pm

    #1603687

  • RE: TSQL to get users and permissions

    Lowell (4/4/2013)

    something like this seems to work for me, see how i modified it to sue sp_msForEachDb, and to INSERT INTO a #temp table, and read the results at

    the...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    April 4, 2013 at 11:51 am

    #1603672

  • RE: How to get user roles

    alexkedrov (7/8/2010)

    f.racionero (10/17/2007)

    Normally I use this script to get all user information for a db

    select

    [Login Type]=

    case sp.type

    when 'u' then 'WIN'

    when 's' then 'SQL'

    when 'g' then 'GRP'

    end,

    convert(char(45),sp.name) as srvLogin,

    convert(char(45),sp2.name)...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    April 4, 2013 at 10:23 am

    #1603635

  • RE: Need suggestions on replication

    AccDba (2/6/2013)

    I found the stored proc that needs to be modified. I am not sure where the changes have to be made and I need some help from experts on...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    February 6, 2013 at 2:28 pm

    #1585141

Viewing 15 posts - 31 through 45 (of 360 total)