Activity overview
Latest activity by rashmitabaliyarsingh
This would be possible when you have a better synchronization server. And always keep the copies of Data. / comments
This would be possible when you have a better synchronization server. And always keep the copies of Data.
AMoney said:
Hi all! I've inherited a database which has grown to a huge bloat, and needs to be shrunk. How big? Well, it's over 4TB on disk - and more than 45% is bloat / empty pages. IE, more than 2TB can be reclaimed ... which would really help on our AWS costs. Note: This problem is compounded several times, since there were several copies of this "starter" database used, so there's actually about 12TB of disk space being used and almost 7TB of disk space that can be free'd up across all of the servers. Running shrink is a 4 day procedure on a cloned / copied version of the system, and no reads/writes, which we obviously cannot do in production. Some of the tables are full of binary data (that's a whole different problem). I do have an extended 12 hour maintenance window that I can shut down the server, export / copy / whatever to a new database, and drop the old database. Any suggestions? Is there a Red Gate tool to help here? - A
There is less number of such tools and they are paid also so one solution for this is to convert your data in the format in which are comfortable as well as took less memory and there is two way for doing this manually and professionally. / comments
AMoney said:
Hi all!I've inherited a database which has grown to a huge bloat, and needs to be shrunk. How big? Well, it's over 4TB on disk - and more than 45% is bloat / empty pages. IE, mor...
A created column is a column in a table that would not explicitly be set to a specific value in a query Instead, its value is automatically generated based on an expression. / comments
A created column is a column in a table that would not explicitly be set to a specific value in a query Instead, its value is automatically generated based on an expression.