Forum Replies Created

Viewing 15 posts - 466 through 480 (of 1,079 total)

  • RE: SSAS Calculated Member

    your measure can be created based on the amount of sales * cost per product.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Performance Improve for adding Tempdb file?

    You can use the DMV to monitor the values: sys.dm_os_wait_stats

    a good explanation on the types and what they mean on MS site below.

    http://msdn.microsoft.com/en-us/library/ms179984.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: Performance Improve for adding Tempdb file?

    The general rule I know is: 1 data file per logical or physical processor (i.e. a SQL Server 2005 running on 4 quad-core cpus -> 16 cores should have 16...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Performance Improve for adding Tempdb file?

    Hi Ananda, please have a look at the link below..

    http://blogs.msdn.com/b/psssql/archive/2009/06/04/sql-server-tempdb-number-of-files-the-raw-truth.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: SSAS Training Course Recommendations

    Contact Pragmatic Works.

    http://pragmaticworks.com/services/training/Default.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: Are the posted questions getting worse?

    GilaMonster (1/4/2012)


    Henrico Bekker (1/3/2012)


    How can I convince my manager, and company that its a great idea to send me to SQL 2012 Launch?/quote]

    I'm not even trying. I have a very...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Business Intelligence

    Everyone's view might be different but should mean the same thing at the end, so here goes:

    1. What is Business Intelligence ?

    Making sense and adding value to your data, visualising...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Truth and Demos

    Our department, comprising of Technical Specialists and Sales People, have adopted the policy that no product or service will be sold to any customers without the involvement from the people...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: How to protect my Database.

    I assume you are somewhat new to SQL Server, so here are a few good links to get you started.

    http://www.sql-server-citation.com/2009/05/how-to-secure-sql-server-sql-server.html

    http://www.sql-server-performance.com/2002/sql-security/

    http://searchsecurity.techtarget.com/news/873207/Top-10-SQL-Server-security-blunders

    http://www.bradmcgehee.com/2010/09/sql-server-security-checklist/

    http://sqlsecurity.com/FAQs/SQLSecurityChecklist/tabid/57/Default.aspx

    Some material may be outdated, but you'll get the basics and...

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

    How can I convince my manager, and company that its a great idea to send me to SQL 2012 Launch?

    http://devconnections.com/shows/sp2012/default.aspx?s=185

    flying to the USA from South Africa and accommodation will 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: Installing New instance on Existing 2 node Active- Passive SQL Server 2008 R2 Server

    Its the same as your primary cluster.

    I would however recommend using the current passive node as the active node for your second cluster.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Passed 70-450

    annajames63 (1/2/2012)


    congrats!

    i passed 70-450 exam and i did preparation from cheatsexam.com study material and test engines and i am happy to spend my money here

    I am pretty sure...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: How to split the Records?

    Charmer (12/20/2011)


    Henrico Bekker (12/20/2011)


    Text to Columns.

    in the menu under "Data", "Text to Columns"

    sorry i gave a wrong information...my source is .mdb....

    MS ACCESS?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: Continue on Failure

    did you build failure action as well into your dtsx package?

    for every success you need to anticipate a failure action as well, maybe use send mail or log a...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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: How to split the Records?

    Text to Columns.

    in the menu under "Data", "Text to Columns"

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