Forum Replies Created

Viewing 15 posts - 256 through 270 (of 966 total)

  • RE: business intelligence

    What type of project are you trying to create? Can you post a screenshot of the project types you have available in Visual Studio?

    Joie Andrew
    "Since 1982"

  • RE: An RDP Session issue

    Try something like the following.

    Joie Andrew
    "Since 1982"

  • RE: An RDP Session issue

    Why not configure your RDP session and then save it to a file? Then you can use mstsc pointing to the configuration option and still specify /admin.

    Joie Andrew
    "Since 1982"

  • RE: business intelligence

    I think it also depends on which version of SSDT you installed. If you installed SSDT for VS 2013 and you already had VS 2013 installed I think it just...

    Joie Andrew
    "Since 1982"

  • RE: Run DTEXEC from Powershell - convert from batch file

    I have seen PowerShell get confused when calling external commands with lots of parameters. In that case you might have to call start-process with dtexec and specify each of the...

    Joie Andrew
    "Since 1982"

  • RE: SQL 2016 Syntax

    I don't think any of the BI stuff for SQL Server 2016 has been released yet. When I looked at the BOL stuff for CTP2 it was pretty sparse or...

    Joie Andrew
    "Since 1982"

  • RE: Setting Up Some Basic Maintenance Tasks

    Are any of your databases in the FULL or BULK LOGGED recovery model? Because if they are you need to ensure that transaction log backups are in your backup strategy....

    Joie Andrew
    "Since 1982"

  • RE: SSRS and one-way trust

    What is shown in the SSRS logs? Just to verify from domain B you can resolve the SSRS server URL on domain A?

    Joie Andrew
    "Since 1982"

  • RE: Report Definition is NULL

    Is the report server not working? Wouldn't it be easier to access the Report Manager URL and download the report definitions? You might be able to script it out using...

    Joie Andrew
    "Since 1982"

  • RE: Need help in query

    How big are the Vendors and Payables tables? It seems like most of the query is consumed with this join:

    left join Payables p with (nolock) on p.SalespersonID = sp.id or...

    Joie Andrew
    "Since 1982"

  • RE: about sql error

    This is really generic with no explanation. What are you doing to get this error?

    Joie Andrew
    "Since 1982"

  • RE: SQL 2014 is running slower than SQL 2008

    Disk layouts.

    Execution plans.

    Need these items.

    Also, is the new server producing these numbers consistently or is this result from the first time the query is run? It could be related...

    Joie Andrew
    "Since 1982"

  • RE: SQL 2014 is running slower than SQL 2008

    I agree there are some things left out, particularly the storage specifications of both.

    Joie Andrew
    "Since 1982"

  • RE: HighAvailability Groups service restart

    Availability Groups are independent instances. The primary will see the secondary go offlline and show errors until synchronization starts up again, but other than that it should be fine. You...

    Joie Andrew
    "Since 1982"

  • RE: command

    I am not sure what the minimum version is, but if it supports it sconfig is your best friend on Server Core.

    Configure a Server Core Server with Sconfig.cmd

    Joie Andrew
    "Since 1982"

Viewing 15 posts - 256 through 270 (of 966 total)