Notechsoft Forums

Software Problems and Useful Utilities : Karaoke Sound Tools 1.0.9

Wed, 19 Nov 2008 10:31:09 +0000

Author: mrweb
Subject: Karaoke Sound Tools 1.0.9
Posted: 19/Nov/2008 at 10:31am

Karaoke Sound Tools - Remove vocal, adjust key and tempo of karaoke songs

Karaoke Sound Tools lets you remove vocal, adjustkey and tempo of karaoke songs. Karaoke Sound Tools is an easy to usesoftware package for karaoke audio processing.

If you use akaraoke BIN or MP3+G file and use tempo changer, the graphics part ofthe song will be adjusted so the lyrics are in sync with slower orfaster version of the song. No other software has this feature.

Here are some key features of "Karaoke Sound Tools":

Vocal remover to remove vocal parts from CD recordings
Control the amount of bass and treble processing.
Remove vocals from non-centered recordings using balance.
Adjust vocal removing level and output attenuation.
Key changer to adjust the song to singers voice.
change the pitch in -12 to +12 semitone (half-note steps) range.
After processing, music instruments nor vocal have no chipmunk or timespeed up or down, holding the tempo the same as if the original studiorecorded in your key.
you can process karaoke songs with lyrics (BIN and MP3+G).
Tempo changer to speed up or slow down the song.
change the tempo of the song from two times slower to twice as fast.
tempo changer retains the original key of the song
you can process karaoke songs with lyrics -- they will be adjusted to stay in sync.

Download it with serial number (full version)
http://www.notechsoft.com/forum/download.asp?v=63

ASP.NET : ASP.Net Tutorials from Youtube

Wed, 19 Nov 2008 07:17:42 +0000

Author: mrweb
Subject: ASP.Net Tutorials from Youtube
Posted: 19/Nov/2008 at 7:17am

ASP.Net Tutorial from Youtube

Youtube has many ASP.Net video tutorials ,I believe they are useful .Here are samples.

ASP.NET Repeater com C#

[TUBE]TdI8Dhd3EPI[/TUBE]

C# (ASP.NET) Contact form and email
[TUBE]uuyMcmwJGO8[/TUBE]

You can watch and download more examples directly from this link
http://www.notechsoft.com/youtube_result.asp?PageNo=1&v=ASP.Net%20Toturial

Download youtube videos :

http://www.notechsoft.com/download_youtube.asp

Edited by mrweb - Yesterday at 10:36am

SQL Server : SQL Server Settings Optimization Tips

Tue, 18 Nov 2008 03:40:32 +0000

Author: mrweb
Subject: SQL Server Settings Optimization Tips
Posted: 18/Nov/2008 at 3:40am

SQL Server Settings Optimization Tips

--------------------------------------------------------------------------

You can increase the 'min memory per query' option to improve theperformance of queries that use hashing or sorting operations, if yourSQL Server has a lot of memory available and there are many queriesrunning concurrently on the server.
The SQL Server will automatically allocate, at a minimum, the amount ofmemory set in this configuration setting. The default 'min memory per query'option is equal to 1024 Kb.

--------------------------------------------------------------------------

You can increase the 'max async IO' option if your SQL Server workson a high performance server with high-speed intelligent disk subsystem(such as hardware-based RAID with more than 10 disks).
This option specifies the maximum number of outstanding asynchronousdisk I/O requests that the entire server can issue against a file.By the way, the 'max async IO' SQL Server option is no longer supportedin SQL Server 2000.

--------------------------------------------------------------------------

You can change the 'network packet size' option to the appropriate value.
This option can improve performance on networks whose base topology supportslarger packets than TCP/IP's default of 4096 bytes. For example, if clientsends or receives large amounts of data, a larger packet size can improveperformance, because it results in fewer network reads and writes.The default value for the 'network packet size' option is 4096 bytes.Microsoft does not recommend changing this option, because for mostapplications, the default packet size of 4096 bytes is best.

--------------------------------------------------------------------------

You can change the 'fill factor' option to the appropriate value.
The 'fill factor' option specifies how full SQL Server will make eachindex page. When there is no free space to insert new row on the indexpage, SQL Server will create new index page and transfer some rows fromthe previous page to the new one. This operation is called page splits.You can reduce the number of page splits by setting the appropriatefill factor option to reserve free space on each index page.The fill factor is a value from 1 through 100 that specifies thepercentage of the index page to be left empty.The default value for fill factor is 0. It is treated similarly to afill factor value of 100, the difference in that SQL Server leavessome space within the upper level of the index tree for FILLFACTOR = 0.The fill factor percentage is used only at the time the index is created.If the table contains read-only data (or data that very rarely changed),you can set the 'fill factor' option to 100. When the table's data modifiedvery often, you can decrease the 'fill factor' option to 70 percent, forexample.

--------------------------------------------------------------------------

You can increase the 'recovery interval' value.
The 'recovery interval' option specifies the maximum number of minutesper database that SQL Server needs to complete its recovery procedures.The default value of this option is 0. It means that SQL Server willautomatically configure this option.SQL Server issues a checkpoint using the 'recovery interval' option.Microsoft does not recommend changing this option in general case,but sometimes you can improve performance by changing this option.You can monitor disk-write activity on the data files, and if you seeperiodic spikes that send disk utilization to 100 percent, you canincrease the recovery interval. In this case, Microsoft suggestssetting the 'recovery interval' option to 5 and continuing monitoring.

--------------------------------------------------------------------------

You can set the 'priority boost' SQL Server options to 1.
You can set this option to 1, if you want from SQL Server to work witha higher priority than other processes on the same computer. The defaultvalue is 0. Setting 'priority boost' to 1 can degrade the performance ofother applications running on the same computer with SQL Server.So, you should set the 'priority boost' SQL Server options to 1 only ifyou have dedicated server to SQL Server.In other case, do not change this option.

--------------------------------------------------------------------------

Set the 'max worker threads' options to the maximum number of theuser connections to your SQL Server box.
The default setting for the 'max worker threads' option is 255. If thenumber of user connections will be less than the 'max worker threads'value, a separate operating system thread will be created for each clientconnection, but if the number of user connections will exceed this valuethe thread pooling will be used.For example, if the maximum number of the user connections to your SQL Serverbox is equal to 50, you can set the 'max worker threads' options to 50, thisfrees up resources for SQL Server to use elsewhere. If the maximum numberof the user connections to your SQL Server box is equal to 500, you can setthe 'max worker threads' options to 500, this can improve SQL Serverperformance because thread pooling will not be used.

--------------------------------------------------------------------------

You can specify the 'min server memory' and 'max server memory' options.
These options can be used to specify the fixed amount of memory to allocateto SQL Server. In this case, you should set the 'min server memory' and'max server memory' to the same value (equal to the maximum amount ofphysical memory that SQL Server will use), and set the 'set working set size'SQL Server option to 1. This can improve performance because SQL Serverwill not dynamically allocate memory.You can also change these options when SQL Server works on the same computerwith other applications. In this case, the 'min server memory' options isused to allow SQL Server works when other applications pretend to use allavailable memory, and the 'max server memory' options is used to allowother applications work when SQL Server tried to use all available resources.

--------------------------------------------------------------------------

You can specify the 'set working set size' SQL Server option toreserve the amount of physical memory space for SQL Server.
Unlike SQL Server 6.5, SQL Server 7.0/2000 can automatically allocatememory (can take more memory if SQL Server need it, and can give memoryback to operation system). This is one of the main advantages incomparison with previous versions, but dynamic memory allocationtakes some time. If you know the maximum amount of physical memorythat SQL Server will use, you can specify this amount by setting'min server memory' and 'max server memory' to the same value (equalto the maximum amount of physical memory that SQL Server will use)and set the 'set working set size' option to 1.

--------------------------------------------------------------------------

Introduce Yourself : surrogate

Sun, 16 Nov 2008 11:51:31 +0000

Author: orphans40
Subject: surrogate
Posted: 16/Nov/2008 at 11:51am

God created us to be happy and we must be happy but if we missed the salt of the world , even if billion of dollars we can not be happy and what is the salt of the world ,CHILDREN.

There are many that needs children , we can help each other , one of the ways is through surrogacy , if you need a surrogate GS or TS , dont hesitate to get in touch with me through this forum

God bless

Software Problems and Useful Utilities : Make online backups

Sun, 16 Nov 2008 00:54:49 +0000

Author: mrweb
Subject: Make online backups
Posted: 16/Nov/2008 at 12:54am

Make online backups

If you don not make regular backups of your data, I believe you are asking for troubles. I in person lost my precious data twice, just because I did not make a backup of my data. It was boring to collect files and folders and start copying them to a CD.

Well, the good news is you do not have to do this anymore,MozyHome Free (http://mozy.com/home) gives you an automated online-backup service with 2GB of free storage--enough to preserve all your most critical files (it's a free service). If 2GB is not enough for you, you can upgrade your account to a business account (http://mozy.com/registration/business).

Feature Set

Security

128-bit SSL encryption — Safely secures your data during transport.
448-bit Blowfish encryption — Safely secures your data on Mozy, Inc.'s servers.
Private encryption key options — Choose Mozy's own 448-bit key or manage your own private key to encrypt your data.
Near Continuous Data Protection — MozyPro automatically detects and backs up new and changed files every 2 hours.

Performance

Automatic or scheduled backup— Tell MozyPro when to perform your backups. Automatic is the simplestmethod in which backups are performed while your computer is not inuse. Scheduled backups can be performed daily or weekly at a specifiedtime of day.
Block level incremental backups — Saves bandwidth and ensures future backups are lightning fast.
Bandwidth throttling — You can tell MozyPro to use more or less of your upload bandwidth so other higher priority services can run unimpeded.

Ease of Use

Version (snapshot) support — Users have the option of restoring from multiple file versions up to 30 days in the past.
Backs up SQL, Exchange and file servers — Protect mission-critical data easier than ever with MozyPro.
Network Drive support — The ability to back up networked or mapped drives
Windows Server support— In addition to Windows Vista and XP, MozyPro also backs up yourWindows 2003 and Windows 2000 servers. 64-bit Windows is supported.
Open/locked file support — No need to close files in order to back them up. MozyPro backs up all open and locked files, including Outlook PST files.
MozyPro's easy-to-use interfacewas designed with the "non-tech-savvy" user in mind. It's as simple asselecting the files to back up, scheduling the times, and lettingMozyPro do the rest.
Backup sets are pre-built for the most common file types. Advanced users may edit existing backup sets or create their own.

Edited by mrweb - 16/Nov/2008 at 12:57am

Microsoft Windows Forum : Outlook on the Desktop

Sun, 16 Nov 2008 00:21:35 +0000

Author: mrweb
Subject: Outlook on the Desktop
Posted: 16/Nov/2008 at 12:21am

Outlook on the Desktop

Have you ever wondered why it's such a pain in the butt to usecalendaring programs on your computer? It's simple: they don't mimictheir real life counterparts very well. People who use calendars toorganize their daily lives have them visible in plain sight nearly allof the time. Yet, on the computer, you have to go through a myriad ofwindows and clicks before you can even see your calendar. So to bridgethe gap, I've come up with this little program that will place theMicrosoft Outlook Calendaring system right on your desktop. Thecalendar object gets pinned to your desktop and stays there all thetime in plain sight so you can always see what's upcoming. Of course,the benefits don't stop there ... because it's the actual MicrosoftOutlook calendar, you get all it's functionality, such as directediting, drag and drop of files, etc. You have to see it to believe it.
Download:
http://www.outlookonthedesktop.com/setup.exe

Features

Places fully functional Microsoft Outlook Calendar on your Desktop.
The Outlook Calendar is pinned to your desktop so that no windows can get stuck behind it.
The Calendar's position, size and opacity are all adjustable via a very intuitive GUI.
A tray Icon (complete with the day of the month) is provided to to configure the app and perform other actions.
Multiple-Monitor Support.
Ability to switch between calendar, inbox, contacts, tasks and notes views.

Requirements

Windows XP or higher
Microsoft Outlook 2000 SP3 or higher
Microsoft .NET Framework 3.5
(The setup program will download and install it for you if you don't have it)

Download:
http://www.outlookonthedesktop.com/setup.exe

SQL Server : DTS Optimization Tips

Sat, 15 Nov 2008 09:34:30 +0000

Author: mrweb
Subject: DTS Optimization Tips
Posted: 15/Nov/2008 at 9:34am

DTS Optimization Tips

Avoid using DTS if it is possible to use Transact-SQL distributed querysuch as a SELECT INTO statement to transfer data.
Using Transact-SQL is the fastest method to move data between SQL Servertables, so try to use Transact-SQL statements to move data whenever possible.

------------------------------------

Try to use BULK INSERT statement instead of bcp or DTS to load datainto SQL Server from the text file.
The BULK INSERT statement is much faster than bcp or the data pump to performtext file import operations, however, the BULK INSERT statement cannot exportdata from SQL Server to a data file.

------------------------------------

Use the bcp utility instead of DTS when you need to export data fromthe SQL Server table into a text file.
The bcp utility is much faster than DTS, so try to use it whenever possible.

------------------------------------

Try to avoid using data pump operations that use ActiveXtransformation scripts.
Because data pump operations that use ActiveX transformation scriptscan be up to two to four times slower than copy operations, you shouldavoid using ActiveX transformation scripts, whenever possible.

------------------------------------

If you cannot avoid using ActiveX scripts in your data pumpoperations, try to use VBScript instead of JScript or PerlScript.
Microsoft recommends to use VBScript because scripts written in VBScriptrun approximately 10 percent faster than scripts written in JScript,which in turn run approximately 10 percent faster than scripts writtenin PerlScript.

------------------------------------

When the transformation contains many columns (more than 20)and the data pump operations use ActiveX transformation scripts,use ordinal values to refer to columns in ActiveX transformationsinstead of referring to columns by name.
Use this tip only when the transformation contains many columns.If the transformation contains less than 20 columns, use columns nameto refer to columns in ActiveX transformations to make the scripteasier to read.

------------------------------------

Try to use many-to-many copy column transformations instead ofone-to-one copy column transformations.
The DTS Import/Export Wizard uses many-to-many column mappings.By default, the DTS Designer assigns one-to-one column mappingsto transformations in order to improve readability. Because a singlemany-to-many copy column transformation is faster then many one-to-onecopy column transformations, you can manually set your Transform Datatask or Data Driven Query task to use many-to-many column mappings.For example, to set Transform Data task to use many-to-many columnmappings in SQL Server 2000 DTS Designer, you can do the following:
1. Choose appropriate Transform Data task in the DTS Designer.
2. Right-click this task and select Properties.
3. On the Transformations tab click 'Select All' button.
4. Click 'Delete All' button.
5. Click 'New' button and choose 'Copy Column' in the Create New Transformation window.
6. Specify the transformation options and click 'OK' button.

------------------------------------

You can increase the DTS package priority.
To increase the DTS package priority in SQL Server 2000, try the following:
1. Run SQL Server Enterprise Manager.
2. Expand a server group; then expand a server.
3. Expand Data Transformation Services and choose appropriate package.
4. Right-click package and select 'Design Package'.
5. From the top menu of the DTS Designer click Package and select Properties.
6. On the General tab increase the package priority by moving the slider bar to the right one or two steps (the slider bar has three position, and the default setting is at the second setting).

------------------------------------

You can increase the Transform Data task or Data Driven Query task priority.
To increase the Transform Data task priority in SQL Server 2000 DTS Designer,you can do the following:
1. Choose appropriate Transform Data task in the DTS Designer.
2. Right-click this task and select Workflow Properties.
3. On the Options tab increase the task priority by moving the slider bar to the right one or two steps (the slider bar has five position, and the default setting is at the third setting).

------------------------------------

Try to use 'Microsoft OLE DB Provider for SQL Server' instead of'Microsoft ODBC Driver for SQL Server' and 'Microsoft OLE DB Providerfor Oracle' instead of 'Microsoft ODBC Driver for Oracle'.
Because native OLE DB provider is faster than ODBC provider, youshould use OLE DB provider whenever possible.

------------------------------------

Try to avoid DTS lookups.
Because DTS lookups slow down performance, try to use the Transact-SQLstatements to perform the same functions.

------------------------------------

Check the 'Use fast load' advanced option of the Transform Data task.
When you enable this option, the high-speed bulk-copy processing will beused. To enable this option in SQL Server 2000 DTS Designer, you can dothe following:
1. Choose appropriate Transform Data task in the DTS Designer.
2. Right-click this task and select Properties.
3. On the Options tab check the 'Use fast load' option.

------------------------------------

Increase the ODBC query time-out value to improve query performanceon large SQL Server 2000 DTS packages stored in a repository.
Change this registry setting from the default value (10 seconds):HKEY_LOCALMACHINE\SOFTWARE\Microsoft\Repository\Engine\ODBCQueryTimeoutThe ODBC query time-out values are measured in seconds.

------------------------------------

When using SQL Server 2000 Transform Data task, try to use'Copy Column' method to transfer data.
This is the fastest way to transfer data using Transform Data task,so it should be used whenever possible.

Edited by mrweb - 15/Nov/2008 at 9:34am

SQL Server : Better Performance - LEFT JOIN or NOT IN?

Sat, 15 Nov 2008 09:21:19 +0000

Author: mrweb
Subject: Better Performance - LEFT JOIN or NOT IN?
Posted: 15/Nov/2008 at 9:21am

First of all answer this question : Which method of T-SQL is better forperformance LEFT JOIN or NOT IN when writing query? Answer is : Itdepends! It all depends on what kind of data is and what kind query itis etc. In that case just for fun guess one option LEFT JOIN or NOT IN.If you need to refer the query which demonstrates the mentionedclauses, review following two queries.

Code:

USE AdventureWorks;
GO
SELECT ProductID
    FROM Production.Product
    WHERE ProductID
            NOT IN (
    SELECT ProductID
        FROM Production.WorkOrder);
GO
SELECT p.ProductID
    FROM Production.Product p
            LEFT JOIN Production.WorkOrder w ON p.ProductID = w.ProductID
    WHERE w.ProductID IS NULL;
GO

Now let us examine the actual execution plan of both the queries.
Click on image to see larger image.

You can clearly observe that first query with NOT IN takes 20%resources of execution plan and LEFT JOIN takes 80% resources ofexecution plan. It is better to use NOT IN clause over LEFT JOIN inthis particular example. Please note that this is not genericconclusion and applies to this example only. Your results may vary onmany factors. Let me know your comments if you have guessed thiscorrect or not.

SQL Server : Choice Between Stored Procedures, Functions, Views

Sat, 15 Nov 2008 09:17:18 +0000

Author: mrweb
Subject: Choice Between Stored Procedures, Functions, Views
Posted: 15/Nov/2008 at 9:17am

Views
Views are one of the greatest things invented sincesliced bread. The main beauty of a view is that it can be used like atable in most situations, but unlike a table, it can encapsulate verycomplex calculations and commonly used joins. It can also use prettymuch any object in the db except for stored procedures. Views are mostuseful when you always need to join the same set of tables say an Orderwith an Order Detail to get summary calculation fields etc.

Feature	Rating
Works in various kinds of databases	4(many databases such as DB II, Oracle, SQL Server support them, MySQL5, PostGreSQL, SQLite, MSAccess (calls it a query)). There are alsosome that don’t e.g. MySQL < 5.0
Can be called by multiple applications and interfaces	5 (generally they can be called anywhere where you can call a table which is pretty much everywhere)
Can take an undefined number of arguments	5 (you can select subsets of columns and rows from a view just like you can from a table)
Reusability within the database	5 (you can reuse them in other views, in stored functions and stored procedures).
Can be used to change data in a table without giving rights to a user to change table directly.	3 In many databases Views are read-only and complex views are rarelyupdateable. Note that for example some databases such asOracle,PostgreSQL, MS SQL Server , SQLite will allow you to update evena complex view by using an instead of trigger or rule against the view.MySQL 5, MS SQL Server and some others automatically make one tableviews updateable. MS Access has a fairly sophisticated update algorithmfor queries in that it automatically makes one table and evenmulti-table queries updateable and allows deletes if you define primarykeys appropriately. Also depending on the field a column comes from itwill update that and also automatically create child records in childtables if you try to update a child column when there is no record.
Can return varying number of fields given different arguments.	4– (you can select subsets of columns and rows from a view just like youcan from a table). However you can't change the underlying structuree.g. return records from a different set of tables like you can with astored procedure or function.
Long stretches of SQL easy to read.	3(A view can often be defined with an administrative designer or using acolor coded sql editor so is fairly easy to read) - in general thoughit is limited to only one select statement or unioned selectstatements.

Triggers And Rules

Triggersare objects generally tied to a table or view that run code based oncertain events such as inserting data, before inserting data,updating/deleting data and before these events happen.

Triggerscan be very great things and very dangerous things. Dangerous in thesense that they are tricky to debug, but powerful because no update toa table with a trigger can easily escape the trigger.

They areuseful for making sure certain events always happen when data isinserted or updated - e.g. set complex default values of fields,inserting logging records into other tables.

Triggers areespecially useful for one particular situation and that is forimplementing instead of logic. For example as we said earlier, manyviews involving more than one table are not updateable. However in DBMSsuch as PostgreSQL, you can define a rule on a view that occurs whensomeone tries to update or insert into the view and will occur insteadof the insert. The rule can be fairly complex and can layout how thetables should be updated in such a situation. MS SQL Server and SQLitelet you do something similar with INSTEAD OF triggers. Note the termRule is a little confusing in DBMS because they mean quite differentthings. In Microsoft SQL Server for example a Rule is an obsoleteconstruct that was used to define constraints on tables. In PostgreSQLa Rule is very similar to a trigger except that it does not gettriggered per row event and is defined without need of a handlingfunction.

Feature	Rating
Works in various kinds of databases	2(many databases such as DB II, Oracle, SQL Server support them, MySQL5, PostGreSQL,). There are lots that don't e.g. MySQL < 5.0, MySQL5 limited, MS Access
Can be called by multiple applications and interfaces	5 (it just happens behind the scenes. No application can escape them)
Can take an undefined number of arguments	0 ( strictly for updating data and against a table or view )
Reusability within the database	0 - No
Can be used to change data in a table without giving rights to a user to change table directly.	4 In general yes for databases that support them
Can return varying number of fields given different arguments.	0 –Triggers are strictly for updating data
Longstretches of SQL easy to read. A trigger can often be defined with anadministrative designer or using a color coded sql editor so is fairlyeasy to read	5

SQL Server : Choice Between Stored Procedures, Functions, Views

Sat, 15 Nov 2008 09:15:45 +0000

Author: mrweb
Subject: Choice Between Stored Procedures, Functions, Views
Posted: 15/Nov/2008 at 9:15am

Stored Procedures

Stored procedures are one of numerousmechanisms of encapsulating database logic in the database. They aresimilar to regular programming language procedures in that they takearguments, do something, and sometimes return results and sometimeseven change the values of the arguments they take when arguments aredeclared as output parameters. You will find that they are very similarto stored functions in that they can return data; however storedprocedures can not be used in queries. Since stored procedures have themechanism of taking arguments declared as OUTPUT they can in theoryreturn more than one output.

Feature	Rating
Works in various kinds of databases	3(many databases such as DB II, Oracle, SQL Server, MySQL 5,PostGreSQL, FireBird support them). There are also a lot that don’te.g. MySQL < 5.0, MS Access (although parameterized queries serve asimilar role)
Can be called by multiple applications and interfaces	4 (generally they can be called, but the use of OUTPUT arguments is not always usable)
Can take an undefined number of arguments	2(note most databases allow to define optional arguments, but this canbecome very unwieldy to maintain if there are a lot because you end upduplicating logic even within the stored procedure so is generallyavoided)
Reusability within the database	3(you can not reuse them in views, rarely in stored functions and otherstored procedures unless the stored procedure using it does not requirea return value or result query). This varies slightly from DBMS toDBMS.
Can be used to change data in a table without giving rights to a user to change table directly	4 In general true for most DBMSs that support them.
Can return varying number of fields given different arguments.	3–again in theory it can, but very hard to maintain since you wouldoften be duplicating logic to say return one field in one situation andother set of fields in another situation or update a field when thefield is passed in as an argument. Note that in many databases such asfor example SQL Server and Oracle, one can return multiple result setswith a stored procedure, but the receiving end needs to be able to do anext result set call and know the sequence in which the result sets arebeing sent.
Long stretches of SQL easy to read and maintain	5(one of the great strengths of stored procedures is that you can havelong transactions of sql statements and conditional loops which can beall committed at once or rolled back as a unit. This also saves onnetwork traffic.

Stored Functions
Stored Functions are very similar to stored procedures except in 3 major ways.

1- Unlike stored procedures, they can be used in views, stored procedures, and other stored functions.

2- In many databases they are prohibited from changing data or have ddl/dml limitations. Note for databases such as
PostGreSQL this is not true since the line between a stored function and a stored procedure is very greyed

3- They generally can not take output arguments (placeholders) that are then passed back out with changed values.

Feature	Rating
Works in various kinds of databases	3(many databases such as DB II, Oracle, SQL Server support them, MySQL5, PostGreSQL). There are also a lot that don’t e.g. MySQL < 5.0,MS Access
Can be called by multiple applications and interfaces	4 (generally they can be called, but the use of OUTPUT arguments is not always usable)
Can take an undefined number of arguments	2(note most databases allow to define optional arguments, but this canbecome very unwieldy to maintain if there are a lot because you end upduplicating logic even within the stored function so is generallyavoided)
Reusability within the database	5 (you can reuse them in views, in other stored functions and stored procedures). This varies slightly from DBMS to DBMS.
Can be used to change data in a table without giving rights to a user to change table directly	3 Many databases do not allow changing of data in stored functions excepttemp table data, but those that do in general support this.
Can return varying number of fields given different arguments.	4–For databases such as SQL Server, PostgreSQL, DB 2, Oracle that allowreturn tables and sets, you can selectively pick fields you want fromwithin a query. So although the function always outputs the same numberof fields, you can selectively use only some similar to what you can dowith views. This is not true for scalar functions (MySQL 5.1- onlysupports scalar functions).
Long stretches of SQL easy to read	5 - yes - you can do fairly intensive multi-line processing which in the end returns one value or table to the user.