SQL Server Education (by the geeks, for the geeks)
This feature was introduced in SQL Server 2012. Using With Result Sets option with Execute Command we can change the column name and data type of returning result set. Ex: Use TempDB Go …
How to redefine the returning result sets of a stored procedure? Read MoreThis blog covers simple yet useful tips and optimization to improve stored procedure performance. 1. Use SET NOCOUNT ON SQL Server returns informational messages when running select or DML operations. In …
Improve stored procedure performance in SQL Server Read MoreMany a times need arises to find objects a stored procedure depends on. The blogs describes a way to find dependencies of stored procedure in SQL server. The below query creates …
Find dependencies of stored procedure in SQL Server Read MoreHere is quick query to find stored procedure related to column in database. This comes handy when you have to alter/remove a particular column from a table and you need to …
Find stored procedure related to column in database in SQL Server Read MoreMany a times need arises to find all stored procedures related to a table in the database. The below queries come handy then. — Query 1 SELECT DISTINCT objects.name, objects.type, comments.text …
Find stored procedure related to table in database in SQL Server Read MoreThis blog is part of the series The SQL Server TSQL Classes: Stored Procedure The links to previous post are given below. https://www.sqlservergeeks.com/sql-server-stored-procedures-the-tsql-classes-stored-procedures-a-primer/ https://www.sqlservergeeks.com/sql-server-tsql-the-tsql-classes-stored-procedures-nested-proc-recursion-and-plan-caching/ https://www.sqlservergeeks.com/blogs/AhmadOsama/personal/777/the-tsql-classes-stored-procedures-parameter-sniffing https://www.sqlservergeeks.com/sql-server-tsql-the-tsql-classes-stored-procedures-parameter-sniffing-resolution/ https://www.sqlservergeeks.com/sql-server-tsql-the-tsql-classes-stored-procedures-error-handling/ In last class I …
SQL Server TSQL – The TSQL Classes Stored Procedures: Transaction Handling Read MoreThis blog is part of the series The TSQL Classes: Stored Procedure The link to previous post are given below. https://www.sqlservergeeks.com/sql-server-tsql-the-tsql-classes-stored-procedures-nested-proc-recursion-and-plan-caching/ https://www.sqlservergeeks.com/sql-server-stored-procedures-the-tsql-classes-stored-procedures-a-primer/ https://www.sqlservergeeks.com/sql-server-tsql-the-tsql-classes-stored-procedures-parameter-sniffing-resolution/g In last class, I talked about parameter sniffing; a …
SQL Server TSQL – The TSQL Classes Stored Procedures: Parameter Sniffing Resolution Read MoreThis blog is part of the series The TSQL Classes: Stored Procedure. https://www.sqlservergeeks.com/sql-server-tsql-the-tsql-classes-stored-procedures-nested-proc-recursion-and-plan-caching/ https://www.sqlservergeeks.com/sql-server-stored-procedures-the-tsql-classes-stored-procedures-a-primer/ In the last class I talked about plan caching and how it speeds up the stored procedure execution …
SQL Server TSQL – The TSQL Classes Stored Procedures: Parameter sniffing Read MoreThis blog is part of series The TSQL Classes: Stored Procedures. Introduction: To put simply, a SQL Server stored procedures is set of queries put together primarily to reuse a complex/iterative …
SQL Server Stored Procedures – The TSQL Classes Stored Procedures: A Primer Read More