Forum Replies Created

Viewing 15 posts - 7,966 through 7,980 (of 39,903 total)

  • RE: SQL 2014 design with SSAS

    I'm not sure. I believe that the underlying WSFC can work for an AG.

    As far as using the database in the AG for SSAS, I assume using the virtual instance/db...

  • RE: DevOps and Security

    I understand concerns, but remember, Jeff, no code is ever unchecked. Part of the process is ensuring that code runs through a set of checks, whatever those are. Those can...

  • RE: SQL 2014 design with SSAS

    Don't confuse clustering (WSFC or FCI, depending on Windows version) with Availability Groups. They're separate.

    I'm not an SSAS expert, but there isn't a database per se, correct? Isn't there a...

  • RE: SQL 2014 design with SSAS

    I think you can do this. It appears the WSFC will work with SSAS, which I think means NLB isn't needed. The resource should appear as a clustered item with...

  • RE: Querying XML

    I think I was confused as to what you were looking at. I see now since there aren't two CustomerName items in each element that there's a good chance that...

  • RE: Statistics and Index Rebuilds

    TomThomson (6/23/2016)


    Not a very good question, because the answer (at least for SQL Server 2012, SQL server 2014, and SQL Server 2016) depends on whether the index is partitioned or...

  • RE: Grouping mapping table records

    A couple things. First idea is that there isn't any order here. So there isn't a "first" concept. I'm hoping you realize that. With that in mind, other than order,...

  • RE: SQL 2014 design with SSAS

    First, are you trying to create HA for SSAS? Meaning you want SSAS to live on the cluster and fail from one node to the other? I did see this,...

  • RE: system queries showing as ran by user in sql sentry tool

    Is Performance Advisor running under a developer account?

  • RE: Adding myself as Admin via DAC - service restart necessary?

    You don't need to set SQL Server in single user mode to use the DAC. This is a single threaded connection available for adminstrators that doesn't get resources blocked by...

  • RE: Performanence very slow after migrated database from 2000 to 2008 sql

    You should also be sure your VM has resources. A database server VM is not like some other file server, print server, etc. VM. This needs more resources, more minimums,...

  • RE: Why Use R Services?

    Perhaps. It seems that there are people that use R to do analysis in business over and over, on datasets that are refreshed as new data comes in. SQL Server...

  • RE: Are the posted questions getting worse?

    Luis Cazares (6/24/2016)


    I'm sorry, is there any country that can give me good news? It seems that Mexico, US and UK are full of negative news and I'm getting grumpy...

  • RE: Have You Designed a Database from Scratch?

    Stefan LG (6/24/2016)


    Yes, I have built 3 new databases in the past 2 years that are running in production environments with 3rd party applications and Reporting Services attached.

    With each one...

  • RE: JSON Paths

    Igor Micev (6/23/2016)


    The answer is $.address, not $,address.

    Argg, old eyes. I couldn't see that.

    Updated. I'll award back points.

Viewing 15 posts - 7,966 through 7,980 (of 39,903 total)