😺
wiki
  • Welcome, Internet Strangers!
  • sql
    • etl
      • Basics to Remember
      • Context to Remember
      • Naming Practices
      • ETL Steps
    • performance
      • Please No
      • Initial Explorations
      • Stored Procedures
    • select-tricks
      • Over Partition
      • Stored Procedures*
      • Creating Parameters
  • python
    • Working with Files
    • Classes in Python
    • Dictionaries
    • Working with Strings
    • Using Lambda
    • Seaborn
    • machine-learning
      • Learning Pandas
      • MatPlotLib! The Dreaded Line Graph...
      • matlab-qualgraphs-notes
      • Linear Regression Example
      • kNN Analysis in ScikitLearn
    • Neat Snippets
  • bash
    • helpful_cmd
  • math
    • Basic Definitions
    • Linear Regressions
    • Meaningful Sampling
Powered by GitBook
On this page

Was this helpful?

  1. sql
  2. performance

Stored Procedures

Making known processes faster

As an important step for making routine needs faster, stored procedures (with the right database) can yield some great speed returns.

CREATE PROCEDURE aht_report @dept varchar(255)
    AS
    SELECT agent_id, agent_name, aht
    FROM agents
    WHERE agent_dept == @dept
GO;

EXEC aht_report @dept = 'sales';

This requires the user to have the right permissions to be able to make a procedure, and too many procedures can start to bog down a database. Nonetheless, this is a hugely helpful tool for running reports quickly.

PreviousInitial ExplorationsNextselect-tricks

Last updated 3 years ago

Was this helpful?