DatabaseJournal.com Staff

This function converts a string into title case. It does have some limitations but should fit most scenarios. This code was originally developed by Russell Jones, our resident VB developer, and turned into a UDF by myself. The script has been tested on SQL Server 2000. Author: Darryl Fryatt Download Script: TitleCase.sql Disclaimer: We hope […]

I find that, on a monthly basis, tables that are heavily updated become fragmented. This script will run through your database, determine what tables have indexes on them, what type of index it is, and what filegroup it was built on. After all this information has been collected, the procedure will generate the script to […]

How Do I Make it Run Faster? The question in the heading is one I get asked all the time. Everyone is looking for the fast = true switch, assuming ‘database tuning’ means that you tune the database. In fact, it is my experience that more than 80 percent (frequently much more, 100 percent) of […]

By now, you might be able to see where I’m going in this section. I have made references above to other databases and how features are implemented differently in each. With the exception of some read-only applications, it is my contention that building a wholly database-independent application that is highly scalable is extremely hard — […]

This script has been designed to grant EXECUTE to all non-system stored procedures. Install the script in master to run from any database and pass username or role in single quotes. I find the script useful because (unless I’ve totally missed something) db_datareader/db_datawriter does not convey execute permissions to stored procedures. The script has only […]

This is a stored procedure that can be run in any database to change all tables and views so that they’re owned by dbo. It can be called like “exec sp_change_table_owner_to_dbo” and it will change all views and table to be owned by dbo or “exec sp_change_table_owner_to_dbo name” and it will change all views and […]

Recovery Manager (RMAN) is an Oracle utility that can back up, restore, and recover database files. The product is a feature of the Oracle database server and does not require separate installation.Recovery Manager uses database server sessions to perform the work of backup and recovery. It stores metadata about its operations in the control file […]

This script for SQL Server 2000 creates a user defined function to parse comma delimited lists and return a table with a unique key. The script can also be reused from within stored procedures. Author: Bhupathy Chinnagandham Download Script: fafn_parse_delimited_list.txt Disclaimer: We hope that the information on these script pages is valuable to you. Your […]

I have taken an existing stored procedure from Microsoft, sp_MSforeachdb, and modified it to exclude databases I do not wish to use for DBCC or Backup purposes. I also modified the sp_MSforeach_worker and added additional @command lines to execute more DBCC commands. This allows me to execute a one line statement to backup all DATABASE […]

I was working on a project recently where they decided to use only the latest, greatest technologies: everything was coded in Java with EJBs. The client application would talk to the database server using beans — no Net8. They would not be passing SQL back and forth between client and server, just EJB calls using […]

There’s no need to use proprietary procedural code to pass a list of parameters to a stored procedure. As the following script shows, it can be done by putting them into a string with a separator. Author: Celko Download Script: splitquery.sql Disclaimer: We hope that the information on these script pages is valuable to you. […]

This script runs dbcc checkdb, dbcc checkalloc, and dbcc check catalog on all databases on the server. The script runs against the sysdatabases table in master. The script is also dynamic so the stored procedures can reside on any database and run effectively. Furthermore since it is in a stored procedure it can be easily […]