• Stored procedure: Kill all processes

    Use this stored procedure to kill all user processes.

    ITKE54,905 pointsBadges:
  • Stored procedures vs. dynamic SQL: When should you use each?

    Stored procedures and dynamic SQL each have their place in the SQL Server world. You must consider parameters, tables being queried, the number of databases and so forth. In this tip, Serdar Yegulalp maps out the best scenarios for each.

    SearchWindowsServer1,010 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...

    ITKE54,905 pointsBadges:
  • 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...

    ITKE54,905 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...)

    ITKE54,905 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.

    ITKE54,905 pointsBadges:
  • Stored procedure: Create a fixed-width file to simplify data exports

    Exporting SQL Server data to a file from within a stored procedure is a common task, but there are different ways to do this --none of which are very easy.

    ITKE54,905 pointsBadges:
  • Stored procedures vs. functions

    Differences and when to use which.

    ITKE54,905 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.