• An advantage of using a stored procedure

    Suddenly, in most enterprises, ASP means Application Service Provider. But most programmers still know the acronym ASP as Active Server Page. This tip from Shelley Powers book Developing ASP Components, published by O'Reilly & Associates, looks at the advantages of using stored procedures in...

    ITKE344,995 pointsBadges:
  • stored procedure

    In a database management system (DBMS), a stored procedure is a precompiled set of Structured Query Language (SQL) statements that can be shared by a number of programs. (Continued...)

    ITKE344,995 pointsBadges:
  • Stored procedure: Determine last database backup

    You have dozens or hundreds of SQL Servers to administer and you just want to know when the last backup was taken for each database on each instance. This stored procedure will help.

    ITKE344,995 pointsBadges:
  • Check SQL Server database and log file size with this stored procedure

    Knowing the size of a SQL Server database is one of the many DBA responsibilities that you can accomplish easily with the stored procedure sp_SDS. Not only will sp_SDS determine "SQL Database Space," but it can also be used to monitor database growth, alert a DBA on data or log file growth, execute...

    ITKE344,995 pointsBadges:
  • ZIP files with a stored procedure

    A SQL Server stored procedure that zips files from a source and destination directory that you pass when calling the procedure.

    ITKE344,995 pointsBadges:
  • Quick way to find space used by each table in a database

    Use this stored procedure to find the disk space used by each table in a SQL Server database.

    ITKE344,995 pointsBadges:
  • Stored procedure: Simplify comma-separated value (CSV) exports

    Comma-separated value (CSV) exports are often used to provide SQL Server data to Excel -- but there is no simple way to export SQL Server data within a stored procedure to a file. The sp_SaveDelimitedColumns routine makes CSV exports a breeze by easily creating a file containing specific data.

    ITKE344,995 pointsBadges:
  • Stored procedure: Kill all processes

    Use this stored procedure to kill all user processes.

    ITKE344,995 pointsBadges:
  • Enabling and disabling all constraints on a table in SQL Server

    This SQL Server stored procedure will disable/enable all constraints for a given parametric table.

    ITKE344,995 pointsBadges:
  • Stored procedures vs. functions

    Differences and when to use which.

    ITKE344,995 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.