Forum Replies Created

Viewing 15 posts - 286 through 300 (of 1,079 total)

  • RE: sql

    select getdate() as TimeStamp

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

    http://www.sqlservercentral.com/Forums/Topic1287903-392-1.aspx

    no comment needed.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Documentation?

    Excuse me if this sounds like a product punt, but BI Documenter from Pragmatic is an excellent documenter tool..

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: SQLServer with DB and reporting services

    8 GB RAM and a virtual one.

    not sure what you mean with "a virtual one"...

    Read up on the link I provided, also read up on PAE and /3gb switch for...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: production environment

    Identify the issues, determine if they can be corrected without downtime, investigate why the issues came up in production only but not in development of uat phases?

    bit of a vague...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: SQLServer with DB and reporting services

    can i select "Boost sqlserver priority" and "use windows fibers(lightweight pooling)", Will there be a impact in the server having same no of processors and RAM?.

    what will "AWE to allcoate...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Varchar length changing

    as long as the DSV refreshes the updates from the source fields, I don't see any possible issues.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Varchar length changing

    Question:

    how does the source varchar table length just change on the fly? :ermm:

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Looking for the 2000 DTS runtime for 2008 R2

    No worries, have a couple of those days myself.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Looking for advice on a clustered VM setup of sql server

    not sure about books...

    but

    http://www.ipsure.com/blog/2010/clustering-ms-sql-server-2008-r2-on-vmware-virtual-windows-server-2008-r2-1/

    http://clusterwhere.wordpress.com/2011/03/07/setup-microsoft-sql-server-2008-r2-failover-cluster-in-vmware-workstation-7/

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Job History

    Nice and easy - only because I've seen this as well.

    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: Looking for the 2000 DTS runtime for 2008 R2

    You need the Backward Compatibility Tools:

    feature Pack: Microsoft SQL Server 2000 DTS Designer Components

    http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_DTS.msi

    Microsoft SQL Server 2005 Backward Compatibility Components:

    32 bit http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_BC.msi

    64 bit http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_BC_x64.msi

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: CurrentMember less PrevMember = this period (behaviour of this calculated member)

    is the hierarchy properly designed to ensure SSAS knows what the current and premembers are?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: SQLServer 2000 Using Ram

    on 32bit windows and SQL only recognizes 3GB Physical memory. chances are SQL is using 90% of the 3GB in fact.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: SQLServer 2000 Using Ram

    Are you running 64 or 32bit?

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