Software Search
or: browse all software/services
Categories
SEO (19)
WebSite Software (66)
Desktop Software (1)
E-Commerce (66)
Database Tools (14)
Security Tools (5)
Image Tools (7)
Developer Tools (25)
Data Management Tools (19)
Admin Tools (32)
WebSite Visitor Experience (34)
B-2-Customer Interaction (8)
Services (Points) (1)
Passes/Subscriptions (1)
Shopping Carts »
    AspDotNetStorefront (5)
    Magento (5)
    VPCart (66)
Vendors »
    Big Yellow Zone (67)
Web Design Services (1)
Web Development Services (1)
 
(all products/services(67))
HELP/FAQs?

Got questions/problems? Take a look through our FAQs (frequently asked questions), or email us at: support@bigyellowkey.com. We shall do our best to get back to you promptly.

Want Discounts?

Are your prices for multiple domains too large? Are you trying to get licences for test domains but being asked to pay full cost? Don't worry; we can add test domains to your licences manually. Just purchase a single domain addon/upgrade for what it is that you need, and then email us about your situation regarding the remaining domains and we'll liaise with you over the options. email us at: support@bigyellowkey.com. We shall do our best to get back to you promptly. click here for more information regarding multiple domains, upgrades, and discount policies.

BigYellowKey News
(click here to view all BYK news)

Imminent: 4/1/2016 4:05:00 PM
BYZ Development Points have been changed
Click Here for details.
The new BYZ Development Points (BYZ192) replace all previous BYZ Points which are now no longer available.
Released: 4/1/2016 3:05:00 PM
BYZ Annual Pass Now Available!
Click Here for details.
The BYZ Annual Pass replaces the BYZ addon subscription service.
Released: 4/1/2016 2:05:00 PM
The BYZ Terms and Conditions have been changed.
Click Here for details.

Apologies, but online Payments are temporary unavailable as we are in the process of changing our payment gateway.
Please contact us if you wish to place an order and we will organize a manual payment process for you.
We hope/expect online payments to be available again soon.

SQLServer Space-Clearer for VPASP - BYZ185

<< back to previous screen

Clean-out unusable space and help unfragment your tables to speed up your site and avoid space errors across the cart.
ONLY relevant to VPASP sites that use a SQLServer database.



SQLServer Space-Clearer for VPASP - BYZ185
Latest version:01/28-AUG-2013
From vendor:Big Yellow Zone
For Terms and Conditions, click here
Please do not purchase any BigYellowZone
products/services or request technical
support until you have read and agree with
the terms and conditions.
Price:£20.00
add to cart


Compatibility, Bundling, and Status Notes:
Compatible with VPASP V4.5 to V7.
Before installing, you must have installed:
BYZ038
BYZ036

This product includes:
BYZ038
BYZ036

When you delete and then create/recreate records in a table in a SQLServer database, the space that was originally being used for the now-deleted records will still be "reserved" for that table.

This means that after a while some of your tables will be reserving/using a large amount of empty-space that serves no purpose, and when this reaches a certain level your overall database will start running out of space and the database will generally become "fragmented".

That fragmentation will slow the site down substantially, and the lack of space will cause errors across the whole site/sytem when you reach the space limit.

To free-up that unusable reserved space so that it can be used for real data and log files etc, the "CLEANTABLE" SQLServer command can be issued.

The SQLServer Space-Clearer is a simple/quick way of reliably clearing such space for any/all of your tables at the click of a button from VPASP Admin - it will run the "CLEANTABLE" command for all the tables that you tick on the parameter block.

By default, all tables in your database will be "ticked", but you can untick/tick whichever tables you want.


Technical/Developer Information:
There is no need for you to configure/list which tables are available; the SQLServer Space-Clearer will automatically find and list all the tables that are in your database for you. So if you add a new table, or drop an existing table, the SQLServer Space-Clearer will continue to do its job without you having to change its configuration/installation.

It will show you a progress/results block, listing the individual tables that are going through the cleaning process, and it will show you any that fail the cleaning process (eg if they're locked-out temporarily because they're being written-to by another process).

This is not just relevant to tables that have records deleted/recreated, but also to tables that have had COLUMNS dropped at sometime in the past.


Terms and Conditions:
For terms, conditions, and licensing information for all BigYellowZone products/services, please click here.
Please do not purchase any BigYellowZone products/services or request technical support until you have read and agree with the terms and conditions.


Full Version History:
VerNo Version Date Release Notes
01 28-AUG-2013 Initial version - Big Yellow Zone SQLServer Space Clearer For VPASP