Forum Replies Created

Viewing 15 posts - 181 through 195 (of 1,079 total)

  • RE: SQL Server Trace Flags - Complete list

    awesome, added to favorites

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: connecting to a remote instance

    here you go: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-configure-firewall-settings

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Backing up async secondary in HIgh Availabilty

    You can, but use the "Copy Only" option.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: connecting to a remote instance

    Did you add the firewall rule to allow your IP?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Are the posted questions getting worse?

    GilaMonster - Wednesday, February 22, 2017 8:27 AM

    Nothing like listening to the developers sitting 2 rows behind me spend half an hour...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: From Cluster to Virtual Machine using VMware

    P2V should do the trick with vCenter Converter. 

    Your issue might be that you are taking an image of a cluster, and deploying it as standalone.
    You could...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Is there anything wrong with my DB design ?

    Just some questions:
    Is there any reference between RequestOrder.DeptCode and RequestOrder.DeptId_FK to your Department table?
    Why would you include a PhoneExt in a RequestOrder table, I would imagine this would...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Restoring AG databases from PRODUCTION to QA environment

    Some searching would have led you to some good material, but here is a good start for you. 
    Just be aware, your exact requirement is not to refresh your primary...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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 vs SQL Server v.Next

    Br. Kenneth Igiri - Wednesday, February 22, 2017 6:10 AM

    Are there any benchmarks done yet with server-grade environments?

    Am sure there are, but...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Restoring AG databases from PRODUCTION to QA environment

    This sounds like a job for....Powershell.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Are the posted questions getting worse?

    GilaMonster - Tuesday, February 21, 2017 2:59 PM

    JustMarie - Tuesday, February 21, 2017 2:09 PM

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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 Log file and Data file available free space in percentage


    drop table #temp
    create table #temp(dbname varchar(25), fileid int, used float)
    exec sp_msforeachdb
    'use [?]
    insert into #temp
    Select
    db_name(),fileid,
    ((CAST ( (fileproperty(name, ''SpaceUsed'')*8)/1024 as...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: SSRS Report Designer Error

    Did you set your parameters on the report?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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 vs SQL Server v.Next

    RichB - Wednesday, February 15, 2017 5:55 PM

    As a matter of interest -
    did you have the same block size disk format?
    did...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Can anyone recommend a working sample ETL package created with SSIS?

    halifaxdal - Wednesday, February 15, 2017 12:56 PM

    Henrico Bekker - Wednesday, February 15, 2017 12:49 PM

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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 - 181 through 195 (of 1,079 total)