Forum Replies Created

Viewing 15 posts - 421 through 435 (of 1,079 total)

  • RE: automate a way to restart SQL at 5:30AM

    My 1st suggestion would be to fix the application.

    you can create a windows scheduled task with the 'net stop' and 'net start' commands...

    eg: net stop MSSQLSERVER

    ...

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

    Quick, straight forward and easy. Love the back to basic questions.

    We often forget the core stuff.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Reporting Services Install

    run: Select @@version in SSMS, past results back.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Ticker in SSRS

    You are looking for a scrolling marquee.

    Read here: http://www.tek-tips.com/faqs.cfm?fid=86

    Keep in mind, a SSRS Report is static text and needs to be refreshed to display new values.

    You will need to...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Reporting Services Install

    Imke, make sure the platform installer you are using is the same as the current SSRS installation.

    It looks like you are using a 32 bit installer on an existing 64bit...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Ticker in SSRS

    Tick box?

    Countdown Timer?

    Flashing icon?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: DBA Support cost - Per DB ( Unit Pricing Model)

    I loved this piece:

    Thanks in advance for an immediate reply

    To answer your question, no. There is no standard industry wide accepted calculation.

    This will be influenced by the rate...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: DBA Support cost - Per DB ( Unit Pricing Model) .

    Duplicate Post, replies here: http://www.sqlservercentral.com/Forums/Topic1253568-391-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: Ways to connect SQL Server to the outside world?

    Excel is the answer.

    http://tinyurl.com/7uu7ykt

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

    One question though if you execute you should get error below,

    Msg 134, Level 15, State 1, Line 9

    The variable name '@sqlstring' has already been declared. Variable names must 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: Resporting Services using business intelligent

    throw in some SharePoint integration with Performance Point content as well....get ready to have your Reporting mind-set blown!

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

    Obligatory pedantic complaint: they're parentheses, not brackets. These are brackets: []. (For completeness, these are braces: {}.)

    Noted; thank you.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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 Logical/Physical Reads!!!!

    GilaMonster (2/10/2012)


    Is there a question here?

    maybe it was suppose to be an article submission? 😛

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Unable to connect to SQL SERVER 2008

    is the service for your local instance running?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: What are the New Things in Sql Server 2012

    start here: http://www.microsoft.com/sqlserver/en/us/future-editions.aspx

    My favourites:

    1. ColumnStore Indexes

    2. HADR

    3. Contained DB's! (yeahaa!)

    4. All the incredible nifty BI changes

    5. Partition improvements

    6. Distributed Replay

    7. Contained DB's! (Wait? did I already say that?)

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