• ramana3327 (8/27/2014)


    Yes GailShaw.

    I need to do the partition. Do you think it will degrade the performance?

    What is your suggestion?

    Thanks,

    You said you didn't have problems now but data is growing and you want partitioning to make things faster. I submit that you, like SOOO many others that have tried to go down the table partitioning road for such a reason, simply need to TUNE WHAT YOU HAVE (schema, indexing, maintenance practices, hardware, SQL Server, windows, IO subsystem, code, etc, etc) and then you will have ZERO "need" for partitioning!!! 😎

    Now, if you are trying to run 1TB+ of data on a $5000 server you may also need "bigger hardware", but that is a simple and cheap thing to deal with if it is really required. But that should only be considered AFTER you have done the tuning.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service