We have over 300 stores, and with each store having 30gb+ databases, each server is being upgraded to at least 6gb+ memory which is being forced allocated to SQL Server. I want to start to partition the existing SQL Server database by date. How do I go about doing it, because I have absolutely no idea? By the way, the stores experience timeout errors every day and it's not the H/W), please help.
Software/Hardware used:
ASKED:
April 30, 2008 6:01 PM
UPDATED:
May 2, 2008 1:47 AM
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.