Forum Replies Created

Viewing 15 posts - 151 through 165 (of 4,745 total)

  • RE: Scale out after standalone implementation

    no its not too late, just point the new instance at the same SSRS reportserver database.

    ---------------------------------------------------------------------

  • RE: Task manager of SQL box shows 100% memory usage but it is not actually used..

    you don't say the version of OS in use but don't use the free memory value in task manager, look at available memory.

    Use perfmon counters to check SQL memory usage

    ---------------------------------------------------------------------

  • RE: RESTORE DB FROM 2008 to 2012

    ....and tempdb cannot be backed up anyway as it is recreated on SQL server restart.

    ---------------------------------------------------------------------

  • RE: Trace files not open in tuning advisor

    presuming you have the rights, try right clicking on DTA and run as administrator.

    ---------------------------------------------------------------------

  • RE: What color is SQL Server?

    surely it would be Azure.

    ---------------------------------------------------------------------

  • RE: Reading, Writing, and Riskmetic

    GilaMonster (6/19/2014)


    The problem, however, is that statistics IO lies any time there are scalar UDFs in use. The profiler trace doesn't.

    there's lies, damn lies, then statistics IO 🙂

    ---------------------------------------------------------------------

  • RE: Interesting issue with an Agent job suddenly taking longer...

    Aaaah, a classic 'nothing has changed - honest guv' case.

    ---------------------------------------------------------------------

  • RE: Interesting issue with an Agent job suddenly taking longer...

    A batch job in dev that runs at 5 a.m. for an extra 4 mins - this developer would have to be one of the good ones.........:-)

    Its the sizes of...

    ---------------------------------------------------------------------

  • RE: Interesting issue with an Agent job suddenly taking longer...

    as the database ran out of space sounds like the database grew so there is more data for the SSIS package to process, so probably just a scaling issue.

    check how...

    ---------------------------------------------------------------------

  • RE: Are the posted questions getting worse?

    Luis Cazares (6/16/2014)


    David Burrows (6/16/2014)


    Sean Lange (6/16/2014)


    ...a few technological advances (like goal line technology).

    Except that in one match already, with two different views of the goal line, one clearly...

    ---------------------------------------------------------------------

  • RE: Are the posted questions getting worse?

    David Burrows (6/16/2014)


    Sean Lange (6/16/2014)


    ...a few technological advances (like goal line technology).

    Except that in one match already, with two different views of the goal line, one clearly showed no...

    ---------------------------------------------------------------------

  • RE: Active Threads link

    me too for the first time today. Keeps asking me to log on as well.

    ---------------------------------------------------------------------

  • RE: Policies/Procedures on preventing after hours calls

    After a call an RCA (root cause analysis) should be done to avoid repitition of calls. At our shop this is handled by the Incident management team.

    ---------------------------------------------------------------------

  • RE: Patching Clustered Instances

    I have only ever seen the script upgrade phase take minutes, never hours, and I've done a few.

    We have 'stagger patched' clusters as well, theoretically the two nodes could run...

    ---------------------------------------------------------------------

  • RE: Patching Clustered Instances

    it will run through the upgrade script process on first failover to a patched node, but that should be a matter of a few (2-3) minutes.

    Failover time will be more...

    ---------------------------------------------------------------------

Viewing 15 posts - 151 through 165 (of 4,745 total)