Activity overview
Latest activity by fhanlon
Check why there is lots of space. Are there particular tables with indexes that are very large having lots of unused space. If so you can try to reorg indexes of ever drop unused indexes to free up space. There are lots of scripts available that will help you find space used by table as well as space used by indexes. Look at some of your larger tables first but look at tables that have indexes with large amounts of unused space as well. / comments
Check why there is lots of space. Are there particular tables with indexes that are very large having lots of unused space. If so you can try to reorg indexes of ever drop unused indexes to free ...
If this is still an issue, check where is the bloat. Often indexes contribute to this. You can try reorging or rebuilding indexes to see if this helps. Reorging an index is process that can be stopped and restarted later. Reindexing rolls back so this is different but at least this process can be done bit by bit. Stat with finding some of your large tables and checking out the index sizes. / comments
If this is still an issue, check where is the bloat. Often indexes contribute to this. You can try reorging or rebuilding indexes to see if this helps. Reorging an index is process that can be s...
We use SQL compare to promote changes to objects from Dev, to stage, to Prod. This helps ensure consistency in the various environments. We have on more than one occasion found objects that someone "forgot" in stage and never promoted up. It is a valuable tool in our change process. / comments
We use SQL compare to promote changes to objects from Dev, to stage, to Prod. This helps ensure consistency in the various environments. We have on more than one occasion found objects that someo...
Thanks. I tried it again and it works as expected / comments
Thanks. I tried it again and it works as expected
Export Comparision results
Does this work for anyone? Even thouggh i have numereous differences and objects found in one database but not another, When I do the Export Comparison in either SIimple HTML or Interactive HTML i...
Filtering
The filtering is nice. I can now filter on specific objects. I like the idea of differnt filters for differnt objects (eg Stored procs have a separate filter from Views, users etc)
Select the table to compare
I would like to be able to select the tables I want to compare. For example I would like to be able to compare Table1 to Table2 in the same database, then compare Table1 to Table3 in the same data...
When I run C:\Program Files\Red Gate\SQL Backup\SQBServerSetup.exe I enter in all information including userid/password of cluster id I get an error that read: Internal error'RunTime Error' at 117:829 Generic failure. / comments
When I run C:\Program Files\Red Gate\SQL Backup\SQBServerSetup.exe I enter in all information including userid/password of cluster id I get an error that read: Internal error'RunTime Error' at ...
Upgrading to 5.1 causes object cannot be cast from DBNull
get Object cannot be cast from DBNULL to other types error on Start SQL backup serverice step. This is a clustered server
I get the same error but my database has a recovery model of full / comments
I get the same error but my database has a recovery model of full