May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
Last Used Stored Procedure

SQL SERVER – Last Used Stored Procedure

October 25, 2021
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Stored Procedure

“Is there any way to know the last used stored procedure in SQL Server?” Well, I was asked this during Health Check. 

Read More
Procedure Template

Snowflake – Stored Procedure Template in JavaScript

September 30, 2021
Pinal Dave
SQL Tips and Tricks
JavaScript, Snowflake, SQL Server, SQL Stored Procedure

Many SQL developers do not know it well. For everyone to use, I am going to share the Stored Procedure Template in JavaScript for Snowflake.

Read More
procedure definitions

SQL SERVER – Easiest Way to Copy All Stored Procedure Definitions

September 8, 2021
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Management Studio, SQL Stored Procedure, SSMS

What is the easiest way to copy all stored procedure definitions for your database? Well, let us quickly learn that today.

Read More
Time of Stored Procedure

SQL SERVER – Execution Time of Stored Procedures

August 11, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Statistics, SQL Stored Procedure, SSMS

How to measure the execution time of the stored procedure when it contains lots of statement inside of it. Let us learn today about Stored Procedures

Read More
getcolnames

SQL SERVER – Get Column Names

February 25, 2021
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Scripts, SQL Server, SQL Stored Procedure

A very common question, I keep on getting is how to get column names for a particular column. Well, it is pretty straightforward and easy to do.

Read More
Hide in Code

Hide Code in SSMS – SQL in Sixty Seconds #154

February 3, 2021
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Server Encryption, SQL Server Management Studio, SQL Server Security, SQL Stored Procedure, SSMS

I have received so many emails from all of you to create a video on the topic of SQL SERVER – Hide Code in SSMS. Here is the video on the topic.

Read More
hide code

SQL SERVER – Hide Code in SSMS

February 2, 2021
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Encryption, SQL Server Management Studio, SQL Server Security, SQL Stored Procedure, SSMS

Today we are going to learn something very simple but asked a lot by all of you as well as my client is that how to hide code in SSMS.

Read More
Previous 1 2 3 4 5 … 30 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version