# Blog

- [Creating a stored procedure in Microsoft SQL Server](/creating-a-stored-procedure-in-microsoft-sql-server) — Creating a Stored Procedure in Microsoft SQL Server
- [What is an aggregate function?](/what-is-an-aggregate-function) — An aggregate function where the values are grouped together to form a single response. The more common SQL aggregate functions are SUM, COUNT, AVG, MIN and MAX.
- [Handling Strings in SQL Server](/handling-strings-in-sql-server) — “How could I split a SQL field by a delimiter?”, “How could I get with the first word of a SQL field?”, “How could I get the first three letters of an SQL field?”
- [How to use Parameters in Stored Procedures?](/how-to-use-parameters-in-stored-procedures) — The Stored Procedures are an elegant way to store your code inside a SQL database. You can save your code and reuse it whenever you want to.
- [How to use a QUALIFY clause in SQL?](/how-to-use-a-qualify-clause-in-sql) — Qualify may be one of the most underestimate commands in SQL, as a Data Analyst, I use it a lot and I really hope after this tutorial you use it too.
- [Why is my SQL query taking so long?](/why-is-my-sql-query-taking-so-long) — This is one of the questions we almost always ask ourselves.
In this article, we are going to learn a bit about how to make an efficient query.