Skip to main content


Showing posts from December, 2009

VS 2003 Find in Files

As anyone running Windows Vista will probably have noticed, the Find in Files feature hangs when running Visual Studio 2003 on Vista. To resolve this issue: Right-click the shortcut you use to launch Visual Studio .NET 2003 Select the Compatibility tab. Check “Disable Visual Styles” Click OK Launch VS 2003 – the Find in Files feature will work.

Reorganize files before releasing unused space

OK, what does it actually mean! When shrinking a database in SQL you are presented with the option “Reorganize files before releasing unused space. Selecting this option may affect performance.” If ticked it is the equivalent of running DBCC SHRINKDATABASE with a target_percent set, if it is unticked it is the equivalent of DBCC SHRINKDATABASE with the TRUNCATEONLY option. Ticking the box may affect performance while shrinking the database so it may take longer BUT it will not affect the performance of the database once shrunk.

Improve SQL Server delete performance with views

The SQL Server development customer advisory team met with the MySpace database to team to tackle any pain points with their use of SQL Server. Fortunately one of the key points was an issue I am currently battling with: efficient ordered deletes on large quantities of data. They have identified a potential improvement creating a view and then deleting from within that view rather than deleting directly from the table. As MySpace are dealing with huge volumes of data and it works for them it has to be worth incorporating into any deletion plan. This approach also provides an excellent way for deleting the top x records from a table. Essentially: create view v1 as (select top (10000) * from t1 order by a) delete from v1 drop view v1 Full details from LuborK here >> It is also worth considering disabling any indexes related to the table you are deleting from as described here .

How to enable and disable indexes

Whilst working to speed up a delete statement on a table of 6000000+ records it proved efficient to disable the table indexes, run the delete statement then enable the indexes again. If the indexes are left enabled there is a large overhead in rebuilding the indexes for each record that is deleted from the target table. Disable an index: alter index <<index name>> on <<table name>> disable Enable an index: alter index <<index name>> on <<table name>> rebuild Please be aware the ALTER INDEX command is only available in SQL Server 2005 and above. Also, SQL Server Management Studio doesn’t show the disabled status of an index within the main view so it is possible to disable an index and leave it disabled without realising. More details on this from Decipher Info Sys Features

Features includes an online PDF converter so you can easily create Adobe® PDF documents from your existing files in Microsoft® Word, Excel®, PowerPoint®, and many other applications. View and print PDF files across platforms that look exactly like the original documents regardless of the application used to create them. Individuals, businesses and government agencies around the world trust and rely on PDF to communicate their ideas and vision.