Forum Replies Created

Viewing 15 posts - 121 through 135 (of 1,079 total)

  • RE: How can I have multiple cubes based on the same structure where the underlying data that is sub divided by company?

    Use one cube and apply dimension permissions to each company for their data only. 
    https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/grant-custom-access-to-dimension-data-analysis-services

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: SSAS Multi-dimensional OR R?

    Yep - apples and oranges. 

    Multi-Dimensional and Tabular will both give you analytical cubes, but both have weaknesses and strengths, choose your type carefully. 
    R - best to read...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: the time to miss here to go nowe

    reported as spam

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: TEMPDB log growing HUGE

    Next time, run the code to see what is holding up the log space reuse.
    Maybe this points you in the direction of the issue.

    select name,...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Index Creation

    thanks for the question.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Issue with powershell command for service down

    can you telnet to port 25 on your mail server from this host?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Follow up questions

    Duplicate post - read replies here; https://www.sqlservercentral.com/Forums/1868675/Some-questions-related-to-the-Interview

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Some questions related to the Interview

    Well, let's be honest. In most cases, people intend to move jobs, for better money and circumstances. 
    If the company you apply to is one of interest, even better. 

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Need database expert

    drew.allen - Wednesday, March 29, 2017 2:54 PM

    chainzown - Monday, March 27, 2017 11:30 AM

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: SQL Server DBA Certification

    Depends on your goals, and interests, and who you hope to get employed by.

    There are several different certification paths you can follow, all detail on Microsoft certification pages....

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: sys.dm_exec_query_stats

    Seems MS documentation needs to be updated. 
    Apologies if anyone lost points! 🙂

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Log file growth

    Admingod - Monday, March 27, 2017 2:43 PM

    I see that particular database log_reuse_wait_desc value is XTP_CHECKPOINT. Do you think this might be...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Log file growth

    Are you using replication, mirroring or Availability Groups, then you might also want to run select name, log_reuse_wait_desc from sys.databases. 
    There might be some additional reasons why your logs grow....

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: DB MAXDOP Settings

    Jeff Moden - Sunday, March 26, 2017 10:48 AM

    Yeah... I was wrong.  They really do mean "Primary and Secondary DATABASES".  Here's a...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: sys.dm_exec_query_stats

    DesNorton - Sunday, March 26, 2017 10:22 PM

    Well, the documentation states that these new columns were added from SQL 2016.  However, they...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Viewing 15 posts - 121 through 135 (of 1,079 total)