Forum Replies Created

Viewing 15 posts - 496 through 510 (of 1,079 total)

  • RE: SQL Server Analysis Performance Tool

    Thanks Koen, appreciate your input!

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: TCP Provider: The specified network name is no longer available

    Monitor your network statistics, latency for a a few days and see if its network related.

    It could be a timeout issue as well.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Failover question

    Thanks. Yes, active/active. I assume if "Prevent failback" is checked in a situation when N1's resource fails and it fails over to N2 and then that same resource fails again,...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Failover question

    from your question I assume you are running an Active/Active Cluster?

    when a resource in N1 fails, the whole resource group will fail over to N2, and if a resource fails...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: backup for system database

    Simple answer: Yes.

    Advantages: You will be able to recover critical info such as Logins, Jobs, configuration.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: microsoft sql server 2012

    RTM hasnt been released yet, but you can download RC0 to play with in the meanwhile:

    http://www.microsoft.com/download/en/details.aspx?id=28145

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Want to start the career path to DBA, suggestions needed.

    Well, firstly, great career choice 😀

    The best would be to keep on learning and playing, because one day you will end up in a position where you may/could flaunt your...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: DATETIME 1

    great question (if you didnt run the t-sql)....certainly whipped by butt today 🙂

    lesson learned.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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

    http://lmgtfy.com/?q=SQL+server+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: Variant order 1

    L' Eomot Inversé (11/30/2011)


    Henrico Bekker (11/29/2011)


    even though x=y, and y=x, your case statement catered for the following result:

    'v3 = v2' and no where specifies v2=v3.

    "None of the Above" should 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: Variant order 1

    even though x=y, and y=x, your case statement catered for the following result:

    'v3 = v2' and no where specifies v2=v3.

    "None of the Above" should be correct as well.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Intersect

    erm...just me or does this query in fact work?

    name fileid

    master 1

    Ran it in Denali and seems fine... 😎

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Restore Status

    try using the following:

    use master

    go

    SELECT

    percent_complete AS ‘PctComplete’,

    start_time AS ‘StartTime’,

    command AS ‘Command’,

    ...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Background Colours to Report

    Please dont double-post.

    reply here: http://www.sqlservercentral.com/Forums/Topic1177646-150-1.aspx

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: BACKUP JOB in maintenace plan failed

    A few suggestions:

    http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/422c9841-6eb7-42ca-ab5d-50db52bbaa7a/

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